DB2 for z/OS and SQL v9 Course

Upon completion of this course, the participant will be able to:

> Explain DB2 concepts, terminology and components
> Discuss the Primary Key (PK) and Foreign Key (FK) concept
> SELECT rows of data from DB2 tables
> Use QMF and/or SPUFI to "run" SQL statements
> Use the WHERE clause to SELECT specific rows of a DB2 table
> Build queries using the ORDER BY, GROUP BY, HAVING clauses
> JOIN tables together to get information from each
> CREATE Tables, Indexes, Views
> "Change" tables using the INSERT, UPDATE, DELETE statements
> Discuss the major considerations for DB2 Application Performance Tuning
> Identify “good” predicates & “bad” predicates

The following “Release Dependent” features can be covered as needed:

> Version 8 – Table-Controlled Partitioning, Common Table Expression, Dynamic Scrollable Cursors, multi-row FETCH and INSERT, GET DIAGNOSTICS, Recursive SQL, Sequence Objects, Scalar Full Select, Select Statement In An Insert statement, Delimited LOAD / UNLOAD, MQT’s
> Version 9 – PureXML, New Data Types - bigger BINARY, VARBINARY, BIGINT, DECFLOAT, INSTEAD OF triggers, INTERSECT and EXCEPT, TRUNCATE Statement, MERGE Statement, Native SQL Stored Procedures, Optimistic Concurrency Control, Automatic Object Creation, Skip Locked Data, REOPT (AUTO)

Introduction to DB2
Course Introduction
DB2 - Concepts, and Terminology

Structured Query Language (SQL)
SQL 1 - The SELECT Statement

Hands-on Lab - SELECT
Database 2 Interactive
SQL 2 - Special Features

Hands-on Lab - SELECT / Special Features
SQL 3 - ORDER BY, GROUP BY, HAVING

Hands-on Lab - ORDER BY, GROUP BY, HAVING
SQL 4 - Join, Sub-select, UNION

Hands-on Lab - Join, Sub-select, UNION
SQL 5 - Data Definition Language
SQL 6 - INSERT, UPDATE, DELETE

Hands-on Lab - Creating DB2 Components
- INSERT, UPDATE, DELETE
SQL 7 - Data Control Language

Appendices
Appendix A - IBM Sample Tables
Appendix B – Bibliography
Appendix D - EXPLAIN PLAN & Tables
Appendix E - Hints to Success
Appendix F – SQLCODES / SQLSTATES
Appendix G – QMF Overview
Appendix H – Stored Procedures 
Appendix I – DB2 for WINDOWs Overview
Appendix J – Additional Features - UDT/UDF, Trigger
Appendix K – Group By Extensions
Appendix L – Visual Explain Overview
Appendix Z8 - Changes Summary - DB2 V8
Appendix Z9 - Changes Summary - DB2 V9
Appendix Z9B- DB2 V9 Summary from IDUG Journal