Savvy, talented and knowledgeable database professionals are always in demand. Here are some of the best certifications for DBAs, database developers, data analysis and architects, BI and data warehousing specialists and anyone else working with databases.
Over the past three decades, we've seen a lot of database platforms come and go, but there's never been any question that database technology can be a crucial component for all kinds of applications and computing tasks.
Database certifications may not be as sexy or bleeding edge as cloud computing, storage or computer forensics. But the reality is that there has been, is and always will be a need for knowledgeable database professionals at all levels and in a number of related job roles. And the emerging data scientist and data analyst roles are getting a lot of attention these days.
To get a better grasp of the available database certifications, it's useful to group them around specific database-related job roles. In part, this reflects the maturity of database technology, and its integration into most aspects of commercial, scientific and academic computing.
Database Job Roles and Opportunities:
As you read about the various database certification programs, keep these job roles in mind:
- Database Administrator (DBA): Responsible for installing, configuring and maintaining a database management system (DBMS). Often tied to a specific platform such as Oracle, MySQL, DB2, SQL Server and others.
- Database Developer: Works with generic and proprietary APIs to build applications that interact with DBMSs (also platform specific, as with DBA roles).
- Database Designer/Database Architect: Researches data requirements for specific applications or users, and designs database structures and application capabilities to match.
- Data Analyst/Data Scientist: Responsible for analyzing data from multiple disparate sources to discover previously hidden insight, determine meaning behind the data and make business-specific recommendations.
- Data Mining/Business Intelligence (BI) Specialist: Specializes in dissecting, analyzing and reporting on important data streams, such as customer data, supply chain data, transaction data and histories, and others.
- Data Warehousing Specialist: Specializes in assembling and analyzing data from multiple operational systems (orders, transactions, supply chain information, customer data and so forth) to establish data history, analyze trends, generate reports and forecasts, and support general ad hoc queries.
Careful attention to these database job roles implies two important kinds of information. First, a good general background in relational database management systems, including an understanding of the Structured Query Language (SQL), is a basic prerequisite for all database professionals.
Second, although various efforts to standardize database technology exist, much of the whiz-bang capability that databases and database applications can deliver come from proprietary, vendor-specific technologies. Most serious, heavy-duty database skills and knowledge are tied to specific platforms, including various Oracle products (such as the open source MySQL environment), Microsoft SQL Server, IBM DB2, so-called NoSQL databases and more.
That's why the majority of the top 5 items you're about to encounter relate directly to those very same, and very popular platforms.
To wind down this section, let's look at the numbers for database certifications. Table 1 displays the results of an informal job search conducted on several high-traffic job boards to see which database certifications employers look for when hiring new employees. Keep in mind that the results vary from day to day (and job board to job board), but the numbers provide a perspective on database certification demand.
We hope you find our top 5 database certification picks for 2016 useful.
Table 1: Job Board Survey
|IBM Info Management||69||58||6||9||0||498||640|
|MCSA: SQL Server 2012||102||46||3||24||24||19||218|
|MCSE: Business Intelligence||44||20||0||10||10||9||93|
|MCSE: Data Platform||47||24||1||16||15||15||118|