Loading Course Schedule...
PT9943
Training Summary
This 3-day course for DB2 on z/OS covers intermediate SQL coding techniques. This course assumes a good understanding of basic SQL and builds on that knowledge to provide a good understanding of the entire SQL language as implemented within DB2. This class is heavily hands-on with exercises for each SQL related topic.
Prerequisites
This course assumes a good understanding of basic SQL and builds on that knowledge to provide a good understanding of the entire SQL language as implemented within DB2 for z/OS.
Duration
3 Days/Lecture & Labs
Audience
This course is designed for experienced DB2 developers
Course Topics
- Review of Common SQL Constructs
- Finding errors
- Accessing multiple tables
- More advanced constructs
- Functions
- Stored Procedures and Triggers
- Index Design
- Access path selection
- Explaining access paths
- Concurrency Control