Programming Books C Java PHP Python Learn more Browse Programming Books
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

MySQL Certification Study Guide Paperback – April 15, 2004

ISBN-13: 075-2063326329 ISBN-10: 0672326329

11 New from $19.71 24 Used from $0.01 1 Collectible from $9.98
Amazon Price New from Used from
"Please retry"
$19.71 $0.01

There is a newer edition of this item:


Customers Who Viewed This Item Also Viewed


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

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 (9 customer reviews)
  • Amazon Best Sellers Rank: #2,481,300 in Books (See Top 100 in Books)

Editorial Reviews

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.

About the Author

Paul DuBois is a member of the MySQL AB documentation team and a leading author of MySQL books. His MySQL (Sams Publishing) is considered to be the definitive guide to using, administering, and programming MySQL.

Stefan Hinz is a member of the MySQL AB documentation team, a MySQL trainer and consultant, and the German translator of the MySQL Reference Manual.

Carsten Pedersen is the MySQL AB certification manager, and has led the development of the MySQL certification program. He has also taught several MySQL courses in a number of countries.

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.7 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

14 of 14 people found the following review helpful By Sisu on September 1, 2004
Format: Paperback Verified Purchase
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 it was labor that probably was a good thing, ultimately.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 12 people found the following review helpful By "jdpearsonkirk" on July 7, 2004
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 16 people found the following review helpful By A Customer on May 4, 2004
Format: Paperback
I've read the first couple of chapters, and can only say: Paul DuBois (and his co-authors Stefan Hinz and Carsten Pedersen who, for some reason, aren't listed as authors on Amazon) have done it again: Written an excellent book on MySQL. I have yet to go and actually sit the exam, but I think that this book will have me well prepared by the time I go.
I find it frustrating that there are no "real" sample questions -- almost all exercises are open-ended, but what you'll see on the exam are multiple-choice questions. That's why I'm not giving the book the 5 stars that the main text deserves.
Oh, and the book is free -- that is, if you're certain you're going to go to the exam anyway. There's a discount voucher inside the book that'll be good for $50.00 (the list price of the book) off of an exam...
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By JohnM on January 5, 2005
Format: Paperback
This book is not only an excellent source for prepping for the Core and Professional exams, it's also great for teaching good MySQL usage in general. This should be no surprise: Paul DuBois is the main author, and anyone even remotely in touch with MySQL know his reputation.

Now that I'm certified, I will soon be teaching courses in MySQL. I plan to use this book as course material, and I would strongly encourage other instructors to do the same.

Many authors and publishers never follow up on a book once it has been published. Not so here: In the best of Open Source tradition, the authors are extremely keen on following through on the book and have published thorough errata (in the few places it has proved necessary) for the book on the MySQL web site. This shows a commitment to their work rarely seen in other places.

Other reviewers have pointed to a lack of sample data. This is not correct. True, some data is missing but for the most part the data used is the "world" database freely available for download from the MySQL web site. This fact is admittedly somewhat hidden in the introductory pages, and easy to miss.

Some also complain that the exercises are not in the same (multiple-choice) format as you will see on the exam. At first it does look strange, but after completing my studies I fully support the authors' choice in doing what they did. You get a much better knowledge of the subject areas with the format chosen, and learn a lot more about the many inticacies of working with the software.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Todd D. Farmer on July 9, 2005
Format: Paperback Verified Purchase
This book is perfect for preparation for the MySQL Core Certification exam (I haven't taken the Professional exam - yet). If you are looking to get certified, this is the book. There were a few areas that I felt should have been covered in more detail. The one thing that bothered me (and the main reason I can't give this title 5 stars) were several topics where the text just mentions certain (relatively obscure) features, saying more information would be presented about the feature in the exercises at the end of the chapter. Of course, the exercises are the mock exam questions, and while the correct answers are all well-explained, it seems odd to mention a topic, only to say that it will be covered in the questions without preparing me with adequate information up front.

MySQL seems to consider the passing criteria as a trade secret. I could find nothing that told me what percentage I had to get right on the exam to pass. When I took the exam, I received feedback that I had passed, but no score. Of course, this makes it somewhat difficult to use the practice tests to guage your progress. If I was getting 85% correct answers on the practive test (which I was), what does that mean? I finally just bit the bullet and took the test, and it all turned out fine. But it sure would have helped my self-assessment to know where I was.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

What Other Items Do Customers Buy After Viewing This Item?