DB2 11 for z/OS Concepts and Facilities

Why take this course?

After completing this course, you will be able to
  • describe the major characteristics of the Relational Model.
  • recognize the basic components of the DB2 11 product, and its major operating platforms.
  • understand referential integrity.
  • understand basic Structured Query Language programs.
  • understand how DB2 affects the application development environment and process.
You will also
  • become familiar with fundamental DB2 objects.
  • learn more about DB2's security mechanism.
This introductory course explores IBM's strategic, relational database product, providing a comprehensive overview of DB2. Topics range from an introduction to relational database concepts to an overview of the Structured Query Language (SQL). We'll also give you a brief review of the DB2 application development environment.Information Technology staff at any level who need a basic introduction to DB2.

Who should attend?

Anyone who uses DB2-based applications in their day-to-day work will also benefit from this seminar.

Any prerequisites?
No database experience is necessary, although you should be familiar with basic data processing concepts.

Dates and Fees

1 Day   ? - $ 397 (CAD)  ? Up to 3 - $ 737 Up to 6 - $ 1,104    ? Plus - $ 187
 
Mon Sep 12, 2022
Online
Contact us to arrange your preferred date and/or in-class training

What Topics are covered

Relational Database Concepts
  • The Relational Model
  • Structure
  • Keys
  • Integrity
  • Manipulation
  • Data Models
  • Mapping business data
  • Entity types
  • Relationships
  • Attributes
DB2 Components and Features
  • DB2 Objects
  • Database
  • Storage Group
  • Tablespace
  • Table
  • Column
  • Index
  • Indexspace
  • View
  • Synonym
  • Alias
  • Object Dependency
  • Column datatypes
  • Primary key
  • Foreign key
  • Referential integrity
The z/OS DB2 Environment
  • DB2 environment
  • The DB2 subsytem
  • DB2 attachments
  • DB2 connections
  • DB2 access
  • Application development tools
  • The DB2 catalog
  • Using the catalog
  • Catalog tables
  • Security
Introduction to SQL
  • What is SQL?
  • The base language
  • Executing an SQL statement
  • Simple SELECT statement
  • SPUFI Demo