Skip navigation links

MySQL Forums :: Certification :: MySQL Study Guide questions


Advanced Search

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 http://www.mysql.com/training 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


Subject Written By Posted
MySQL Study Guide questions Nelson Kirby 01/31/2012 05:11AM
Re: MySQL Study Guide questions David Stokes 02/01/2012 06:03AM
Re: MySQL Study Guide questions Nelson Kirby 02/03/2012 12:25PM
Re: MySQL Study Guide questions David Stokes 02/03/2012 02:12PM
Re: MySQL Study Guide questions emmie james 02/06/2012 06:57PM
Re: MySQL Study Guide questions Nelson Kirby 02/07/2012 08:22AM
Re: MySQL Study Guide questions Panos Kollias 08/19/2012 02:27PM
Re: MySQL Study Guide questions David Stokes 08/20/2012 08:10AM
Re: MySQL Study Guide questions Panos Kollias 08/21/2012 02:34AM
Re: MySQL Study Guide questions David Stokes 08/21/2012 09:12AM
Re: MySQL Study Guide questions Panos Kollias 08/21/2012 12:12PM
Re: MySQL Study Guide questions David Stokes 08/22/2012 06:22AM
Re: MySQL Study Guide questions Panos Kollias 08/22/2012 06:42AM
Re: MySQL Study Guide questions Panos Kollias 08/30/2012 01:54PM
Re: MySQL Study Guide questions David Stokes 02/07/2012 10:31AM
Re: MySQL Study Guide questions Nelson Kirby 02/07/2012 08:17AM
Re: MySQL Study Guide questions Nelson Kirby 03/01/2012 03:43PM
Re: MySQL Study Guide questions char trum 03/01/2012 11:13PM
Re: MySQL Study Guide questions Nelson Kirby 04/28/2012 11:38AM
Re: MySQL Study Guide questions David Stokes 04/30/2012 08:05AM
Re: MySQL Study Guide questions Nelson Kirby 04/30/2012 08:41AM
Re: MySQL Study Guide questions Panos Kollias 08/13/2012 07:57AM
Re: MySQL Study Guide questions David Stokes 08/13/2012 01:34PM
Re: MySQL Study Guide questions Panos Kollias 08/14/2012 06:55AM
Re: MySQL Study Guide questions David Stokes 08/14/2012 03:35PM
Re: MySQL Study Guide questions Panos Kollias 08/14/2012 04:17PM
Re: MySQL Study Guide questions David Stokes 08/15/2012 11:00AM
Re: MySQL Study Guide questions Panos Kollias 08/15/2012 12:07PM


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.