Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Overview 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. Audience Database Administrators and other technical personnel who are involved in planning, implementing, and maintaining DB2 databases. Skills Gained On completion you will 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 basic DB2 recovery strategy and perform the tasks necessary to support the strategy
- Describe the application development process with respect to DB2 considerations.
Prerequisites 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
- AIX 5L Basics
- Linux Basics and Administration
- Windows Systems Administration
- Or by having equivalent HP-UX or Solaris administration experience
- DB2 SQL Workshop
- 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)
Course Outline - Overview of DB2 Universal Database
- Getting Started with DB2 UDB GUIs
- Creating Databases and Table spaces
- Creating Objects
- Moving Data
- Recovery
- Monitoring/Problem Determination
- Concurrency
- Application Alternatives
- Application Performance
- Security
Follow On Course Follow On Course s of interest are CF45U, CF41U, and CF49GB. - DB2 Universal Database Advanced Administration Workshop (CF45U)
- DB2 UDB Performance Tuning & Monitoring Workshop (CF41U)
How to make a booking for the CF21N7GB course
|
