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 installations, MySQL is the world's most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers.

The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 18 Ratings

Good self-study resource - 2009-06-30
Reviewer Rating:
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.

Learning MySql - 2009-06-24
Reviewer Rating:
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.

Nirdesh Mohan - 2009-05-30
Reviewer Rating:
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.

It does exactly what it is for - 2009-05-20
Reviewer Rating:
The book is great not only to get certified, but also to learn about NySQL. It is written in such a manner that you need not to be experienced with the software (I advise you though, to be familiar with it prior to making an exam).

The book is great, CD examples are great, also comes with test evaluations. Only drawback is that the exams are expensive.

Solid material for exam or not - 2009-01-16
Reviewer Rating:
This book is a very comprehensive guide to what MySQL offers and can teach you.

Would definitely recommend for anyone needing a great book about MySQL.

Browse Similar Topics

Top Level Categories:
Certification

Sub-Categories:
Certification > Overview/Introduction