This 4 day course provides "how to" information on the design of DB2 databases and applications. The course utilizes the Database System Life Cycle. The four major phases of the DBLC include: Conceptual Design, Logical Design, Physical Design, and Design Implementation. It is assumed that the Conceptual Design phase has been completed, and that the conceptual data model with the base Entity Diagrams and the process model with all major process requirements identified, have been completed and accepted. The major focus of the course will be on the Logical, Physical and Implementation of Relational Database Systems as they apply to DB2.

DB2 Database Administrators, DB2 Project Leaders and Analysts, and Application Personnel who will be designing and implementing DB2 Databases and Application Systems.

After completing this course, the student should understand:

• Logical Design
• Physical Design
• Design Implementation

• Introduction
• Conceptual Design Flow
• DB2 Composite Logical Design
• DB2 Physical Design
• DB2 Design Reviews
• DB2 Design Implementation

Introduction to DB2, SQL coding basics, Logical Data Modeling (optional but helpful), Process Modeling (optional but helpful).