| Title | Description | Duration | Outline |
|---|
|
DB2 -- Fast Track to Programming
|
Students will gain hands-on experience with the newest features of IBM's DB2 Version 9.
Students will learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and SQL Procedural Language extensions.
Coverage includes the special features and functions of the DB2, such as control of transactions, stored procedures, triggers, and cursors.
Good programming techniques and develop strategies for writing efficient applications will be emphasized.
Level: Introduction
|
3 Days
| |
|
Relational Database Design
|
This course is one common starting point for the entire database curriculum.
The objective of this course is to consider the logical design of relational
databases using a methodology known as semantic data modeling and related
practical techniques.
Level: Introduction
|
2 or 3 Days
| |
|
DB2 -- Performance and Tuning
|
This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning.
Following a review of the DB2 architecture, environment, and data structures,
course coverage includes index internals, block index MDC's,
access methods, and how to write effective SQL predicates.
'Explain' tables and tools are covered in detail as well as additional performance tools.
The optimizer is studied along with RUNSTATS to understand why index methods are chosen by the access plan.
Then MQT's, database partitions and table partitions are explored and their relationships.
Finally, monitoring with admin views is covered along with some performance suggestions
Level: Intermediate
|
2 Days
| |
|
Introduction to IBM DB2 for Sybase Developers
|
Provides the student that has prior SQL or Sybase ASE experience
with the necessary basic skills
and fundamental knowledge of IBM DB2 UDB.
It includes information on the overall architecture of DB2 UDB,
basic to advanced DB2 UDB SQL syntax,
creating and using SQL Stored Procedures,
and an overview of basic administrative tasks
including creation of databases, tables, views, indexes,
the extraction and insertion of data, security,
and backup and restore.
Level: Intermediate
|
3-4 Days
| |
