For this installment of my recruiting/certification column, I have decided to turn my attention to the MySQL certification. It's another one of the open source-based certification programs that seems to be gaining a lot of traction in the marketplace. We, as most of you probably know, continue to see companies implementing MySQL as an alternative to proprietary databases on the market. As a result we have seen a dramatic increase in searches by companies looking for people with MySQL experience. Therefore, it's only prudent that we take the time out to learn more about this relatively new certification.
As with the previous article on the Zend Certified Engineer, ZCE, I have decided to take the same approach when exploring the ins and outs of the MySQL certification. In essence, I figured the best way to learn about the certification is to get viewpoints from people in the field. To learn the basics about the program, I spoke with Carsten Pedersen, who heads up the certification program for MySQL AB. From there, I exchanged e-mails with Ian Gilfillan of Independent Online, a leading newspaper in South Africa, and author of a book on MySQL to get an insider's viewpoint as to why he feels it is of value to spend corporate dollars on providing the certification for his employees. Last, I spoke with Mark Nielsen, who at the time of this interview was a MySQL DBA at Google and is now at CNET, to learn about the benefits he has gotten from being certified and how it has assisted him in his job searches over the recent past.
Interview with Carsten Pedersen of MySQL...
LWM: How long has the exam been in existence (Core and Professional)?
Carsten Pedersen: We started with the Core exam in the late fall of 2002. The Professional exam came into existence about half a year later (early 2003).
LWM: What is the number of certified MySQL professionals presently (Core and Professional)?
CP: To date, we have delivered more than 1,200 exams worldwide. About a quarter of these are Professional certification exams. It's been a slow start, but we're really seeing things pick up now. At our recent User's Conference, we had two certification tutorials and they were both among the ones most attended.
On our Web site (www.mysql.com/certification) you can find a list of certified people (it's incomplete, as not everyone wants their name published).
LWM: What is their breakdown of location? How many in the U.S., Europe, etc?
CP: North America accounts for about 50% of the delivered exams; of these, 85% are in the U.S. and 15% in Canada. In Europe, which accounts for another 40% of the exams, most are delivered in Germany and the United Kingdom. The remaining 10% are delivered across the rest of the world.
LWM: What percentage of the people move on to take the Professional certification exam after obtaining the Core certification?
CP: About one-third of the people who have the Core certification move on to attempt getting the Professional certification.
LWM: What is the pass rate of the number of people who take the exam (both Core and Professional)?
CP: For first-time exam takers, the pass rate on the Core exam is about 65%. For the Professional exam, this number is close to 50%.
LWM: What is the level of experience that you recommend for someone looking to take the exam (Core)?
CP: We recommend that those who want to take the Core exam have at least a few months worth of full-time experience, and those who go for the Professional title have six months or more of experience. But this is very hard to quantify: if you take one of our courses and do some intensive self-studying, you might be able to do the whole thing in three weeks. If you're learning on your own and not doing full-time MySQL work, it may take you many months to gain the knowledge and experience needed to pass just the Core exam. The type of work you do during the time you are getting ready for the exam also influences how much time you should expect to invest.
LWM: Do you advise people to purchase the study guide?
CP: Certainly! Of course, being one of the co-authors, I'm bound to say so. :-)
From what we are told the Study Guide does help those studying for the exams. I've also had many people telling me that it's one of the best sources around for learning the ins and outs of MySQL and (after the exams) a great reference tool. The main authors, Paul DuBois and Stefan Hinz, are both recognized as some of the best authors on the subject of MySQL.
There's good financial sense in getting the Study Guide, too. It contains a voucher that pays back 25% of the exam cost when you go to your first exam. For a lot of people, this means that you basically get the book at zero cost or some even get money back!
LWM: Do you happen to have any data that suggests the differentiation in salary levels for people with the certification as opposed to those without it? Any increase in compensation for people with Professional versus Core?
CP: We do not and, quite frankly, I doubt that any certifying body has the numbers to make such claims with any sort of reliability. Sure, there are studies out there claiming that certified people tend to get a higher salary. However, once you start digging into the background data, several questions on statistical validity and methodology raise their ugly head.
For MySQL certification, the problem is compounded with certification holders being spread across the globe - salaries and benefits vary too much from one area to another to make any valid comparisons.
That said, I have indeed spoken with several people who have told me they got hired into a company or got a better placement within their organization because they had invested the time in studying for the exams. I have also heard from consultants who are convinced that they would not have landed a specific job, if they had not been certified. Mind you, in all of these cases, certification was only part of the overall picture they were able to present to their employers or customers - but they were indeed what put people "over the barrier."
MySQL is becoming more and more accepted in the enterprise sector, and here certification is the norm, not the exception. If you're to even be considered for a job with one of these companies, there's no way around getting certified.
LWM: Is it strictly a multiple-choice exam? If not, what else is involved?
CP: On the current exams there are also a few questions that will require you to "fill in the blank" with a word or two. However, for a number of reasons, we are moving away from this type of question and strictly into multiple choice.
LWM: Where is the exam administered?
CP: Our exams are mainly distributed through more than 3,000 Pearson VUE testing centers across the globe (www.vue.com/mysql). At times, we also offer exams during events such as the MySQL User's Conference and other conferences or trade shows.
LWM: Do you plan on collaborating with other vendors, such as Zend, to offer a certification that comprises more components of the LAMP stack?
CP: We have talked with both Zend and LPI about doing exactly that, but currently there are no specific plans to do this.
Interview with Ian Gilfillan of Independent Online...
LWM: Could you tell me about your work/development environment and why the MySQL certification was/is important?
Ian Gilfillan: Back then I was IT manager of Independent Online, South Africa's premier news Web site, and we used MySQL and PHP exclusively. With resource constraints, we had a small team of developers, and they needed to be highly skilled and productive to cope with the workload. The MySQL setup was reasonably complex, with a number of replicating servers, and the development environment was also fairly complex, with a number of different systems. A common problem was developers writing inefficient queries, which then impacted a number of other systems. I decided to provide an incentive to the developers to improve their SQL skills, in particular by offering MySQL certification.
Another reason was to relieve some of the workload off myself. I wrote the book Mastering MySQL 4, and I also write a regular monthly column for Database Journal, and most MySQL-related tasks tended to get left to me. As IT manager I was required to do other things, so I needed to make sure that the rest of the staff felt comfortable taking these over.
LWM: Did you notice any improvement in the employees' work after being certified?
IG: It's fairly difficult to measure, as the developers' tasks were not repetitive and varied widely in scope, and were therefore not easily compared. The staff themselves said they felt much more confident afterward, and recommended certification for all new staff. They were also keen to work toward the professional certification.
LWM: How would you rate it in comparison to other certification programs that you have sponsored employees for in the past?
IG: I have not sponsored any other certification programs, although staff have attended courses. The training for the MySQL certification was done on their own (with some company time allocated), and I was more satisfied with the results of this than all the training courses staff have been sent to in the past.
LWM: Would you as a company/manager do it again? Future hires?
IG: I would undoubtedly do it again. Future hires were also put through the same process.
LWM: What were/are some of the comments about the exam itself (easy/hard)?
IG: Almost universally it was seen as harder than expected, or quite tricky.
LWM: Do you as a company tend to offer individuals higher compensation for having achieved the certification?
IG: No, we did not offer higher compensation.
LWM: Has the result of the company sponsoring individuals for the certification helped you in your recruitment efforts?
IG: I believe so. I have mentioned the program to potential new recruits, and it was positively received. Whether this swung a candidate in a particular case I don't know, but it was another positive reason to work for us.
LWM: In addition, has it resulted in the retainment of your top talent?
IG: I'm not sure, as it's difficult to measure this. I believe it was a relatively minor factor among many.
Interview with Mark Nielsen of Google...
LWM: Could you tell me why you felt that it was important for you to achieve the MySQL certification?
Mark Nielsen: I am very picky about certifications, as most of them are a waste of time. Most certifications seem to be driven to make the parent company money and are not designed to truly test candidates. The MySQL certification seemed to me to be the right combination of cost, the number of exams, and reasonably fair questions. Besides enjoying MySQL, I wanted to be certified in some sort of database technology. The other DB certifications just didn't appeal to me. MySQL certification appealed to me on many levels, just like the Linux certification from LPI appealed to me for operating system certification.
LWM: What prompted you to move forward and achieve the Professional certification on top of the Core?
MN: The company I was working for at the time was going downhill and wouldn't make critical technological shifts toward MySQL for the databases and WhiteBox Linux for its operating system (now I support CentOS and Ubuntu Linux as well). In order to not be in a position where my recommendation to use MySQL would be ignored, I figured getting certified in MySQL would add credibility toward my ideas.
LWM: How would you compare the MySQL certification to other certifications you have achieved?
MN: The only other certification program that I enjoyed was the LPI certification program for Linux. All the rest were either too primitive - they just steal your money or overinflate the true value of their tests. Most certification programs are viewed with disdain by most true computer geeks because most certifications don't mean anything. But to me, the LPI and MySQL certifications are fun; they test your skills and support open source technology. If nobody would ever have known I was MySQL certified, I would still have taken the tests just for myself.
LWM: Do you believe that the MySQL certification has assisted you in landing the job(s) that you have had since being certified?
MN: Yes. Most companies need a DBA and a programmer at the same time. Having the MySQL certification can be used as a political tool to convince HR and non-technical employees to hire a candidate as a DBA, when really the candidate can be used for other purposes as well. I used to be opposed to all certification processes, but certifications are a good way to get past non-technical HR individuals and managers who don't know how to filter out résumés other than by looking at certifications. It's just a fact of life.
LWM: What do you believe to be the greatest benefit of being MySQL certified?
MN: Personal achievement. I use certification programs to enhance my knowledge and keep my skills updated. That's why I retook the LPI Level 1 certifications. I didn't have to; I just wanted to prove to myself that I could do it. Probably next year I'll get recertified in MySQL as well.
Summary
From these interviews, it's fairly apparent that the MySQL certification program is poised for continued success. The number of professionals that they are certifying continues to expand at an exponential rate. I personally believe that it's very smart of them to offer both a Core and Professional exam. Not only does it provide the corporation with an additional revenue stream but, more important, it increases our confidence in an individual's knowledge of MySQL since he or she has achieved the different tiers of the certification.
It was wonderful to learn firsthand about the benefits Ian has gained by getting his employees certified and how that has assisted him and his corporation in the recruitment of MySQL database professionals. I always applaud corporations that are willing to put the effort, both from a time and financial perspective, to better their employees by providing them with incentives to continue their education.
Last, it was interesting to hear Mark's take on how, by getting MySQL certified, it has assisted him in both a personal and professional manner. As he mentioned, we often get a lot of people telling us that they believe certifications are somewhat meaningless and a waste of time. However, as he pointed out, and truthfully I might add, whether you are in favor of certifications or not, corporations still value them. They are a means to demonstrate your knowledge and will never hurt you in your job search. If you are on the fence as to whether or not you think it would be a good idea to get certified, I always tell people to go ahead and do it, because it only can assist you in your professional career.