This course:
course objectives;
course outline
Other links:
DB2 curriculum;
Topic list;
Course list;
Home page
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
DB2 curriculum
Complete topics list
Home page
This page last updated: 17 November, 2011
This page copyright © 2011 by The Trainer's Friend, Inc.
This course copyright © 2011 by Hunter Cobb