Advanced DB2 Application Programming - Course Objectives

On successful completion of this course, the student, with the aid of the appropriate reference materials, should be able to:

1. Use the EXPLAIN facility in DB2 to understand the physical access strategies used in fulfilling DB2 queries
   
2. Construct complex queries in SQL, using aggregation, relational joins, and subqueries to accomplish efficient data retrieval from multiple tables
   
3. Understand and use packages as part of application development
   
4. Use the DB2 LOAD and UNLOAD utilities to populate and maintain tables
   
5. Work efficiently with Large Objects (LOBs) in application programs
   
6. Define, write, and invoke DB2 stored procedures and user-defined functions
   
7. Know when and how to use dynamic SQL in application programs
   
8. Define and use user-defined SQL functions
   
9. Use the Call Attachment and Recoverable Resource Attachment facilities as alternative mechanisms for DB2 application programs
   
10. Understand and use the ODBC (call level) interface to DB2
    
11. Write REXX programs that perform DB2 data access
    
12. Understand how locking affects application development and performance in DB2.

Course information: G-562 / 5 Days   These Materials © Copyright 2007 by Hunter Cobb    V1.x

Topical outline
Course description
Home page

this page last updated: 18 January, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.