Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

I'm preparing for MySQL certification, nowadays officially titled:

Oracle Certified Professional, MySQL 5.0 Developer certification

After looking through MySQL forum it looks like most people recommended this book:


Which as far as I learned was the official preparation source at the time when MySQL was controlled by MySQL AB and Sun.

Now, however - Oracle officially doesn't recommend this book. To be precise, I don't know what they recommend. I could only find this "value package":


Can someone who got MySQL certification confirm that this book is what they have used? Also, if there is any other moderately priced study materials out there - please let me know.


I passed second one Monday March 28th. I have to say second exam was more complicated. So I have two exams now and waiting for my package from Oracle. Took me approximately 2.5 week total to prepare for both exams.

With 0.5 weeks for 1st and 2 weeks for 2nd.

Also - to everyone who wants to take it: read the book thoroughly and go through all questions on the CD that comes with that book! This helps immensely.

Questions on the exam are very similar to those on the CD.


migration rejected from stackoverflow.com Jul 23 '13 at 0:22

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by MichaelT, gnat, GlenH7, Dan Pichelman, Robert Harvey Jul 23 '13 at 0:22

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking us to recommend a tool, library or favorite off-site resource are off-topic for Programmers as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – MichaelT, gnat, GlenH7, Dan Pichelman, Robert Harvey
If this question can be reworded to fit the rules in the help center, please edit the question.

Hi. I took the second part of cmdev certification in italy last january and the official book you've linked covers all subjects. –  nick rulez Mar 13 '11 at 0:04
thanks Nick. extremely helpful. I'll get that book then instead of "value package" for 3700$. Oracle is pure evil:) –  Stann Mar 13 '11 at 0:13
What exam are you preparing? –  nick rulez Mar 13 '11 at 0:14
That book is perfect and I've learned a lot of things studying it. My advice is to make a lot of practice because questions are not mnemonics. CMA is very easy and the "more difficult" question you can find in it is "what's the result of select null = null? " :). CMDEV exams are more difficults. By the way they required just 60% of correct answers to pass. So 42-43 correct answers on 70 questions are enough to pass. Be aware that on cmdev exams a lot of questions require multiple choices. –  nick rulez Mar 13 '11 at 0:26
any practice questions anywhere? –  Stann Mar 14 '11 at 0:23

1 Answer 1

up vote 5 down vote accepted

Get the book. It's pretty thorough. I got the MySQL developer cert before Oracle bought them. I still use the book as a reference every once and a while.

I can't imagine there are many questions they could ask that couldn't be covered with the material covered in that book.

nice. I've just passed first exam after only 2 days of preparation. –  Stann Mar 15 '11 at 20:06
@Andre - congrats! Just a heads up: I remember the second exam being more difficult than the first. –  davidhaskins Mar 15 '11 at 20:23
Thanks. This will be helpful since I passed this one with 62% over required 60%. obviously I should have invested more time in preparation than 2 days:) –  Stann Mar 15 '11 at 21:32
mmm. I'm confused. Someone just told be that 5.0 Exam is obsolete and there is 5.1 exam available. I don't see 5.1 exam anywhere on either mysql website or oracle website. Can somebody confirm that 5.0 certification is the latest active certification? –  Stann Mar 15 '11 at 21:34
nice. i passed second one monday march 28-th. I have to say second exam was more complicated. So I have 2 exams now and waiting for my package from Oracle:) hooray. Took me approximately 2.5 week total to prepare for both exams. With 0.5 weeks for 1-st and 2 weeks for 2-nd. Also - to everyone who wants to take it: read the book thouroghly and go through all questions on CD! This helps immensely. –  Stann Mar 30 '11 at 14:44

protected by Community Aug 13 '12 at 18:08

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.