MySQL 5.0 Certification Study Guide
February 6th, 2010 by CGI & PHP.com
Product Description
This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months. Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active ins… More >>
MySQL 5.0 Certification Study Guide
Popularity: 9% [?]
SCJP Sun Certified Programmer for Java 6 Exam 310-065
MySQL
Head First PHP & MySQL
High Performance MySQL: Optimization, Backups, Replication, and More
MySQL Crash Course
The PHP Programming with MySQL
February 6th, 2010 at 10:06 am
This is the book for MySQL CMDBA, CMDEV, and CMA certifications!
But please note we do not include vouchers for the exams in the latest printing.
Rating: 5 / 5
February 6th, 2010 at 11:10 am
I took the MYSQL 5.0 dev I and Dev II exams from this book.
More than any other book I've ever read, this book prepares you for the exam. There's no material on the test that is not in the book, another first. In fact, some of the examples on joins and subqueries are taken straight out of the book's questions on CD's; some of the tables used in the exam are taken straight out of the book's examples. I can't stress this enough: more than any other Cisco, MS, Red Hat, Sun, or CISSP book, what is on the exam is in the book if you are willing to read carefully.
The questions are challenging, even more so than the exam itself. The writing is clear, as good as any book I've read. The examples are all excellent.
4 stars instead of 5 because the authors can't resist putting their political views in the text. They prominently list "Palestine" as a country (unnecessarily IMO) and refuse to say "fire triggers" because of the association with guns.
Besides that, it's a great book.
Rating: 4 / 5
February 6th, 2010 at 11:11 am
This book is a necessary but not entirely sufficient resource if you plan to complete the 5.x developer and/or DBA exams with self-study. Most of the subject areas present on the exams are covered in enough detail to easily pass if you are experienced with another database product and can apply that experience. (FYI, I have 15+ years working with Oracle/SQL Server and have dabbled with MySQL since 3.x, passed all 4 exams using this guide).
That said, you will likely need to supplement the book by reading the MySQL documentation if you wish to get as much knowledge as possible from the study process. Certainly try out each command on a test MySQL instance multiple times using version 5.x (NOT 5.1 where some behaviors have changed).
The practice questions provided are not all in multiple-choice format as you will encounter on the exam, which can be a good mental exercise for review, but the answer formats can be frustrating in some cases, as in the case of a multiple-choice question with five possible letter choices, wherein the answer is a paragraph that doesn't indicate the correct letter choices. Trivial but annoying.
Be sure you complete all practice questions from the accompanying CD and understand why your answers were right or wrong. There are no labs or practical exercises included, although a sample schema is included from which many of the practice questions are drawn.
If you are not taking the exams, this is still a good primer on MySQL.
Rating: 4 / 5
February 6th, 2010 at 11:43 am
If you need to learn MySql, this book is a very good choise, easy to understand, good and clear examples step by step, no just the query they show the query and the response from the server, not like another books that only show the query but don't show you the server response, you must guest or try and try.
Rating: 4 / 5
February 6th, 2010 at 11:49 am
I have been a J2EE Architect/developer using DB2/ORACLE for many years. I always feel that I am lacking in DB so I thought lets do DB certification and I chose mySQL. I have been using mySQL at home for my learning and in this book I found many interesting things that I was unaware. The book has every detail of topic that I need to prepare for the exam.
Rating: 5 / 5