MySQL Forums
Forum List  »  Certification

Re: MySQL Study Guide questions
Posted by: David Stokes
Date: February 01, 2012 06:03AM

Hi Nelson,

The MySQL Certification 5.0 Study Guide is still the best book to use for studying for the TWO Developer exams and the TWO DBA exams or the one Associate exam. There is another study guide for MySQL Cluster. Read it carefully, type in the examples, use the practice quetions CDROM, and you will do fine!

Many of the URLs changed or disappeared during the MySQL AB -> SUN -> Oracle time span. There are TWO exams for the DBA or Developer certs, each section in the book for each exam, and the exams do not build on each other. The idea of the Associate exam came after the book was published (see below)

Workbench was not a product when the 5.0 Exam series was started. it helps to know the various functions of each product but please note they are old.

As for the associate exam, I was able to dig this up:
Preparing for the Associate Exam

The best way to prepare for the Certified MySQL Associate exams is to take part in the MySQL for Beginners training course offered by MySQL AB. This and other courses are offered world-wide several times per year. See for more information on upcoming courses.

It is also possible to prepare for the certified MySQL Associate exam through self-study. Candidates that choose to prepare themselves through self-study should consider purchasing the MySQL 5.0 Certification Study Guide. This is the same book that is used to prepare for the more advanced Certfified MySQL Developer and Certified MySQL Administrator exams, so purchasing this book is an excellent first step in becoming a fully certified MySQL professional.

For the Certified MySQL Associate exam, the following parts of the study guide are required reading:

* Chapter 1: Sections 1.1 and 1.2
* Chapter 5: Sections 5.1 through 5.4, 5.5 (but not 5.5.2 and 5.5.3), 5.6 and 5.7
* Chapter 7: All
* Chapter 8: All
* Chapter 9: All, except for 9.6
* Chapter 10: 10.5
* Chapter 11: All
* Chapter 14: Sections 14.1, 14.2 (but not 14.2.1 through 14.2.3), 14.3, 14.4, 14.6
* Chapter 15: All, except 15.2.3 and 15.3.1
* Chapter 29: Parts 29.4.2 and 29.4.3
* Chapter 32: Section 32.4

Sections 5.4.1, 5.4.3 and 5.6.2 are required reading. Usage of character sets and collations is not part of the associate exam, but these sections must be studied to understand issues surrounding string data types in general.

Some sections mentioned above include information on how to obtain MySQL metadata using SHOW commands and the INFORMATION_SCHEMA database. Knowledge of the INFORMATION_SCHEMA database is not required for the Associate exam, but is highly recommended none the less.

In addition, we strongly recommend studying the following parts:

* Chapter 2 (all)
* Chapter 5: parts 5.4.1, 5.4.3
* Chapter 20: 20.3
* Chapter 25: 25.5, 25.6
* Chapter 29: 29.4.6
* Chapter 31: All

The parts that are recommended reading will aid in understanding the parts that are required reading. The exam questions directly relate to the subject matter covered in the parts that are required reading.


Let me know if you have more questions! Good luck on the exams!

Dave Stokes
MySQL Community Team

Options: ReplyQuote

Written By
January 31, 2012 05:11AM
Re: MySQL Study Guide questions
February 01, 2012 06:03AM
February 03, 2012 12:25PM
February 03, 2012 02:12PM
February 06, 2012 06:57PM
February 07, 2012 08:22AM
February 07, 2012 10:31AM
February 07, 2012 08:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.