This 3 day course is designed to present some application design topics that can improve performance, using DB2 for UNIX and WINDOWS. SQL statements will be used to create objects for application design and development. Design issues of referential Integrity, table check constraints, generated columns, user defined data types, functions, stored procedures and triggers will be reviewed. Advanced techniques for using SQL will be applied in workshops. Design issues will be considered which effect concurrency, integrity and performance. Basic UDB administration functions will be reviewed and some DB2 utilities will be used.

Application developers and designers.

Upon successful completion of this course, the student will be able to:

• Create relational objects for application development.
• Use advanced SQL queries to access and manipulate data on DB2 tables.
• Review and use different methods of improving performance.
• Understand the DB2 locking strategy for improving concurrency and maintaining data integrity.
• Use IMPORT, EXPORT and LOAD utilities to manipulate data.

• Creating Objects
• Logical design for performace
• SQL Review - optional unit
• Advanced SQL
• Commits and Batch Programs
• Performance for SQL and Applications
• Data Access and EXPLAIN
• The DB2 Optimizer
• Program BIND Options
• Stored Procedures - Overview
• DB2 LOCKING
• DB2 Data Management
• IMPORT/EXPORT/LOAD Utilities

Relevant Operating Systems experience. Programming experience (basic skills). Previous experience with relational database systems and SQL.