The Microsoft Certified Database Administrator (MCDBA) certification provides proof of your ability to design, implement, and manage SQL Server 2000 databases. If you work with SQL Server 2008 or SQL Server 2012 databases, see below for our recommended certifications.
Level:
One year of experience working with Microsoft SQL Server
Audience:
IT professional
Type:
Microsoft Certification
Individuals who hold the MCDBA certification have proven their ability to design, implement, and manage the administration of SQL Server 2000 databases. While three exams that are included in the requirements for earning this certification are still available, all other required exams are retired.
We recommend the following SQL Server certifications—choose one that reflects your job role, career goals, and version of SQL Server:
Microsoft Certified Solutions Expert (MCSE): Data Platform—for database professionals who build enterprise-scale data solutions on-premise or in cloud environments
MCSE: Business Intelligence—for database professionals who develop and deploy business intelligence solutions and reports
Microsoft Certified IT Professional (MCITP) certifications—for database professionals who design, implement, build on, troubleshoot, and support SQL Server 2008 solutions
Microsoft Certified Master (MCM)—for senior-level IT professionals who seek in-depth and comprehensive training on implementing SQL Server 2008 solutions
Learn about changes to the Microsoft Certification program
To earn the Microsoft Certified Database Administrator (MCDBA) credential, you must pass four exams (in any order):
One Microsoft SQL Server Administration exam
One SQL Server Design exam
One Microsoft Windows 2000 Server or Windows Server 2003 exam
One elective exam
Note All exams in this certification track are retired, with the exception of Exams 70-290, 70-291 and 70-293. If a required exam is retired and you have not yet passed that exam, you cannot complete the certification track. You must fulfill all listed requirements to earn the certification. If you passed a required exam before it retired, it can be applied toward certification.
Exams on SQL Server Administration: Choose one
Exam number
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
Exam 70-2281
Administering Microsoft SQL Server 7.0
Note This exam cannot be used to fulfill this requirement if you choose Exam 70-290 or 70-291 for the Windows 2000 Server/Windows Server 2003 requirement.
Exam 70-0281
Exams on SQL Server Design: Choose one
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Exam 70-2291
Designing and Implementing Databases with Microsoft SQL Server 7.0
Note This exam cannot be used to fulfill the SQL Server Design requirement if you choose Exam 70-290 or 70-291 for the Windows 2000 Server/Windows Server 2003 requirement.
Exam 70-0291
Exams on Windows 2000 Server or Windows Server 2003: Choose one
Managing and Maintaining a Windows Server 2003 Environment
Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure
Installing, Configuring, and Administering Microsoft Windows 2000 Server
Exam 70-2151
Elective exams: Choose one
Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
Exam 70-2161
Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
TS: Microsoft .NET Framework 2.0 – Web-Based Client Development
NoteCandidates who are MCAD-certified may substitute Exam 70-551 to satisfy this requirement. Candidates who are MCSD-certified may substitute Exam 70-553 to satisfy this requirement.
Exam 70-5281
TS: Microsoft .NET Framework 2.0 – Windows-Based Client Development
NoteCandidates who are MCAD-certified may substitute Exam 70-552 to satisfy this requirement. Candidates who are MCSD-certified may substitute Exam 70-553 to satisfy this requirement.
Exam 70-5261
TS: Microsoft .NET Framework 2.0 – Distributed Application Development
Exam 70-5291
Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Exam 70-3051
Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Exam 70-3061
Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
Exam 70-3101
Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
Exam 70-3151
Developing and Implementing Windows-Based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
Exam 70-3161
Developing XML Web Services and Server Components with Microsoft Visual C# .NET and the Microsoft .NET Framework
Exam 70-3201
Designing and Implementing Distributed Applications with Microsoft Visual C++ 6.0
Exam 70-0151
Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0
This exam cannot be used to fulfill the elective requirement if you choose Exam 70-290 or 70-291 for the Windows 2000 Server/Windows Server 2003 requirement.
Exam 70-0191
Designing and Implementing Distributed Applications with Microsoft Visual FoxPro 6.0
Exam 70-1551
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0
Exam 70-1751
1 This exam is retired, but if you already passed it, you can apply it toward this certification.
Upgrade paths from MCDBA to MCTS or MCITP on SQL Server 2005 are no longer available. All exams for these upgrade paths are retired. For information about the paths that were previously available, see the Certification Planner Tool on the MCP Member site, or contact your Regional Service Center.
Sign in to the MCP member site to access the Certification Planner Tool
Find your Microsoft Regional Service Center
