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   ? - $ 697 (CAD)  ? Up to 3 - $ 1,397 6 - $ 1,997    ? Plus - $ 197
 
Mon Jul 17, 2017
Ottawa
Mon Jul 24, 2017
Toronto
Mon Aug 28, 2017
Ottawa
Mon Sep 11, 2017
Toronto
Contact us to arrange your preferred location and date

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