DB2 for z/OS Advanced SQL

PT9943
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
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

Related Scheduled Courses