Skip to main content

 
Professional certification

  >  

Certifications

  >  

Test information

Test 731: DB2 9 DBA for Linux UNIX and Windows


Overview Objectives Test Preparation
Roadmap  |  Training Resources  |  Sample / Assessment Test 

Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test. 


Classroom Course

Course title: DB2 Universal Database Administration Workshop for Linux
Course duration: 4.0 days
Course number: CF20 (Worldwide), CF201 (US)
Abstract:

Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 UDB for Linux, UNIX and Windows. Use a Linux operating system during hands-on labs.

Course Materials

The course materials address DB2 UDB for Linux, UNIX and Windows Version 8.2.

Hands-On Labs

Nine labs are included to address DB2 UDB for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 701: DB2 UDB V8.1 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.

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000371

This is an intermediate course for database administrators and other technical individuals who plan, implement, and maintain DB2 UDB for Linux, UNIX and Windows databases.

Course title: DB2 Universal Database Administration Workshop for UNIX
Course duration: 4.0 days
Course number: CF21 (Worldwide), CF211 (US)
Abstract:

Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 UDB for Linux, UNIX, and Windows. Use an AIX operating system during hands-on labs.

Course Materials

The course materials address DB2 UDB for Linux, UNIX, and Windows Version 8.2.

Hands-On Labs

Nine labs are included to address DB2 UDB for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 701: DB2 UDB V8.1 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.

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000371

This is an intermediate course for database administrators and other technical individuals, who plan, implement, and maintain DB2 UDB for Linux, UNIX and Windows databases.

Course title: DB2 Universal Database Administration Workshop for Windows
Course duration: 4.0 days
Course number: CF23(Worldwide), CF231 (US)
Abstract:

Learn how to perform database administration tasks using DB2 UDB for Linux, UNIX, and Windows. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. Use a Windows operating system during hands-on labs.

Course Materials

The course materials address DB2 UDB for Linux, UNIX, and Windows Version 8.2.

Hands-On Labs

Nine labs are included to address DB2 UDB for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 701: DB2 UDB V8.1 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.

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000371

This is an intermediate course for database administrators and other technical individuals who plan, implement, and maintain DB2 UDB for Linux, UNIX and Windows databases.

Course title: DB2 9 for Linux, UNIX, and Windows Transition
Course duration: 2.0 days
Course number: CG09 (Worldwide), CG090 (US)
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=pag e&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: Using XQuery to Query pureXML data with DB2
Course duration: 2.0 days
Course number: CG10 (Worldwide), CG100 (US)
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 (Worldwide), CG130 (US)
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.


Online course

Course title: GYJR
Course duration:
Course number: CF282
Abstract: Learn how to perform basic database administration tasks using IBM DB2. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. Explore a fast path to DB2 9 database administration skills for experienced relational Database Administrators (DBA). Examine the skills needed for DB2 Certification Tests 701 and 731.

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


Retail Book
DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide

In this book, Roger E. Sanders, one of the world's leading DB2 authors and an active participant in the development of IBM's DB2 certification exams, covers everything a reader needs to know to pass the DB2 9 UDB DBA Certification exam (Exam 731). This comprehensive study guide steps you through all of the topics that are covered on the test, including Server Management, Data Placement, Database Access, Analyzing DB2 Activity, DB2 Utilities, High Availability, Security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers

DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference and Exam Prep 6th Edition

This new edition by George Baklarz and Paul C. Zikopoulos offers complete, start-to-finish coverage of DB2 9 administration and development for Linux®, UNIX®, and Windows® platforms, as well as authoritative preparation for the latest IBM DB2 certification exam. Written for both DBAs and developers, this definitive reference and self-study guide covers all aspects of deploying and managing DB2 9, including DB2 database design and development; day-to-day administration and backup; deployment of networked, Internet-centered, and SOA-based applications; migration; and much more. You'll also find an unparalleled collection of expert tips for optimizing performance, availability and value.

Test registration

Authorized Prometric test centers (worldwide testing)