MySQL Certification Study Guide (Paperback)

~ Paul DuBois (Author), Stefan Hinz (Author), Carsten Pedersen (Author)

Editorial Reviews

Product Description

With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to database systems from Oracle, IBM, and Microsoft. MySQL AB intends to agressively improve the feature set and performance of MySQL, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, announced in March 2003 and available at over 3,000 Pearson VUE 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 professional who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL 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 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, the book is the fastest, most reliable way for MySQL users to prepare for either of the MySQL tests.

From the Publisher

The authoritative study guide to prepare for the MySQL Core Certification and MySQL Professional Certification exams.

The MySQL certification program is a carefully developed, high-quality certification process that can help you prove your skills in using, maintaining, and administering MySQL database servers and other technologies from MySQL AB.

Covering both the basic MySQL Core Certification exam and the advanced MySQL Professional Certification exam, MySQL Certification Study Guide is the one authority to look to when you’re preparing for either test. The book teaches you all the concepts, principles, and techniques that you’ll need to know for the Core and Professional certification exams, and it includes an array of learning aids, practice questions, and real-world examples to help you prepare for test day.

Certified computer professionals often find that having proven, recognized credentials can advance them farther in their fields, give their careers a boost, and make them better, more productive employees for their companies or organizations. Whatever reason for becoming MySQL certified, MySQL Certification Study Guide gives you the information you need to help you better understand MySQL technologies and prepare for and pass the exams.

Special Offer - Purchase this book and receive 25% off your MySQL exam!

Purchase of a copy of the MySQL Certification Study Guide entitles you to receive 25% off the cost of registration for the MySQL Core Certification exam. Details on the back cover of the book.

See all Editorial Reviews

Product Details

• Paperback: 648 pages
• Publisher: MySQL Press (April 15, 2004)
• Language: English
• ISBN-10: 0672326329
• ISBN-13: 978-0672326325
• Product Dimensions: 9 x 7 x 1.4 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 3.7 out of 5 stars  See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #1,114,647 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

4.0 out of 5 stars Essential book to prepare for the exams, June 5, 2004

By	Zeb Weedrick (Furnessville, IN United States) - See all my reviews

Amazon Verified Purchase

I found this an absolutely essential book to prepare for the exams, if only for the fact that it tells you exactly what topics are covered in the exams.

I think few people know everything there is to know about MySQL. I find that I'm very good at some parts of MySQL, particularly things I do everyday. Other things, which I rarely (or never) do, I could use improvement. In that case, this book is not a good teaching book. So I turned to another book, Sams' "Teach Yourself MySQL in 21 Days" to cover subject matter I need work on.

My only complaints are:
1) The questions at the end of each chapter should be multiple-choice, as the exams are.
2) The book should have come with a CD with the sample data used in the book. That would have saved time, having to manually recreate the data examples.

12 of 12 people found the following review helpful:

5.0 out of 5 stars Very readable; good preparation for test and work as well, September 1, 2004

By	Sisu (Oakland, CA United States) - See all my reviews

I bought this book since I needed to get a better grip on MySQL, since I got tasked with migrating our data at work from an MS SQL Server that's no longer under support to a new MySQL server coming on line. The book was a pleasure to read, a rarity among technical books. I decided to pursue MySQL Core Certification after reading the book. My tactic was to re-read the first half of the book (the "Core" part), doing about half the exercises. Also, I scribbled notes on data types, etc. (about 10 pages' worth of notes). I'm happy to say that was enough to allow me to pass the Core exam today. The one thing not really covered in the book in adequate detail is stuff on using MyODBC. It's true that the database data used in the book is not given to you, you have to enter it yourself if you want to replicate examples. However, that did force me to get pretty familiar with CREATE DATABASE, CREATE TABLE, INSERT and friends...so it was labor that probably was a good thing, ultimately.

11 of 11 people found the following review helpful:

4.0 out of 5 stars Excellent Exam Reference, July 7, 2004

By	James Pearson-Kirk (London, UK) - See all my reviews

In the run up to my 'Core' MySQL exam I believed I could survive on exisitng material (the online mannual and other books). However I purchased this book thinking it would be a good decision and was glad I did.

Firstly, there are many options and arguments for commands/utilities and the book points you in the right direction for exam relevancy, e.g For utility X, options, Y and Z are important.

Secondly, the exam questions at the end of each chapter are excellent. They are a genuine test and challenge of your Mysql knowledge.

(...). It has also pointed out that perhaps the exam questions in the book should be multiple-choice, however as per the 'candidate guide', exam questions may appear as text box's for you to enter commands.

Overall, this book which was an essential purchase for me and without it I would not have passed the challenging exam.

N.B The book is split in two parts, the 'Core' certification and the 'Proffesional' certification. I took the 'Core' exam which is the first half of the book. I have not yet read the second part.