DB2 UDB for z/OS System Fundamentals

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is designed to be a comprehensive introduction to the IBM DB2 Product. Topics include Data Structures, Relational Databases and Tables, Types of Relational Databases, Relational Architecture, DB2 Components and DB2 Database Administration. In addition, students will be introduced to Structured Query Language and Query Management Facility..

PREREQUISITES: Some knowledge of data processing concepts and facilities.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

This course is designed for DB2 Users, and Technicians that need to understand DB2 concepts and facilities. The course can accomodate an audience that varies from application users to system programmers..
KEY HIGHLIGHTS:
  • Relational Concepts
    • Sets, Domains, and Relations
    • Primary Key & Foreign Keys
    • Selection, Projection, and Join
    • Rules For A Relational DBMS
    • Relational Advantages
    • Relational Disadvantages
  • DB2 Concepts
    • DB2 Environment
    • Tables and Views
    • Keys
    • Indexspaces and Indexes
    • SQL Overview
    • Static vs. Dynamic SQL
    • DB2 Catalog Overview
    • Attachments
  • DB2 Architecture
    • Architecture Overview
    • The 5 DB2 Address Spaces
    • DB2 Catalog and Directory
  • Database Design
    • Data Analysis, Entities, and Attributes
    • Relationships & Normalization
    • Table Design and Column Design
    • Table Exit Routines & Constraints
    • Keys and Referential Integrity
  • Data Definition Language
    • Logical and Physical Data Objects


  • Data Manipulation Language
    • SELECT Verb
    • Column, Table/View Options
    • INSERT, UPDATE, DELETE
    • Select Criteria
    • Inner and Outer Joins
    • Subqueries
    • GROUP BY and ORDER BY Options
    • Union and Built-in Functions
    • Exists
    • Any and All
    • Correlated Subquery
    • Other functions
  • DB2I & SPUFI
    • DB2I , DCLGEN and SPUFI
    • Change Defaults
  • Query Management Facility
    • Architecture
    • Using QMF Query Facility
    • Form & Reports
    • Prompted Query
    • Draw
  • Application Environment
    • Program Preparation
    • Database Request Module
    • Precompile
    • Bind/Rebind
    • Plans & Packages
  • Access Paths
    • DB2 Optimizer
    • Access Paths & EXPLAIN
    • Filter Factors


  • Security and Authorization
  • Locking
    • Lock Types
    • Duration
    • Modes
    • Timeout
    • Deadlock
    • Commit/Rollback
  • Utilities and Commands
    • Utilities Overview
    • Backup & Recovery
    • Performance Maintenance
    • Integrity
    • Utility Phases
  • Distributed Data Facility
    • Distributed Data & DRDA Overview
    • DDF Components
    • Session Flow
  • Shared Data & DB2 Data Sharing with SYSPLEX
    • Shared Database Overview
    • Access from Multiple Processors

FROM OUR STUDENT EVALUATIONS...
"Excellent class. Brought all the bits and pieces that I have gathered over the years together."

Leroy G. Kraatz
Texas Comptroller of Public Accounts

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.