The course teaches the basics of application development and testing for Version 7 of IBM's DB2 UDB for z/OS and OS/390 database management system. It is intended anyone involved in developing and/or testing DB2 applications. The course includes practical exercises.
3 days
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 and Compression. - Large Objects. - The DB2 Catalog. 4 Program and User Interface - The SQL language. - Dynamic and Static SQL. - Data Definition. - Data Manipulation. - Select. - The DB2 Optimizer. - Constants. - Views, Synonyms, and Aliases. - Embedded SQL. - Host Variables and Cursors. - Nulls. - Special Registers. - End User Access and SPUFI. - DB2 Utilities. 5 Reading Data - Select. - Selection Criteria. - Functions and Group By. - Arithmetics. - Join, Subquery, and Union. 6 Access Paths - Tablespace Scan - Matching Index Scan. - Non-Matching Index Scan. - Catalog Statistics. - Explain. 7 Updating & Integrity Control - Adding, Deleting and Updating Rows. - Concurrency and UOW. - Locking. - Commit and Rollback. - Entity and Referential Integrity. - Table Check Constraints. - Triggers. 8 Security - Granting and Revoking Privileges. - Bundled Privileges. 9 Plans, Packages and Bind. 10 Running Programs - DB2 Attachments. - Running TSO and Batch programs. - Running CICS and IMS programs. - Running Client/Server Programs. 11 Using the Catalog - Information on Tables, Indexes, and Views. - Information on Plans and Packages. 12 DB2 Utilities - Load and Unload. - Reorg, Runstats, and Check. 13 Other Things - Temporary Tables. - Scrollable Cursors. - Distributed Database. - Stored Procedures.