Introduction

The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The 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 SQL Server 2000.

Audience

The MCDBA on SQL Server 2000 Certification is appropriate for:

Examination Requirements

MCDBA candidates on the Microsoft Windows Server 2003 track are required to satisfy the following requirements:

Core Examinations - Three Required

Elective Examinations - One Required

Together with the core exams, the elective exams provide a valid and reliable measure of technical proficiency and expertise to successfully manage and maintain the typically complex computing environment of medium-to-large-sized companies. MCDBA candidates should have 6–12 months of experience administering client and network operating systems.

Upgrade Examinations - One Required

Microsoft has designed an upgrade path that will enable a current MCDBA to earn the Windows Server 2003 credential in a time-effective and cost-effective manner.

Examination to Course Requirements

The table below presents a simplified set of combinations of examinations to Microsoft courses to achieve the MCDBA. Please contact us for other possible permutations.

Core Examinations - Three Required

Core Exams: Networking System (Two Exams Required) Classroom Training
Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment Course 2273: Managing and Maintaining a Microsoft Windows Server 2003 Environment (five days)

or

Course 2208: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (three days)
Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure Course 2276: Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts (two days)

and

Course 2277: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services (five days)

or

Course 2208: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (three days)
 
Core Exams: Client Operating System - One Exam Required Classroom Training
Exam 70-270: Installing, Configuring, and Administering Microsoft Windows XP Professional Course 2285: Installing, Configuring, and Administering Microsoft Windows XP Professional (two days)

or

Course 2272: Implementing and Supporting Microsoft Windows XP Professional (five days)
Exam 70-210: Installing, Configuring, and Administering Microsoft Windows 2000 Professional Course 2151: Microsoft Windows 2000 Network and Operating System Essentials (three days) Course 2152: Implementing Microsoft Windows 2000 Professional and Server (five days)
 

Elective Examinations - One Exam Required

Elective Exams - One Exam Required Classroom Training
Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition Course 2072: Administering a Microsoft SQL Server 2000 Database (five days)
Exam 70-235: TS: Developing Business Process and Integration Solutions Using BizTalk Server 2006 Course 2933: Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 (five days)

Course 2934: Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 (two days)
Exam 70-284: Implementing and Managing Microsoft Exchange Server 2003 Course 2400: Implementing and Managing Microsoft Exchange Server 2003

and

Workshop 2011: Troubleshooting Microsoft Exchange Server 2003
Exam 70-285: Designing a Microsoft Exchange Server 2003 Organization Course 2008: Designing a Microsoft Exchange Server 2003 Organization (two days)
Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance Course 2779: Implementing a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006)

and

Course 2780: Maintaining a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006)
MCDST N/A
MCDBA on Microsoft Windows 2000 N/A
MCSE on Microsoft Windows 2000 N/A
CompTIA A+

and

CompTIA Network+ 		N/A
CompTIA A+

and

CompTIA Server+ 		N/A
CompTIA Security+ CompTIA Security+

Upgrade Examination

Upgrade Exams for an MCSE on Windows 2000 - Two Exams Required Classroom Training
Exam 70-292: Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCDBA Certified on Windows 2000 Course 2299: Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCDBA Certified on Windows 2000 (available November 2003)

or

Course 2273: Managing and Maintaining a Microsoft Windows Server 2003 Environment (five days)

plus

Course 2276: Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts (two days)

and

Course 2277: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services (five days)