G562: 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 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



Comments are closed.