Back to Search Results

Training Course Summary:

Learn how to perform basic database administration tasks using IBM DB2 Universal Database, which include creating and populating databases and implementing a logical design to support recovery requirements.

Pre-Requisites:

You should be able to:
o Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
o State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
o Discuss basic relational database concepts and objects such as tables, indexes, views, and joins.

These skills can be developed by taking
o OS Training
o AIX 5L Basics
o Linux Basics and Administration
o Windows Systems Administration
o Or by having equivalent HP-UX or Solaris administration experience
o DB2 SQL Workshop
o DB2 Universal Database Fundamentals.
AIX 5L Essentials: AIX 5L Basics (AP13V3)
Linux Power User (LX02GB)
Linux System Administration (LX03GB)
DB2 Family Fundamentals (CF03U)
DB2 SQL Workshop (CF12GB)

Who Should Attend:

Database Administrators and other technical personnel who are involved in planning, implementing, and maintaining DB2 databases.

Training Course Overview/Content:

On completion you will be able to:
o List and describe the components of DB2 Universal Database
o Implement DB2 security
o Perform basic administration of a DB2 database system
o Define a basic DB2 recovery strategy and perform the tasks necessary to support the strategy
o Describe the application development process with respect to DB2 considerations.