How Do I Earn a Microsoft MCDBA Certification?
MCDBA stands for Microsoft Certified Database Administrator. This certification was designed for database administrators with experience implementing, designing and administrating databases with Microsoft SQL Server 2000.
Microsoft MCDBA Overview
In September 2012, Microsoft retired its MCDBA certification. It was replaced by two alternative certifications. One is the Microsoft Certified Solutions Expert (MCSE): Business Intelligence designation; the other is the MCSE: Data Platform designation. Those who earned the MCDBA credential can still claim it as a legacy certification, Microsoft notes.
The MCDBA certification was designed for database administrators who had experience with Microsoft SQL Server 2000. The MCDBA certification gave database administrators the tools to solve problems effectively and develop solutions that were in line with business needs.
Important Facts About MCDBA Certification
|Certification Duration||Typically three to six months, depending upon prior experience with servers, networks and SQL|
|Prerequisites||12 months of experience with Microsoft servers and databases is highly recommended, but not required|
|Possible Careers||Database administrator, database analyst, database developer, web application developer, Internet developer|
|Continuing Education||Visual Basic .NET for Web, Visual C# Web Applications, Microsoft .NET Applications, and other certifications are available|
|Median Salary (2018)||$90,070 (for all database administrators)*|
|Job Outlook (2016-2026)||11% growth (for all database administrators)*|
Source: *U.S. Bureau of Labor Statistics
To earn the MCDBA certification, students had to pass exams in SQL server administration, SQL server design and networking systems. Students also passed an additional elective exam to prove competency in a particular Microsoft server product.
Exams to fulfill the SQL Server Administration requirement included:
- Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
- Administering Microsoft SQL Server 7.0
To meet the exam requirement for SQL Server Design, students could have taken:
- Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
- Designing and Implementing Databases with Microsoft SQL Server 7.0
For the Networking Systems core requirement, students could have chosen between:
- Managing and Maintaining a Microsoft Windows Server 2003 Environment
- Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
- Installing, Configuring, and Administering Microsoft Windows 2000 Server
In addition to these core areas, there were 15 elective exams to choose from. Students were only required to complete one elective exam. It was recommended that an elective exam be taken in an area that strengthens the existing knowledge of a particular IT area.
Preparing for and Scheduling Certification Exams
When this certification was available, students could look to training centers nationwide that offered Microsoft-approved courses to prepare for the individual exams. All Microsoft certification exams were given through Prometric. A list of exam sites and online exam registration is available through www.prometric.com.