DB2 for z/OS SQL Programming Course

Description

The course teaches the basics of application programming using the SQL language for Version 7 of IBM's DB2 UDB for z/OS and OS/390 database management system. It is intended for analysts, programmers, and anyone with a need to understand DB2 SQL programming. The course includes practical exercises.

Duration

3 days

Course Outline

1 Relational Database Concepts
 - The Relational Model.
 - Data Structure Rules.
 - Relationships.
 - The Relational Operators.
 - Integrity Rules.
 - DB2 and the Relational Model.

2 DB2 Features
 - What is DB2?
 - What is SQL?
 - DB2I.

3 DB2 Objects
 - Tables.
 - Databases.
 - Tablespaces.
 - Built-In and Distinct Data Types.
 - Indexes.
 - Free Space.
 - Large Objects.
 - The DB2 Catalog.

4 Program and User Interface
 - The SQL language.
 - Dynamic and Static SQL.
 - Data Definition.
 - Data Manipulation.
 - Select.
 - The Optimizer.
 - Constants.
 - Views, Synonyms, and Aliases.
 - Embedded SQL.
 - Host Variables and Cursors.
 - Nulls.
 - Special Registers.
 - End User Access.
 - DB2 Utilities.

5 Reading Data
 - Select.
 - Selection Criteria.
 - Arithmetic.
 - Built-In and User Defined Functions.
 - Group By.
 - Select Distinct.
 - Case.

6 Access Paths
 - Tablespace Scan
 - Matching Index Scan.
 - Non-Matching Index Scan.
 - Catalog Statistics.
 - Explain.

7 Multi-Table Select
 - Inner and Outer Join.
 - Subquery.
 - Row Value Expressions.
 - Union.
 - Nested Table Expressions.

8 Updating and Integrity Control
 - Adding New Rows.
 - Deleting Rows.
 - Updating Rows.
 - Concurrency.
 - Unit of Work.
 - Locking.
 - Deadlocks.
 - Commit and Rollback.
 - Entity and Referential Integrity.
 - Table Check Constraints.
 - Triggers.

9 Security
 - Granting and Revoking Privileges.
 - Bundled Privileges.

10 Other Things
 - Temporary Tables.
 - Scrollable Cursors.
 - Distributed Database.
 - Stored Procedures.