Course Description

Advanced SQL Query Building

Course Code: G-555
Recommended Duration: 2 Days


The student will learn to use the EXPLAIN facility to understand physical access paths in DB2, to practice developing complex queries, and to assess the performance implications of various SQL coding techniques.


Experienced DB2 programmers who need to construct complex, efficient queries using SQL, or who need to tune existing complex queries for performance.


Experience coding SQL queries, using either SPUFI or QMF.

Related IBM Materials

This course is drawn from this IBM manual; access to it in the classroom is desirable but not required:

DB2 SQL Reference (current version)


Major Topics Include



There are seven machine exercises





Course Objectives
Topical Outline
Home page