MySQL 5.0 Certification Study Guide (MySQL Press) (Paperback)

by Paul DuBois (Author), Stefan Hinz (Author), Carsten Pedersen (Author)
Key Phrases: optimizing databases, invalid data values, optimizing queries, Query Browser, Reference Manual, Program Files (more...)

Editorial Reviews

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 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.

About the Author
Paul DuBois is the leading author of books on MySQL topics. His book, entitled MySQL, is widely considered the definitive work on MySQL. He is a developer for MySQL AB, where he edits and maintains the official English-language documentation for MySQL. Stefan Hinz is leads the MySQL documentation team, is a MySQL trainer and consultant, and the German translator of the MySQL Reference Manual. He is also the translator of Paul's MySQL Cookbook (O'Reilly and Associates) and translator and author of MySQL-related German books. Stefan passed the MySQL Certification exam before he joined MySQL AB.

See all Editorial Reviews

Product Details

• Paperback: 643 pages
• Publisher: MySQL Press (September 3, 2005)
• Language: English
• ISBN-10: 0672328127
• ISBN-13: 978-0672328121
• Product Dimensions: 9 x 6.9 x 1.6 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars See all reviews (18 customer reviews)
• Amazon.com Sales Rank: #26,910 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #17 in	Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL
  #63 in	Books > Computers & Internet > Databases > SQL

Customer Reviews

Most Helpful Customer Reviews

25 of 25 people found the following review helpful:

5.0 out of 5 stars Taken directly from the exams and written by top-notch authors, this book is a must for any exam candidate!, February 8, 2006

By	Michael Hillyer (Alberta, Canada) - See all my reviews (REAL NAME)

Quite simply, this book should be on the shelf of anyone who intends to take the MySQL Certification exams.

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
* Joins
* 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.

14 of 14 people found the following review helpful:

3.0 out of 5 stars Very good information, leaves more to be desired, June 30, 2006

By	Kevin Benton "KB" (Denver, CO United States) - See all my reviews

I found myself wanting more when it came time to try the practice exam questions. The book comes with PDF's that serve as the practice exam. What I expected was software that would simulate the test. I'm taking the DBA class next month and I don't expect any issues passing the exam, though I would feel more comfortable forking out the $ to take it if I had a wider pool of questions to study from.

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.

----

Post-exam follow-up:

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.

Hits:
o Helped me pass the MySQL DBA exam first-time with very thorough study and having taken the MySQL 5 DBA class.
o PDF files for exam prep materials and a full PDF of the book itself
o Has some nice query optimization explanations in it.
o Provides nice resources for those who are upgrading their skills from MySQL 3.x, 4.x.

Misses:
o Does not cover MySQL Cluster.
o CD did not contain software that helped me take practice exams.
o Resource not intended to be used as a full reference of MySQL.
o Many of the prep questions were given before the material to answer the questions were presented.

Note: I would increase my rating of this book to four stars, but Amazon won't let me change the rating in my review.

13 of 13 people found the following review helpful:

5.0 out of 5 stars Exam voucher not honored for MySQL 5 exams! (but great book), March 2, 2006

By	Brian (Sammamish, WA USA) - See all my reviews

I love this book, but I am outraged that VUE refuses to honor the included voucher code for MySQL 5 exams. The book is targeted for MySQL 5, and the text in the book clearly states the voucher is for ANY MySQL exam. But VUE claims the included voucher is only valid for MySQL 4 exams.

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.