Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 12, 2005

A Database Journal Guide to MySQL Certification: Part 1, Core Certification

By Ian Gilfillan

The value of certification

I recently arranged for the developers at our company to get MySQL certified. From the employer's point of view, it was not the piece of paper I was after. Rather, the improved productivity that properly-trained MySQL users could provide. The benefits have been noticeable. The number of badly written queries has decreased, saving everyone time and effort. The developers feel more confident using MySQL, and can use features they previously had not known existed.

There are two sources of MySQL certification that I know about. One is the Brainbench MySQL 3.23 certification, and the other one, much more well-known, and more credible, is the official MySQL certification, which consists of two levels, Core (for MySQL users) and Professional (for MySQL administrators). The Brainbench one is rather outdated. Since the latest stable release, MySQL 4.1, is two major versions away from 3.23, there is not much benefit to be gained from the Brainbench certification. Also, Brainbench tests are seen as less credible because they can be done online, without supervision, but this can easily be overcome by an employer ensuring the test is done on their premises (and Brainbench offers a free repeat test to employers if they wish to validate an employees certification).

Nevertheless, the rest of this article focuses on the official MySQL Core certification. What follows is a reference for people studying for the Core certification, including a list of topics covered in the Core exam, as well as resources from mainly the MySQL site and Database Journal that you can use to enhance your studies.

MySQL Core Certification

The test covers MySQL 4.1, and tests the typical skills required by a MySQL usersomeone using MySQL, such as a developer. In general, this includes data definition (creating, modifying and deleting databases and tables) and data manipulation (inserting, modifying, deleting and selecting data).

The complete list of exam topics (as defined by MySQL in March 2005) follows, as well as links to relevant Database Journal and other articles that can help you study this topic:

Other resources

» See All Articles by Columnist Ian Gilfillan

MySQL Archives

Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM