Learn your way around DB2 on the System i with these great offerings.
 |
 | | Working with DB2 Databases (Online Series)
This series contains the following courses: Introduction to DB2 Databases
Creating and Managing Physical Files
Creating and Managing Logical Files
Processing a DB2 Database
Using Triggers
Using Referential Integrity
Working with DB2 Databases Competency Exam
|
|
|
 | | Introduction to DB2 (Online Course)
DB2 Concepts
Physical Files
Logical Files
Accessing a Database
Database Tools and Products
|
|
|
 | | Creating and Managing Physical Files (Online Course)
DDS Basics
Defining a Data Physical File
Creating a Physical File
Using a Field Reference File
Working with Physical Files
|
|
|
 | | Creating and Managing Logical Files (Online Course)
Defining a Simple Logical File
Defining a Join Logical File
Defining a Multiple-Format Logical File
Creating a Logical File
Working with Logical Files
|
|
|
 | | Processing a DB2 Database (Online Course)
Processing Files in a High-Level Language Program
Overriding Database File Processing Options
Sharing Database Files
Using the OPNQRYF Command
|
|
|
 | | Using Triggers (Online Course)
Introduction to Triggers
Coding a Trigger Program
CL Commands for Working with Triggers
Trigger Program Design and Performance Considerations
|
|
|
 | | Using Referential Integrity (Online Course)
Introduction to Referential Integrity
Defining Constraints
Working with Constraints
Detecting Constraint Violations in an Application
|
|
|
 | | Working with DB2 Databases (Online Competency Exam)
This Competency Exam tests your mastery of the objectives for the courses that make up the Working with DB2 Databases series:
Introduction to DB2
Creating and Managing Physical Files
Creating and Managing Logical Files
Processing a DB2 Database
Using Triggers
Using Referential Integrity
The exam is divided into separate parts, one for each course in the series. Successfully completing all parts of the exam demonstrates your proficiency in the skills required to create a DB2 database and develop applications that process that database.
|
|
|
 | | AS/400 Database Administration I (Audio Training)
AS/400 Database Administration I is a self-paced audiocassette course providing comprehensive, practical training in the description and creation of physical and logical files.
|
|
|
 | | AS/400 Database Administration II (Audio Training)
AS/400 Database Administration II is a self-paced audiocassette course providing comprehensive, practical training in the design and implementation of databases.
|
|
