Back to Search Results

Training Course Summary:

Perform basic database administration tasks using IBM DB2 Universal Database™. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. Learn a fastpath to DB2 UDB database administration skills for experienced relational DBAs. Skills needed for DB2 UDB Certification Test 510 will be presented.

Pre-Requisites:

Before taking this course you should be able to:
- Perform basic database administration tasks on a relational database system
- Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
- State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
- Discuss basic relational database concepts and objects such as tables, indexes, views, and joins

These skills can be developed by taking
- OS Training
- Windows Systems Administration
- DB2 SQL Workshop
- DB2 Universal Database Fundamentals
DB2 Family Fundamentals (CF03U)
DB2 SQL Workshop (CF12GB)

Who Should Attend:

Experienced Database Administrators and technical personnel on other relational database platforms who are involved in planning, implementing, and maintaining DB2 databases.

Training Course Overview/Content:

After completing this course, you should be able to:
- List and describe the components of DB2 Universal Database
- Implement DB2® security
- Perform basic administration of a DB2 database system
- Perform the tasks necessary to support a basic recovery strategy
- Describe the application development process with respect to DB2 considerations