Overview

MCDBA candidate profile
The Microsoft Certified Database Administrator (MCDBA) certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server. The MCDBA certification validates a unique set of skills that are required to succeed in a variety of job roles, such as database administrator, database analyst, and database developer. Candidates should have at least one year of experience working with Microsoft SQL Server.

 

For individuals who administer, develop, or analyze Microsoft SQL Server 2005 or SQL Server 2008 databases, we offer Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) certification paths that reflect current job roles.Additionally, a Microsoft Certified Master (MCM) certification is available for senior-level IT professionals who seek in-depth and comprehensive training on implementing database solutions by using Microsoft SQL Server 2008.

 

Why get certified?
Earning a Microsoft Certification validates your proven experience and knowledge in using Microsoft products and solutions. Designed to be relevant in today's rapidly changing IT marketplace, Microsoft Certifications help you utilize evolving technologies, fine-tune your troubleshooting skills, and improve your job satisfaction.

 

Whether you are new to technology, changing jobs, or a seasoned IT professional, becoming certified demonstrates to customers, peers, and employers that you are committed to advancing your skills and taking on greater challenges. In addition, certification provides you with access to exclusive Microsoft Certified Professional (MCP) resources and benefits, including opportunities to connect with a vast, global network of MCPs.

 

Certifications

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 Many of the exams in this certification track are retired. 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. The credential will not expire.

 

Exams on SQL Server Administration: Choose one
Content 1
  Exam Number

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-228

Administering Microsoft SQL Server 7.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification. 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-028
Exams on SQL Server Design: Choose one
Content 2
  Exam Number

Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-229

Designing and Implementing Databases with Microsoft SQL Server 7.0

Note This exam is retired, but if you already passed it, you can apply it toward this certification. 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-029
Exams on Windows 2000 Server or Windows Server 2003: Choose one
  Exam Number
Managing and Maintaining a Windows Server 2003 Environment Exam 70-290
Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure Exam 70-291

Installing, Configuring, and Administering Microsoft Windows 2000 Server

Note This exam is retired, but if you already passed it, you can apply it toward this certification.

Exam 70-215

 

Upgrade Paths

Upgrade from MCDBA to MCTS on SQL Server 2005

As a Microsoft Certified Database Administrator (MCDBA), you have the option of upgrading your credential to reflect your Microsoft SQL Server 2005 expertise by earning a Microsoft Certified Technology Specialist (MCTS) credential.

 

Upgrade to MCITP Database Administrator

Once you have earned the MCTS credential by following the upgrade path described above, you have completed the prerequisite for the MCITP Database Administrator credential.