DB2 Concepts and Facilities for z/OS

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 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.
1 Day : Fee - $ 697.00 (CAD) :  ? Multi-seat - $ 497.00 (CAD)
Mon Feb 15, 2016
Mon Mar 14, 2016
Mon Apr 11, 2016
Mon May 2, 2016
Contact us to arrange your preferred location and date
You will also
  • become familiar with fundamental DB2 objects, including Universal Data Base support.
  • 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.

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.

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