DAY 1
Review of DB2
Course Introduction
DB2 - Concepts, and Terminology
Structured Query Language (SQL)
SQL 1 - The SELECT Statement
Database 2 Interactive
SQL 2 - Special Features
SQL 3 - ORDER BY, GROUP BY, HAVING
SQL 4 - Join, Sub-select, UNION
SQL 5 - Data Definition Language
SQL 6 - INSERT, UPDATE, DELETE
SQL 7 - Data Control Language
SQL 8 - Other SQL Topics
Hands-on Lab - SQL Review and Refinement
Question and Answer Session
DAY 2
DB2 Performance Considerations - Overview
DB2 Catalog and Runstats
Concepts In DB2 Efficiency
DB2 Additional features - User Defined Distinct Types / User Defined
Functions (Appendix K), Triggers (Appendix M), New Scalar/Column
Functions (Appendix J)
Other Advanced Topics - CUBE, ROLLUP, GROUPING SETS
Other Advanced Topics - Recursive SQL
Hands-on Lab - SQL Review and Refinement
Appendices
Appendix A - IBM Sample Tables Appendix I - "Common" SQL Errors
Appendix B – Bibliography Appendix J – Version 6 Functions Summary
Appendix C - DB2 SQL Advanced Workshop Appendix K – User Defined Data Types (UDT) and User Defined Functions UDF
Appendix D – EXPLAIN PLAN Statement and PLAN_TABLE and DSN_STATEMNT_TABLE Appendix L - Cast Testing
Appendix E – Hints to Success Appendix M - Trigger Introduction
Appendix F – SQLCODES / SQLSTATES Appendix Z6 - DB2 Version 6 Summary
Appendix G – QMF Overview Appendix Z7 - DB2 Version 7 Summary
Appendix H – Stored procedures – Version 5