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://www.ibm.com/certify lists the objectives for every IBM certification exam. Read these carefully as each question on the exam links directly back to one or more of these objectives! (That's a huge hint!)
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://www.ibm.com/software/data/education/cert/assessment.html for the latest information.
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://www.ibm.com/software/data/education/bookstore/certify.html for a list of the books that are available to prepare for exams within each job role.
** 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://www.ibm.com/software/data/education/selfstudy.html#2.
** 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: https://ites.krcinfo.com
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://w3.ibm.com/education
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://www.ibm.com/software/data/education/bookstore which links to Developer Bookstore.
http://www.ibm.com/software/data/education/bookstore/international.html has links to bookstores that offer discounts and low shipping costs for the following areas:
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 (http://www.vue.com) or Prometric (http://www.2test.com)
2. Conferences (http://www.ibm.com/software/data/education/cert/news.html)
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
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
From archive: June 2005 X
One of the most popular questions I hear is regarding book shelf space. It doesn't matter where you are in the world, but if you go into a bookstore, most likely you will see an entire bookcase dedicated to Oracle books and another to Microsoft books and in most cases only a single book about DB2. Why is this?
First of all, if you look very carefully, you may find a few other DB2 titles hidden away in other bookshelves. Try looking under "Certification", "Networks" or "Operating Systems". I know, it doesn't make any sense to look in those sections, but I've personally found DB2 titles in each of those categories! The biggest problem for a bookshelf stocker is that they have no idea where they should put our books. Some will even put our books in the Oracle bookshelf. In my opinion, there should be a Database Section, not an Oracle section. Or better yet, let's get a shelf for all IBM SW products or technology. It seems that this would make it easier for those stocking the shelves as well as those buying the books.
I'm hoping that now that we have an IBM Press (http://www.ibm.com/ibmpress) series of books published by Pearson Education, that we'll publish enough books about various IBM technologies to have a book case dedicated to IBM Press. Then you be able to find titles for DB2 next to the Cloudscape books, next to the Lotus, Rational, Tivoli, and WebSphere titles. This makes sense to me and it cannot happen soon enough for my liking.
So when will it happen? That depends on a number of factors. The first thing that we need is enough titles in our collection so we can fill a whole bookshelf. On the last count, there were 47 IBM Press titles published! Put 5 of each title in a bookshelf and it won't be very difficult to fill a book case.
But, the bookstore buyers aren't yet willing to take a risk on our books. Last year I convinced 60 key Borders stores to stock DB2 titles, but they didn't sell! No surprise, really. If you've never found a DB2 title in a bookstore, why would you ever look in a bookstore to find one? So the titles were sent back to the publisher and again, very few bookstores are carrying our titles.
Is it really a big deal though since the books can be purchased online, usually at a lower price than in the bookstore? Well, yes and no. I would assume that most people buying IT books are buying them from a favourite online bookstore. Amazon.com is probably the most common place. But what we're missing is MIND SHARE.
Assume that you are a university student and in your spare time you wandered into the database section in a bookstore. You see Oracle, MS SQL Server, MYSQL, and a few others, but nothing on DB2. Are you going to care about getting skilled on DB2 after witnessing this? I doubt it. But the problem can get worse if an executive is making a database buying decision by browsing in a bookstore. Does that happen? Sure, why not? Does the number of books available indicate the size of the skilled population using that technology? Maybe.
So what can we do to get shelf space for our books and therefore mindshare for our products? One simple thing that we can all do is to support the authors and the books that are available. If you've read a book and liked it, consider putting a review of the book in a public place such as amazon.com. If you are giving a presentation and there is a related book, consider recommending it to your audience. If you have customers, partners, or co-workers using DB2, mention to them that there are great books available. It may sound simple, but the more books that we sell, the better chance we have that the bookstores will take the chance to carry our books.
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.
svisser1 2700018UK9 4,901 Views
I'm very much looking forward to this BLOG experience! I enjoy writing and hope that I am able to share some valuable tips with everyone who is reading.
My passion is getting books published that will help people become more effective when using IBM technology. Although I would love to write and publish more books myself, I feel there are people more qualified than I am. I enjoy meeting with intelligent and talented people and working with them to get their books published so they may enjoy the experience of having a book or two published!
I plan to give tips to authors about how to approach a book and hope to build further awareness for the books that we've already published. I'm constantly surprised that not everyone is aware of all the great books that IBM Press has published over the past few years.
In my job as proctor for DB2 exams, I am asked many questions about how to prepare for exams, how to benefit from certification, and what exams should be taken. I plan to give some advice in this area as well. I give about 300 exams a year to IBM employees at the Toronto Lab and about 2000 per year at conferences. I enjoy talking to people about their experiences and hope to pass some of that knowledge on to you.
I work with a very passionate team of people who are trying to increase the number of skilled DB2 people around the world. I thank my team in advance for giving me the confidence to run this blog and for the tidbits of information that they will ask me to pass along to you. My team has specialists in academia, tutorials, CBTs, certification, training channels, content developers and more! If you have any comments or questions about training programs or opportunities, feel free to post a commment here and with the help of my talented team, I will ensure that you get an answer!
I think that adequately covers my motivations for wanting to own a BLOG. As for my expecations, I hope to be able to find the time to post 2 or 3 times a week and really look forward to hearing from any readers.
That's all for now.
IBM Press Program Manager
The postings on this site are my own and dont necessarily represent IBMs positions, strategies or opinions.[Read More]