Advanced SQL via DB2 EXPLAIN

Course Code: DZOASE
Duration: 4 days
Audience: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.
Prerequisites: Completion of course DB2 SQL Essentials or equivalent knowledge.
Summary: After reviewing the usage and the scope and limits of SQL operations such as:
  • INNER JOINs
  • OUTER JOINs
  • UNIONs
  • CASE expressions
  • Subqueries
  • Subselects
  • Table expressions
  • Row expressions
  • Column/scalar functions
  • Date/time arithmetic
  • Cursor operations
  • Locking & concurrency
  • Index design & usage
this course focuses on using DB2 EXPLAIN (PLAN_TABLE and DSN_STATEMNT_TABLE) to optimise SQL statements in terms of elapsed, CPU and I/O times.
Objectives: Upon completion of this presentation, the participant should be able to exploit the DB2 Optimizer in deciding which of several SQL alternatives will provide reduced elapsed times, CPU and I/O.
Lab: About 65% hands-on, incorporating DB2 EXPLAIN
View full outline in PDF formatDetailed Outline

Course Schedule

Request a date for this course

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page