Certified MySQL Associate

There was a lot of confusion at the recent MySQL Users Conference about the Associate exam. One recovering Oracle DBA took the test after a little persuasion (and two months of MySQL use) and was surprised how much they knew. The Associate or CMA is designed for those new to MySQL and have some hands-on experience.

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

The material on the exam is an overview of the basics. 25% of the exam is on basic data manipulation using SQL -- adding, updating and deleting data. Another 25% is on creating tables and indexes. Grouping and joining make up another 20%. The last 30% is on terminology, transactions, and export/import.

So if you have created a database, entered data, changed some of that data, and have retrieved that data with a 'WHERE' and a 'GROUP BY' then you are most of the way there.

Final results from the UC exams

Four in the afternoon hit all too quickly today at the UC. 209 exams were delivered with 182 people passing. We had a few minor technical glitches but thanks to the very hard work of the Certification Team's all star players Christine Fortier and Ricky Ho (who managed to perform miracles on a routine basis while getting me trained on how UC exams really work) the three days of testing just went by in a blur.

Thanks to all who participated in the exams this year. There were a lot of very special people at the UC that we got to meet at the Magnolia room.

And special thanks to Jay Pipes who handled the UC and my tedious questions with such ease despite having no luggage for most of the conference.

Exams         Pass Fail Total
Associate 11  0 11
Cluster          7  0  7
DBA-I         57 10 67
DBA-II         46  3 49
DEV-I         34  9 43
DEV-II         27  5 32
Grand Total 182 27 209

UC 2008 Exam Results
ID Exam Grade
1 Developer-II fail
227 DBA-I pass
227 DBA-II pass
1024 Developer-II fail
1444 Cluster pass
2123 Developer-I pass
2123 Developer-II pass
2637 DBA-I pass
2715 DBA-I pass
2715 DBA-II pass
2776 DBA-I pass
2776 DBA-II pass
3824 DBA-I pass
3824 DBA-II pass
4532 Cluster pass
4774 DBA-II pass
5355 DBA-I pass
5355 DBA-II pass
5645 DBA-I pass
5688 DBA-I pass
5688 DBA-II pass
5830 Developer-I fail
5903 Cluster pass
6582 CMA pass
6786 DBA-I pass
6804 DBA-I pass
6804 DBA-II fail
7042 DBA-I pass
7042 DBA-II pass
7075 Cluster pass
7075 DBA-I pass
7075 DBA-II pass
7347 Developer-II pass
7424 Developer-II pass
7529 CMA pass
7529 DBA-I fail
7529 DBA-I pass
7529 DBA-II pass
7529 DBA-II pass
7529 Developer-I pass
7875 Developer-II pass
7927 DBA-I pass
7927 DBA-II pass
8218 DBA-I fail
8459 Developer-I fail
8459 Developer-I pass
8459 Developer-II pass
8853 Developer-I pass
8853 Developer-II pass
8874 Developer-I pass
8874 Developer-II pass
8945 DBA-I pass
9017 CMA pass
9047 DBA-I pass
9101 DBA-I pass
9101 DBA-II pass
9106 DBA-I pass
9106 DBA-II pass
9122 DBA-I pass
9122 DBA-I fail
9127 CMA pass
9127 DBA-I pass
9127 DBA-II pass
9127 DBA-II pass
9152 DBA-I pass
9152 DBA-II pass
9176 DBA-I pass
9176 DBA-I fail
9176 DBA-II fail
9176 DBA-II pass
9206 Developer-I fail
9234 DBA-I pass
9234 DBA-II pass
9241 DBA-I pass
9241 DBA-II pass
9270 DBA-I pass
9270 DBA-I fail
9276 Developer-I pass
9276 Developer-II pass
9294 Developer-I fail
9294 Developer-II pass
9300 Cluster pass
9300 DBA-I fail
9310 Developer-I pass
9310 Developer-II pass
9311 DBA-I pass
9311 DBA-II pass
9312 CMA pass
9312 DBA-I pass
9312 DBA-II pass
9312 Developer-I pass
9312 Developer-II pass
9319 Developer-I pass
9319 Developer-II pass
9320 DBA-I pass
9348 DBA-I pass
9348 DBA-II pass
9358 DBA-I pass
9358 DBA-II pass
9359 DBA-I pass
9359 DBA-II pass
9364 Developer-I pass
9367 DBA-I pass
9367 DBA-II pass
9368 CMA pass
9374 CMA pass
9374 DBA-I pass
9374 DBA-II pass
9374 Developer-I pass
9374 Developer-I pass
9375 DBA-I pass
9375 DBA-II pass
9376 Developer-I pass
9379 Developer-I pass
9379 Developer-II pass
9383 DBA-I pass
9383 DBA-II pass
9384 Developer-I pass
9384 Developer-II pass
9385 Cluster pass
9386 Developer-I fail
9386 Developer-II fail
9388 CMA pass
9388 Developer-I pass
9392 Developer-I pass
9392 Developer-II pass
9393 Developer-I pass
9394 DBA-I pass
9394 DBA-II pass
9394 DBA-II pass
9394 Developer-I pass
9394 Developer-II pass
9395 Developer-I pass
9395 Developer-II pass
9396 Developer-I pass
9396 Developer-II pass
9397 Developer-II pass
9400 Developer-I pass
9400 Developer-II pass
9401 DBA-I pass
9401 DBA-II pass
9404 Developer-I pass
9404 Developer-II pass
9408 DBA-I pass
9408 DBA-II pass
9409 Developer-I pass
9410 DBA-I pass
9410 DBA-II pass
9411 Developer-I fail
9412 DBA-I pass
9412 DBA-II pass
9413 DBA-I pass
9414 DBA-I pass
9415 DBA-I pass
9415 DBA-II fail
9416 Developer-I fail
9416 Developer-II pass
9417 CMA pass
833543 DBA-II pass
833543 DBA-II pass
833548 Developer-I pass
833548 Developer-II pass
833578 Developer-I pass
833578 Developer-II fail
838120 DBA-II pass
838154 DBA-I pass
838221 DBA-I pass
838221 DBA-II pass
838225 DBA-I pass
838225 DBA-II pass
838267 DBA-I pass
838267 Developer-I pass
838267 Developer-II pass
838278 Developer-I pass
838278 Developer-II pass
838281 DBA-I pass
838281 DBA-II pass
838303 Developer-I pass
838303 Developer-II pass
838306 DBA-I fail
838324 Developer-I pass
838324 Developer-II fail
838330 DBA-I pass
838330 DBA-II pass
838334 DBA-I pass
838334 DBA-II pass
838413 CMA pass
838413 Developer-I pass
838415 CMA pass
838416 Developer-I fail
838417 DBA-I pass
838418 DBA-I pass
838419 DBA-I fail
838420 Developer-I pass
838420 Developer-II pass
838422 Developer-I fail
838423 DBA-I pass
838424 Cluster pass
838424 DBA-I pass
838424 DBA-II pass
838425 DBA-I pass
838425 DBA-II pass
838427 DBA-I pass
838427 DBA-II pass
838428 Developer-I pass
838429 Developer-I pass
838430 DBA-I pass
838431 DBA-I fail
838432 DBA-I fail

UC Exam Results Day 2

The first persons I met at the UC this year were David Minor and his daughter. David told me he was interested in the Certification Exams and bravely took the plunge on his first exam Tuesday morning. I am very happy to announce he has earned his Associate, Developer and DBA Certifications. Congratulations to David and all the others who took exams.

Thursday is the last day for conference attendees to take their exams for only $25. We will open the exam room at 8:30a and let people take exams until 3:00p. So save $175 or wait until the 2009 Users Conference.

Today we still had problems for those who had not set up their account with Pearson VUE BEFORE taking their exams. Since we hang the certification exams off the data from those accounts. The results below do not include the thirty plus exams waiting for this data.

Exams	Pass	Fail	Total
Associate	6	0	6
Cluster	5	0	5
DBA-I	35	6	41
DBA-II	18	1	19
DEV-I	16	4	20
DEV-II	10	0	10
Grand Total	90	11	101

ID Exam Grade
1444 Cluster pass
2123 Developer-I pass
2637 DBA-I pass
2715 DBA-I pass
2715 DBA-II pass
3824 DBA-I pass
3824 DBA-II pass
4532 Cluster pass
4774 DBA-II pass
5355 DBA-I pass
5688 DBA-I pass
5688 DBA-II pass
5903 Cluster pass
6582 CMA pass
6786 DBA-I pass
7042 DBA-I fail
7042 DBA-II pass
7075 DBA-I pass
7075 DBA-II pass
7424 Developer-II pass
7529 DBA-I pass
7529 DBA-I pass
7875 Developer-II pass
7927 DBA-I pass
8459 Developer-I pass
8459 Developer-I fail
8459 Developer-II pass
8874 Developer-I fail
8874 Developer-II pass
9047 DBA-I pass
9101 DBA-I pass
9101 DBA-II pass
9106 DBA-I pass
9122 DBA-I fail
9127 CMA pass
9127 DBA-I pass
9152 DBA-I pass
9152 DBA-II pass
9176 DBA-I fail
9176 DBA-I pass
9176 DBA-II pass
9176 DBA-II fail
9206 Developer-I fail
9234 DBA-I pass
9241 DBA-I pass
9270 DBA-I fail
9270 DBA-I pass
9276 Developer-I pass
9276 Developer-II pass
9294 Developer-I fail
9294 Developer-II pass
9300 Cluster pass
9300 DBA-I fail
9310 Developer-I pass
9310 Developer-II pass
9311 DBA-I pass
9312 CMA pass
9312 DBA-I pass
9312 DBA-II pass
9312 Developer-I pass
9312 Developer-II pass
9319 Developer-I pass
9319 Developer-II pass
9320 DBA-I pass
9348 DBA-I pass
9348 DBA-II pass
9358 DBA-I pass
9358 DBA-II pass
9359 DBA-I pass
9359 DBA-II pass
9367 DBA-I pass
9368 CMA pass
9374 CMA pass
9374 DBA-I pass
9374 DBA-II pass
9374 Developer-I pass
9374 Developer-I pass
9375 DBA-I pass
9376 Developer-I pass
9379 Developer-I pass
9383 DBA-I pass
9384 Developer-I pass
9385 Cluster pass
833543 DBA-II pass
833543 DBA-II pass
833548 Developer-I pass
838154 DBA-I pass
838221 DBA-I pass
838225 DBA-I pass
838225 DBA-II pass
838267 DBA-I pass
838267 Developer-I pass
838278 Developer-I pass
838281 DBA-I pass
838303 CMA pass
838303 Developer-I pass
838303 Developer-II pass
838306 DBA-I fail
838324 Developer-I pass
838334 DBA-I pass
838334 DBA-II pass

Preliminary Day One Results

Whew! Today was the first 'production' day of certification exams at the Users Conference. We also had a Q&A Session where we gave out door prizes to just about everyone present.

Tomorrow we start at 9am, another

We still have some folks that need their Pearson VUE registration to come through the system before we can enter their grades (Hopefully after 9PM Pacific) but here are the preliminaries:

ID Exam Grade
2715 DBA-I pass
2715 DBA-II pass
3824 DBA-I pass
3824 DBA-II pass
4774 DBA-II pass
5688 DBA-I pass
5903 Cluster pass
7042 DBA-I fail
7075 DBA-I pass
7424 Developer-II pass
7529 DBA-I pass
7875 Developer-II pass
8459 Developer-I fail
8874 Developer-I fail
9122 DBA-I fail
9127 CMA pass
9127 DBA-I pass
9152 DBA-I pass
9176 DBA-I fail
9176 DBA-II fail
9206 Developer-I fail
9234 DBA-I pass
9270 DBA-I fail
9294 Developer-I fail
9300 Cluster pass
9300 DBA-I fail
9310 Developer-I pass
9311 DBA-I pass
9312 DBA-I pass
9312 DBA-II pass
9319 Developer-I pass
9348 DBA-I pass
9358 DBA-I pass
833543 DBA-II pass
833548 Developer-I pass
838154 DBA-I pass
838225 DBA-I pass
838225 DBA-II pass
838267 DBA-I fail
838306 DBA-I fail





Congratulations to those that passed and please try again if you did not.

If you are at the UC and have NEVER tested with us before, go to http://www.pearsonvue.com/mysql and setup an account. We can not put your results into the system until you do this. That part is free.

Pay for the UC exams $25 at the O'Reilly registration desk and bring the card they give you in return to the desk outside the Magnolia room.

Those wishing to RSVP for the late session need to contact Christi Fortier and make sure she has you contact information. She is at the above mentioned desk outside the Magnolia room.

UC Exams

It is finally exam time at the Users Conference. The Magnolia Room where the exams will be given is just past the escalators in the lobby area. Over 20,000 pieces of paper have go into the exams and two staplers were sacrificed in preparation for the six exam sessions. As you can see from the photo, we have plenty of seating just ready for you.

Actually I have been giving exams since Sunday to MySQL Employees who are going to be busy working during the normal exam time.

If you are at the UC, please be sure to stop by to say hello to Christi, Ricky, and me. And thank you for your support of MySql.

User Conference Next Week

Time was invented so everything doesn't happen at once -- S. Wright

Next week is the MySQL Users Conference and getting ready to deliver six plus sessions of exams is quite an exercise in logistics. There are six scheduled sessions. We have only so many seats and so much time for the tests so those of you planning to take an exam need to plan accordingly.

You will find us in the Magnolia Room in the Hyatt Hotel, which is not exactly right next to all the action. Look for signs and ask for directions if you need help.

In the place of computers you would find at your local Pearson VUE test center, we are using pencil and paper (I wonder if paper was ever marketed as Papyrus 2.0 or Cuneiform Tablets++). This is one of the reasons the exams are $25. We will post exams results as quickly as we can.

There will be a Q&A session on Tuesday between 1:00PM and 1:30PM. We will have door prizes for those attending. Please drop by and say hello.