DB2 UDB for Windows – SQL Workshop Course

First, the concepts of DB2 are presented and discussed.

The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components).

Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data. The Command Editor or similar interface is used to execute SQL statements. Referential Integrity concepts and implementation are covered.

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 The Command Editor 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
> Move data from a DB2 table to an Excel Spreadsheet

DAY 1
 I. Introduction to DB2
     Course Introduction
 1. DB2 - Concepts, and Terminology
II. Structured Query Language (SQL)
 2. SQL 1 - The SELECT Statement
Hands-on Lab - SELECT
 3. The Command Editor
 4. SQL 2 - Special Features
Hands-on Lab - SELECT / Special Features
 5. SQL 3 - ORDER BY, GROUP BY, HAVING
Hands-on Lab - ORDER BY, GROUP BY, HAVING

DAY 2
II. Structured Query Language (SQL) (Continued)
 6. SQL 4 - Join, Sub-select, UNION
Hands-on Lab - Join, Sub-select, UNION
 7. SQL 5 - Data Definition Language
 8. SQL 6 - INSERT, UPDATE, DELETE
Hands-on Lab - Creating DB2 Components
             - INSERT, UPDATE, DELETE
 9. SQL 7 - Data Control Language

Appendices
Appendix A - IBM Sample Tables
Appendix B – Bibliography
Appendix E - Hints to Success
Appendix F – SQLCODES / SQLSTATES
Appendix G – QMF Overview
Appendix H – Stored Procedures
Appendix I - "Common" SQL Errors
Appendix K – UDT / UDF
Appendix L - Cast Testing
Appendix M – Trigger Introduction