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 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
7. Know when and how to use dynamic SQL in application programs
8. Define, write, and invoke DB2 user-defined 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. Define and use native SQL stored procedures
13. Understand and use the XML data type in DB2
14. Understand how locking affects application development and performance in DB2.

© Copyright 2012, Hunter Cobb, www.TrainersFriend.com