DB2 UDB for z/OS System Fundamentals & Programming

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is designed to be a comprehensive introduction to the DB2 SQL Programming Environment. Topics include Data Structures, Relational Databases and Tables, Types of Relational Databases, Relational Architecture, DB2 Components and DB2 Database Administration. This course is an extension of our DB2 UDB for OS/390 System Fundamentals Course, but it concentrates on the Programming Environment.

PREREQUISITES: Knowledge of TSO/ISPF, a programming language (COBOL will be used for demonstration purposes) and an understanding of basic programming concepts.

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

AUDIENCE

Programmers, Analyst, and Managers that need to understand how to design, develop, and code a DB2 application using a common programming language.
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
  • 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
    • Table/View Options
    • Inner and Outer Joins of Two Tables
    • Subqueries
    • GROUP BY, ORDER BY
    • Union and Built-in Functions
    • INSERT, UPDATE, DELETE
  • DB2I & SPUFI
    • DB2I , DCLGEN and SPUFI
    • Change Defaults
  • Application Programming
    • Program Structure & Host Variables
    • Cursor Processing
    • Error Handling
    • Program Preparation
  • Access Paths
    • DB2 Optimizer
    • Access Paths & EXPLAIN
    • Filter Factors
  • DB2 Architecture
    • Architecture Overview
    • The 5 DB2 Address Spaces
    • DB2 Catalog and Directory


  • Security and Authorization
  • Locking
  • 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.