DB2 UDB for Experienced SQL Developers

Course Number:  705-JK
Recommended Duration:  3 days

Intended Audience
Experienced SQL programmers who need to work with DB2 UDB Databases, both from a Command Line perspective and from within application programs.

Objectives
Students who complete this course will be able to code SQL statements to access DB2 UDB objects by typing SQL and from within application programs (in the student's standard host environment)

DB2 UDB Version 8.1.  Most of the class is suitable for those earlier versions of DB2 UDB (DB2 UDB 7).

Prerequisites
The student should have SQL experience and at least 6 months experience designing and coding application programs or have completed a basic programming course within the last 12 months.  Familiarity with the available editor and execution environment is required.

Topics

• DB2 UDB concepts

• DB2 Clients: Run-time, Administration, SDK

• Control center

• Command line processor

• Warehousing features: CUBE, ROLLUP, Analytic functions

• COMMIT/ROLLBACK

• Joins and subqueries

• Review of advanced SQL syntax

• Creating tables and views

• Materialized query tables

• System catalog tables

• Cursors and locks

• Security and authorization

• DB2 extenders

• DB2 connect

• Database administration server

• Dynamic SQL

• Stored procedures and triggers

• Efficiency considerations: Optimizer, Explain, and Application Plans