Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server™ 2000 candidates need to pass three core exams and one elective exam that provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of SQL Server databases.
Microsoft is integrating Microsoft Windows® XP Professional and Microsoft .NET Enterprise Servers exams into the MCDBA on Microsoft SQL Server 2000 certification. Individuals should continue to pursue training and certification in Windows 2000, as skills acquired for Windows 2000 will be highly relevant to and provide a critical foundation for Windows XP Professional and .NET Enterprise Servers.
MCDBAs on Microsoft SQL Server 2000 will not be required to pass Windows XP Professional/.NET Enterprise Servers exams to retain MCDBA certification. The Windows 2000 exams and the Windows XP/.NET Enterprise Servers exams for the MCDBA on Microsoft SQL Server 2000 certification are expected to remain available concurrently.
Core Exams (3 Exams 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 or one .NET Enterprise Servers exam to fulfill the networking systems core requirement.
Elective Exams (1 Exam 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.
The following tables list Microsoft Official Curriculum (MOC) courses designed to help MCDBA candidates prepare for the required exams. See individual Exam Preparation Guides for exam availability.
SQL Server Administration (1 Exam Required)
| 70-228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition | 2072 Administering a Microsoft SQL Server 2000 Database (5 days) |
SQL Server Design (1 Exam Required)
| 70-229 Designing and Implementing Databases with MS SQL Server 2000 Enterprise Edition | 2071 Querying Microsoft SQL Server 2000 with Transact-SQL (2 days) 2073 Programming a Microsoft SQL Server 2000 Database (5 days) |
Networking Systems (1 Exam Required)
| 70-290 Managing and Maintaining a Microsoft Windows Server 2003 Environment | 2208 Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (5 days) OR 2274 Managing a Microsoft Windows Server 2003 Environment (5 days) 2275 Maintaining a Microsoft Windows Server 2003 Environment (3 days) OR 2273 Managing and Maintaining a Microsoft Windows Server 2003 Environment |
| 70-291 Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure | 2208 Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (5 days) OR 2276 Implementing a Microsoft Windows Server 2003 Network Infrastructure Network Hosts (2 days) 2277 Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure Network Services (5 days) |
| 70-215 Installing, Configuring, and Administering Microsoft Windows 2000 Server | 1560 Updating Support Skills from Microsoft Windows NT® 4.0 to Microsoft Windows 2000 (5 days) OR 2151 Microsoft Windows 2000 Network and Operating System Essentials (3 days) 2152 Implementing Microsoft Windows 2000 Professional and Server (5 days) |
Elective Exams
| 70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure | 1560 Updating Support Skills from Microsoft Windows NT® 4.0 to Microsoft Windows 2000 (5 days) OR 2153 Implementing a Microsoft Windows 2000 Network Infrastructure (5 days) |
| 70-293 Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure | 2278 Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure (5 days) |
| 70-305 Dev and Imp Web Applications with Visual Basic .NET and Visual Studio .NET | 2310 Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (5 days) 2373 Programming with Microsoft Visual Basic .NET (5 days) 2389 Programming ADO.NET (3 days) |
| 70-306 Dev and Imp Windows-based App with Visual Basic .NET and Visual Studio .NET | 2373 Programming with Microsoft Visual Basic .NET (5 days) 2389 Programming ADO.NET (3 days) 2565 Developing Microsoft .NET Applications for Windows (Visual Basic .NET) (3 days) |
| 70-310 Dev XML Web Service and Server Comp with VB .NET and the .NET Framework | 2389 Programming ADO.NET (3 days) 2524 Developing XML Web Services Using Microsoft ASP.NET (3 days) 2557 Building COM+ Applications Using Microsoft .NET Enterprise Services (5 days) |
| 70-315 Dev and Imp Web Applications with Visual C# .NET and Visual Studio .NET | 2124 Programming with C# (5 days) 2310 Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (5 days) 2389 Programming ADO.NET (3 days) |
| 70-316 Dev and Imp Windows-based App with Visual C# .NET and Visual Studio .NET | 2124 Programming with C# (5 days) 2389 Programming ADO.NET (3 days) 2555 Developing Microsoft .NET Applications for Windows (Visual C# .NET) (3 days) |
| 70-320 Dev XML Web Services and Server Comp with Visual C# and the .NET Framework | 2389 Programming ADO.NET (3 days) 2524 Developing XML Web Services Using Microsoft ASP.NET (3 days) 2557 Building COM+ Applications Using Microsoft .NET Enterprise Services (5 days) |