Tips to getting DB2 Certified....
svisser1 2700018UK9 Visits (2450)
I proctor exams for IBM employees who reside in Toronto and am constantly asked questions about how one should prepare to take the exams. I've put together the following information and thought that you might find it useful as well.
How to Prepare to Pass a DB2 Universal Database Certification Exam
1. Read the exam objectives. http
2. Use the recommended study materials to refresh your skills. I've listed these in detail below.
3. Take the assessment exam. These exams were free, but soon there will be a minimal charge to take the assessment exam. See http
4. Take the test. Where? I've listed your choices below.
5. If you do NOT pass, use the score report to determine the areas you need to increase your knowledge and start the steps over again.
6. If you PASS, make sure you let your manager know! Your results are confidential to YOU and no one will know you passed unless you tell them!
** DB2 Certification exams are experience-based, so the more practical experience you have using DB2, the easier it will be for you to prepare and pass the exams.
Recommended Study Materials for DB2 Certification Exams
Exams 700, 701, and 703 each have a study guides written specifically for the exam. See http
** DB2 UDB V8.1 Certification Test 700 Study Guide,
by Roger Sanders
** DB2 UDB V8.1 Certification Test 701 and 706 Study Guide,
by Roger Sanders
** DB2 UDB V8.1 Certification Test 703 Study Guide,
by Roger Sanders
The series of study guides by Roger Sanders is recommended for those who need a quick refresh of the exam material. He includes sample questions and has focused the books on just what you need to pass the exams.
** DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, , 5/e
by George Baklarz, Bill Wong
** DB2 UDB v8.1 Application Development Certification Guide, , 2/e
by Steve Sanyal, Kevin Gashyna, David Martineau, Mike Kyprianou
** Advanced DBA Certification Guide and Reference for DB2 Universal Database v8.1 for Linux, UNIX, and Windows, 1/e
by Dwaine Snow / Tom Phan
The series of Certification Guides is recommended for those who need to prepare for the exam, but also wish to have information beyond the exam for learning or reference purposes.
DB2 UDB Certification Tutorials
IBM has a series of tutorials that were designed to help you prepare for DB2 certification exams. The tutorials don't cover as much ground as the books do, but will help you get an overview on what you need to know for the exams. My team is currently using these tutorials as a basis for a "crammer course" for students working in the Toronto Lab this summer. You can link to all the free tutorials from http
** DB2 UDB V8 Family Fundamentals Preparation
This series of six tutorials is designed to help you prepare for the DB2 Version 8 Family Fundamentals Exam 700 to attain the certification, IBM Certified Database Associate DB2 Universal Database V8.1 Family.
** DB2 V8 Application Development Certification Tutorial Series
A series of seven free tutorials are available designed to help you prepare for the DB2 UDB V8.1 Family Application Development certification exam (Exam 703). These tutorials provide a solid base for each section of the exam.
** DB2 UDB for Linux, UNIX, and Windows Version 8 DBA Certification Preparation
This series of six tutorials is designed to help you prepare for the DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration certification Exam 701 to attain the certification, IBM Certified Database Administrator -- DB2 UDB V8.1 for Linux, UNIX and Windows.
DB2 Training Courses
These "training courses" are computer-based and are intended for people who already know a fair amount about relational databases (DB2, MS SQL Server, Oracle, or others) and allows them to get up to speed on DB2 V8 very quickly.
** DB2 Universal Database Administration Fastpath for V8 (CT28D)
This course is intended for relational database administrators, skilled on other platforms, who are responsible for implementing and maintaining a DB2 UDB V8.1 system.
** DB2 Universal Database Programming Fastpath (CT10)
This course is designed for experienced relational database programmers who want to learn basic database programming for a DB2 Universal Database system.
** Fast Path to IBM DB2 Universal Database in a Visual Basic .NET Environment
This course is designed to help programmers learn how to use the Microsoft Development Environment (Visual Studio .NET) to create DB2 UDB database applications. Programmers will learn how to design applications to create database objects, populate tables, execute queries, and build and execute SQL stored procedures. Students will also learn how use the new tools to design data entry and retrieval forms.
How to get books
a) IBM employees can purchase books, with their manager's approval, from the following site: http
b) IBM Libraries also carry copies of the books that you may borrow.
c) Most of our books are now available electronically AND IBM employees, world-wide, has a free subscription to Books24x7:
o Register for Books24x7 which will enable you to read the certification guides electronically: http
a) Bookstores occasionally carry our IBM Press titles, but you'll find it easier to find our books available through online bookstores such as http
o EMEA: Europe, Middle East and Africa
Selected translated IBM Press books are available in the following languages:
o Chinese, Japanese, German, Spanish, and Russian
Low-cost English versions of IBM Press titles are available for India.
b) Online book engines such as Books24x7 (www.books24x7.com) and Safari (www.safari.com) carry IBM Press books. Sign up for a trial to see if you like reading and searching retail books electronically.
Where to take exams
1. VUE (htt
2. Conferences (htt
3. Special Events (check with your RUG leader or partner rep)
4. IBM employees: various places have been set up to make it easy for you to take your exam at your office or a nearby office.
I look forward to reading your comments.
IBM Press Program Manager
The postings on this site are my own and don't necessarily represent IBM positions, strategies or opinions