Test 000-731: DB2 9 DBA for Linux UNIX and Windows

Course title: DB2 9 Administration Workshop for Linux
Course duration: 4.0 Days
Course number: CL201
Abstract:

This is the classroom version of Instructor Led OnLine (ILO) course DB2 9 Database Administration Workshop for Linux - Instructor Led Online (3L201)

This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced. Use a Linux operating system during hands-on labs.

This course replaces CF202 and is appropriate for those still using DB2 UDB V8.

Course Materials

The course materials address DB2 9.5 for Linux, UNIX, and Windows.

Hands-On Labs

Eleven labs are included to address DB2 9.5 for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

This is an intermediate course for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

Course title: DB2 9 Database Administration Workshop for UNIX
Course duration: 4.0 Days
Course number: CL211
Abstract:

This is the classroom version of Instructor Led Online (ILO) course DB2 9 Database Administration Workshop for UNIX - Instructor Led Online (3L211)

This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced. Use an AIX operating system during hands-on labs.

This course replaces CF212 and is appropriate for those still using DB2 UDB V8.

Course Materials

The course materials address DB2 9.5 for Linux, UNIX, and Windows.

Hands-On Labs

Eleven labs are included to address DB2 9.5 for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

This is an intermediate course for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

Course title: DB2 9 Administration Workshop for Windows
Course duration: 4.0 Days
Course number: CL231
Abstract:

This is the classroom version of Instructor Led Online (ILO) course DB2 9 Database Administration Workshop for Windows - Instructor Led Online (3L231)

This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced. Use a Windows operating system during hands-on labs.

This course replaces CF232 and is appropriate for those still using DB2 UDB V8.

Course Materials

The course materials address DB2 9.5 for Linux, UNIX, and Windows.

Hands-On Labs

Eleven labs are included to address DB2 9.5 for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

This is an intermediate course for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

Course title: DB2 9 Administration Workshop for Linux, UNIX, and Windows
Course duration: 4 days
Course number: CL2X1
Abstract: This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced. Hands-on exercises provide an option of using either an AIX, Linux, or Windows operating system. This course replaces CL201, CL211, and CL231 and is appropriate for those still using DB2 UDB V8.

Course title: Using XQuery to Query pureXML data with DB2
Course duration: 2.0 days
Course number: CG10
Abstract:

This course introduces you to non-traditional ways of using DB2 to work with native Extensible Markup Language (XML) data. Also, discuss how database administrators manage the DB2 - native XML environment.

Learn to query XML data that is stored in DB2 tables and how to create XML documents from traditional DB2 data. Search XML documents stored in DB2 tables and access XML documents as though the documents were relational tables.

This is a basic course for end users and anyone interested in learning how to retrieve native XML data and perform text searching of native XML.

Course title: Querying and Administering pureXML data with DB2
Course duration: 4.0 days
Course number: CG13
Abstract:

This course introduces you to non-traditional ways of using DB2 to work with native Extensible Markup Language (XML) data. Also, discuss how database administrators manage the DB2 - native XML environment.

Learn to query XML data that is stored in DB2 tables and how to create XML documents from traditional DB2 data. Search XML documents stored in DB2 tables and access XML documents as though the documents were relational tables. This content is addressed in the first two days of class and can be taken by end users or other individuals who only need to access XML data stored in DB2 tables.

In the last two days of class, you will store native XML data in DB2 and create XML indexes. Analyze plan information for queries and take steps for improving query execution. Learn how to manage the XML schemas and the techniques available for decomposing the XML documents.

This is an intermediate course for database administrators and anyone interested in learning how to handle native XML data in DB2.

Course title: DB2 9 for Linux, UNIX, and Windows Transition
Course duration: 2.0 days
Course number: CG09
Abstract:

Get the technical information about the new functions and features in DB2 9 for Linux, UNIX, and Windows since V8.2.

Course Materials

The course material covers DB2 9 for Linux, UNIX, and Windows.

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000375

This is an intermediate course for database administrators, application designers, technical support, and technical specialists who require information about the features and function of DB2 9 for Linux, UNIX, and Windows.

Course title: DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2
Course duration: 4.0 Days
Course number: CL310
Abstract:

This course is designed to provide you with technical information about the functions and features in two DB2 product updates, DB2 9.1 and DB2 9.5 for Linux, UNIX, and Windows as well as information on some product changes that became available in DB2 Version 8.2.2. The information is presented in two parts. First, the information on the DB2 9.1 features like Table Partitioning, XML data support, Self-tuning Memory Management and data row compression will be presented. The planning and implementation considerations for the DB2 9.5 functions will be presented in part two, which will include database roles for security, real-time statistics collection and workload management capabilities. This course is the classroom delivered version of Instructor Led on Line course (3L310).

This intermediate course is for database administrators, application designers, technical support, and technical specialists who require information about the features and functions of DB2 9.5 for Linux, UNIX, and Windows.

Course title: DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9
Course duration: 2.0 Days
Course number: CL311
Abstract:

If you are transitioning from DB2 for LUW V8.2 to 9.5, you should consider the full 4-day transition courses, DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 (CL310) or DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 - ILO (3L310).

Get the technical information about the new functions and features available in DB2 9.5 for Linux, UNIX, and Windows for current DB2 9.1 database systems. This course is classroom delivered version of the Instructor Led Online course (3L311).

This intermediate course is for database administrators, application designers, technical support, and technical specialists who require information about the features and functions of DB2 9.5 for Linux, UNIX, and Windows.

Course title: DB2 9 DBA for Linux, Unix and Windows Exam 731 Certification Preparation Tutorial Series
Course duration:
Course number:
Abstract: This series of 7 tutorials provides a solid base for each section of the new DB2 9 DBA exam available September 2006. They can help you attain a level of certification that can validate your database administration skills on DB2 9, help you use your DB2 knowledge to more successfully to design, implement and administer databases and reduce complexity and time creating an application. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF or zip file