GTS100 Introduction to DB2 9 for Relational DBAs

4 Days, $1000 per student.

Day 1

DB2 Architecture

SQL

Unions, Joins, Set Theory

Day 2

The DB2 Optimizer

Coding Efficient SQL

Changing Query Optimization

Explaining SQL with Visual Explain

Join methods

SQL Predicate Best Practices

Day 3

Index Design

More on predicates and selectivity

Restricting set sizes

DB2 Design Advisor

DB2 Utilities

Day 4

DB2 Utilities

DB2 Monitoring

DB2 Performance and Tuning

DB2 High Availability Disaster Recovery

Using the DB2 Information Center and other reference sources

 


DB Zone

Business 
       Partners