htalogo2.gif

Course Description

Advanced SQL Query Building

Course Code: G-555
Recommended Duration: 2 Days

Benefits

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.

Audience

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

Prerequisites

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

 

Exercises

There are seven machine exercises

 

 

 

 

Course Objectives
Topical Outline
Home page