This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | E5973 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 1.0 days | Delivery type | Classroom |
| Course type | Public only | ||
| Public price | USD $399.00 plus tax | ||
This is a special one-day offering being presented on Sunday, October 25, 2009 in conjunction with the IBM Information on Demand 2009 Conference in Las Vegas, Nevada. Registration for the IOD Conference is NOT required to attend this Sunday class.
This training is designed to introduce you to the concepts you must know in order to take and pass the DB2 9.7 DBA for Linux, UNIX and Windows certification exam (Exam 541). The material for this course is aligned with the 541 exam objectives.
Audience
This is an intermediate course for DB2 9.7 Database Administrators. It is suggested that you take and pass the DB2 9 Family Fundamentals Certification Exam (Exam 730) before taking this training; however, that is not a prerequisite.
Prerequisites
It is suggested that you take and pass the DB2 9 Family Fundamentals Certification Exam (Exam 730) before taking this training; however, that is not a prerequisite.
Skills taught
- Introduce you to basic DB2 9.7 Database Administration fundamentals.
- Provide you with the information needed to correctly answer questions they are likely to see on the DB2 9.7 for Linux, UNIX and Windows Database Administration Certification Exam (Exam 541).
- Provide you with an overview of the certification testing software.
Course outline
Introduction
Certification Exam 541 Concepts
- 1. Section 1 - DB2 Server Management
- 1.1. Demonstrate the ability to configure/manage DB2 servers, instances, and databases (e.g. scope)
- 1.2. Demonstrate the ability to schedule jobs
- 1.3. Demonstrate the ability to use autonomic features
- 2. Section 2 - Physical Design
- 2.1. Demonstrate the ability to create a database and manipulate various DB2 objects
- 2.2. Demonstrate knowledge of partitioning capabilities
- 2.3. Demonstrate knowledge of XML data objects
- 2.4. Demonstrate knowledge of compression
- 3. Section 3 - Business Rules Implementation
- 3.1. Demonstrate the ability to create constraints on tables
- 3.2. Demonstrate the ability to create views WITH CHECK OPTION
- 4. Section 4 - Monitoring DB2 Activity
- 4.1. Demonstrate the ability to use Admin views and SQL functions for monitoring
- 4.2. Demonstrate the ability to use Work Load Manager
- 4.3. Demonstrate the ability to use additional auto-monitoring tools
- 4.4. Demonstrate the ability to identify the functions of Problem Determination Tools
- 4.5. Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
- 5. Section 5 - Utilities
- 5.1. Demonstrate the ability to use the data movement utilities
- 5.2. Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
- 5.3. Demonstrate the ability to use the DB2 Advisor utility
- 5.4. Describe the purpose of Data Studio Administrator
- 6. Section 6 - High Availability
- 6.1. Describe DB2 data integrity actions
- 6.2. Demonstrate the ability to perform database-level and table space level backup and recovery operations
- 6.3. Demonstrate the ability to configure and manage HADR
- 7. Section 7 - Security
- 7.1. Describe DB2 authentication
- 7.2. Describe DB2 authorizations and privileges
- 7.3. Describe the ability to set and remove user, group, and role authorities and privileges
- 7.4. Demonstrate general knowledge of the Audit facility
- 7.5. Demonstrate knowledge of the DB2 Security Infrastructure
- 8. Section 8 - Connectivity and Networking
- 8.1. Demonstrate the ability to configure database connectivity
- 8.2. Demonstrate knowledge of using JDBC/SQLJ connections with DB2
Overview of the Certification Testing Software
Questions and Comments
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
