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

MCDBA candidates are required to pass one SQL Server administration exam and one SQL Server design exam. In addition, MCDBA candidates have the option to pass either one Windows 2000 Server or one Windows Server 2003 exam to fulfill the networking systems core requirement.

Elective Examinations - One Required

In addition to the core exam requirements, you must also pass one elective exam that provides proof of expertise with a specific Microsoft server product.

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

SQL Server Administration 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)

  NB Prerequisite Course:

Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)
 
SQL Server Design Classroom Training
Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition Course 2073: Programming a Microsoft SQL Server 2000 Database (five days)

  NB Prerequisite Course:

Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)
 
Networking Systems 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)
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)

Elective Examinations - One Required

Networking Systems Classroom Training
Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure Course 2278: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure (five days)
Various other development and networking systems exams Contact Us