DB2 UDB Administration Workshop (Windows) UK Classes & Lessons (IBM DB2)

Also known as: CF23N7GBGB

About this class

This course teaches you how to perform basic database administration tasks using IBM DB2 Universal Database(TM). These tasks include creating and populating databases and implementing a logical design to support recovery requirements.

Who will the lesson benefit?

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

What delegates will learn

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
Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
Describe the application development process with respect to DB2 considerations

What prerequisites are required

Before taking this course you should be able to:

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)

Contents of this class

Overview of DB2 Universal Database
Getting Started with DB2 UDB GUI's
Creating Databases and Tablespaces
Creating Objects
Moving Data
Recovery
Monitoring/Problem Determination
Concurrency
Application Alternatives
Application Performance
Security

Follow On Course

s of interest are CF45U, CF41U, and CF49N2GB.

DB2 Universal Database Advanced Administration Workshop (CF45U)
DB2 UDB Performance Tuning & Monitoring Workshop (CF41U)
DB2 UDB Advanced Recovery for Single Partition Databases (CF49N2GB)