Thursday, June 14, 2012

Training for Database Certifications

Popular database certifications are always in demand, whether it's Microsoft's MCTS .Net and MCITP DBA, Oracle's OCA, OCP and OCM or MySql's CMA, CMDEV and CMDBA.

Are you a database professional seeking to polish your resume in the hopes of landing a better gig?
Perhaps you're just getting started in database administration and you'd like to establish your credentials in the field. Database vendors offer a variety of professional certification programs that can help you advance your career while gaining valuable technical skills. After all, even the most seasoned professional has yet to fully explore some nook or cranny of the field that's covered on a certification exam.  We have training for it all.


So, where do you start? Most database certs are vendor-specific, so you'll want to earn a certification from the company that puts out the software you're currently working with or would like to work with in the future. We'll take a brief look at the credentials available from the major vendors.

If you're an Oracle guru, the Oracle Certified Professional Boot Camp program may be for you. Oracle's program includes three tiers of certification, beginning with the Oracle Database Administrator Certified Associate (OCA), progressing through the Oracle Database Administrator Certified Professional (OCP) and culminating with the Oracle Database Administrator Certified Master (OCM). Each certification is version-specific, so you'll need to update your certification each time a new version of Oracle rolls off the production line.

On the other hand, if you work in a Microsoft shop, you should consider one of several certifications:
If you're maintaining Microsoft Access databases for your organization, the simplest database credential is the Microsoft Office Specialist Access Track. This is a one-exam certification that covers basic knowledge of Microsoft Access topics. Users of Microsoft Access should prepare for the Microsoft Certified Application Specialist (MCAS) program for Microsoft Access.


The Microsoft Certified Technical Specialist MCTS Certification SQL Server credential is the entry-level certification for SQL Server professionals. There are three different certification paths: MCTS SQL Server 2008 Implementation and Maintenance, MCTS SQL Server 2008 Database Development and MCTS SQL Server 2008 Business Intelligence Development and Maintenance. Each requires only a single exam and may be used to build toward higher-level Microsoft certifications.

The Microsoft Certified Information Technology Professional MCITP Certification DBA SQL Server credential is the premier certification for SQL Server administrators. It also comes in three variations. If you already hold the MCTS in SQL Server 200 Implementation and Maintenance, you can upgrade it to MCITP: Database Administrator with a single exam. Similarly, those who passed the MCTS Database Development exam can become MCITP: Database Developers with one additional exam. Finally, if you're an MCTS in Business Intelligence Development and Maintenance, you can upgrade to MCITP: Business Intelligence Developer with one test.

Finally, if you're a MySQL user, you might find one of their four certifications useful in your career:
The MySQL Associate CMA certification requires passing a single exam and attests to the holder's knowledge of basic MySQL skills.
MySQL database administrators may earn the Certified MySQL Database Administrator CMDBA certification by passing two advanced examinations.
Similarly, MySQL developers may earn the Certified MySQL Developer (CMDEV) credential with two development-focused exams.

A b o u t . c o m   Article

CompTIA SmartBrief