Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
MySQL 5.0 Certification Study Guide 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently Bought Together
Customers Who Bought This Item Also Bought
More About the Author
Top Customer Reviews
The book was written by Paul DuBois, certainly the top author of MySQL related books. Paul's style is very readable and the book provides extensive coverage of the exam material.
In fact, the book is so extensive because it was written not only by Paul, but by Carsten Pedersen, certification manager at MySQL AB. The book was written by the people who created the exam, and it shows. I can tell you right now that if you read the certification study guide and know its content, you will pass the certification exam. There is not a question on the exam that is not covered by this study guide.
The exercises are good, though not always formatted the same as what you will encounter on the actual exam. Doing the exercises should reveal how well you understand a given topic in the guide.
Here's an overview of what the book covers:
* MySQL and MySQL AB
* MySQL Software
* Using MySQL Client Programs
* Data Definition Language
* The SELECT Statement
* Basic SQL
* Update Statements
* Importing and Exporting Data
* MySQL Architecture
* MySQL Installation and Configuration
* Security Issues
* Optimizing for Query Speed
* MyISAM Tables
* InnoDB Tables
* Advanced Server Features
Finally, here is the best part about the MySQL Certification Study Guide: it's free. In the back of the guide is a voucher code for 25% off the cost of a certification exam, or roughly the price of the book. If you are serious about taking the MySQL Certification exams, you can't go wrong with this book.
The book does a fairly good job of covering both exam tracks (DBD & DBA) from what I've seen thus far and is laid out in a practical way for those preparing for the exam. This book is not intended as a reference, though some new admins may choose to use it like that.
The certification study guide did a good job of helping me pass the exams the first time through. Primary goal - accomplished. If you plan to attend the MySQL 5.0 DBA class, I got a copy of my own in the class so I wound up with an extra (so I keep one at work and one at home). Combine this with the on-line resources available and the value of this book increases.
I do find myself recommending this book to other developers and administrators to learn how to improve their MySQL skills, but I don't recommend it as a reference. It accomplishes its purpose well, however, I think it could have been better by having more of the information we need after the exam is over. This is not a manual for MySQL and clearly does not stand on its own for that purpose. If your goal is to get certified as a DBD or DBA, this book will likely help. If your goal is to use this book as your only manual for MySQL, this is not the best investment of resources to that end.Read more ›
I attempted to escalate this issue but was told by VUE that it is Amazon's fault for including the wrong voucher number. The code is clearly printed by the book publisher, not Amazon, so this is just very poor finger pointing by VUE trying to blame Amazon.
The book is worth every penny despite the false advertising related to the voucher.
UPDATE: I contacted the publisher and got a quick response. The publisher is working on fixing VUE's screw-up, so hopefully this will be resolved soon.
I did buy this book not because I want to be certified, but because I wanted to have detailed information about MySQL version 5 and all the new functionality it has. I am certainly not disappointed.
There are useful examples for every subject covered and the book is much more readable than the online MySQL manual.
This is not a book for beginners or a book about designing a relational database. If you want to learn SQL or database design you should look elsewhere.
I also liked the style very much. It's very proffesional but not too dry and reading is not boring.
There are a few glitches here and there (table of content is off, the CD ROM didn't work well), but they are not really impacting your study.
Overall, I liked it very much and I wish more vendors would adopt that format and style.
And, by the way, I passed both exams at the first try using this book only (well, I've been working with MySQL a bit in the past, but I clearly had holes in my knowledge before).
So I highly recommend this book as a perfect MySQL certification guide and general reference.
Most Recent Customer Reviews
There was a lot of repetition, with not much new information in the chapters that were repeating. Also, the book itself is only 80% of the pages, so there is a lot less actual... Read morePublished 3 months ago by jessie
Arrived exactly as described - I am very pleased with this product.Published 9 months ago by Panduit-OP
Excellent for those pursuing certification or self-training.Published 18 months ago by Robert Y. Lamaute
Passed both of the Oracle MySQL Associate exams with this study guide. You'll definitely want to read and understand the entire study guide, even if you have 5+ years of hands on... Read morePublished 19 months ago by Oland
I've recently (this month) taken both Oracle exams (1z0-871 and 1z0-872) relying heavily on this book to study. Read morePublished on September 26, 2013 by Amazon Customer
is a great guide i ended up selling it forward to a friend and he was able to get certified using this book no problem.Published on August 16, 2013 by rquiles
I did not pass without it, Much easer with the guide, the guide is much better than the Oracle guide.Published on August 15, 2013 by RakuMom
Having never touched any sort of database before MySQL, I used this book as the primary study resource for my 1Z0-870 exam (MySQL Certified Associate). Read morePublished on May 6, 2013 by Dyslexic Book Lover
This book, along with a 3rd party practice exam, provided me with everything I needed to know to pass the MySQL DBA Exams first time.Published on April 6, 2013 by Matthew Casperson