DB2 UDB Application Design for Performance for UNIX and Windows

This 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. [..]

Objectives:
	After completing this course the student should 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.

Target Audience:
	Application developers and designers.

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

Format:
	Classroom instruction and review with hands-on workshops.

Duration:
	Three days.

Outline for DB2 UDB Application Design for Performance for UNIX and Windows

Day 1

Creating Objects
Logical design for performance
SQL Review - optional unit
Advanced SQL

Day 2

Commits and batch programs
performance for SQL and Applications
Data Access and EXPLAIN
The DB2 Optimizer
Program BIND Options
Stored Procedures - overview

Day 3

TRIGGERS, UDT and UDF
DB2 LOCKING
DB2 Security
DB2 Data Management
IMPORT/EXPORT/LOAD utilities