MCDBA on Microsoft SQL Server 2000 Certification Requirements

Content Updated: October 14, 2002

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 and Microsoft Press books designed to help MCDBA candidates prepare for the required exams. See individual Exam Preparation Guides for exam availability.

Core Exams (3 Exams Required)

Core Exams: SQL Server Administration (1 Exam Required)	Courses	Books
Exam 70–028: Administering Microsoft SQL Server 7.0	Course 832: System Administration for Microsoft SQL Server 7.0 (5 days)	Microsoft SQL Server 7.0 System Administration Training Kit (ISBN: 1-57231-827-9). This book is out of print. Check with your local retailer for availability.
Exam 70–228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition	Course 2072: Administering a Microsoft SQL Server 2000 Database (5 days)	MCSE Training Kit: Microsoft SQL Server 2000 System Administration MCSE Readiness Review: Microsoft SQL Server 2000 Administration (Exam 70–228)

Core Exams: SQL Server Design (1 Exam Required)	Courses	Books
Exam 70–029: Designing and Implementing Databases with Microsoft SQL Server 7.0	Course 833: Implementing a Database on Microsoft SQL Server 7.0 (5 days)	Microsoft SQL Server 7.0 Database Implementation Training Kit (ISBN: 1-57231-826-0). This book is out of print. Check with your local retailer for availability.
Exam 70–229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition	Course 2073: Programming a Microsoft SQL Server 2000 Database (5 days) Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (2 days)	MCSE Training Kit: Microsoft SQL Server 2000 Database Design and Implementation MCSE Readiness Review: Microsoft SQL Server 2000 Database Design and Implementation (Exam 70–229)

Core Exams: Networking Systems¹ (1 Exam Required)	Courses	Books
Exam 70–215²: Installing, Configuring, and Administering Microsoft Windows 2000 Server	Course 2151: Microsoft Windows 2000 Network and Operating System Essentials (3 days) Course 2152: Implementing Microsoft Windows 2000 Professional and Server (5 days) Course 1560: Updating Support Skills from Microsoft Windows NT® 4.0 to Microsoft Windows 2000 (5 days)	MCSA/MCSE Self-Paced Training Kit: Microsoft Windows 2000 Server, Second Edition (Exam 70-215) MCSE Self-Paced Training Kit: Microsoft Windows 2000 Core Requirements, Second Edition (Exams 70-210, 70-215, 70-216, 70-217) MCSE Readiness Review: Microsoft Windows 2000 Core Exam Set

Elective Exams (1 Exam Required)

Elective Exams (1 Exam Required)	Courses	Books
Exam 70–015: Designing and Implementing Distributed Applications with Microsoft Visual C++® 6.0	Course 1015: Mastering MFC Developing using Microsoft Visual C++ 6.0 (5 days)	Currently, a corresponding Microsoft Press book is not available.
Exam 70–019: Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0	Course 1502: Designing and Implementing a Data Warehouse using Microsoft SQL Server 7.0 (5 days) Course 2074: Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 (5 days)	Currently, a corresponding Microsoft Press book is not available.
Exam 70–155: Designing and Implementing Distributed Applications with Microsoft Visual FoxPro® 6.0	Currently, corresponding Microsoft Official Curriculum is not available.	Currently, a corresponding Microsoft Press book is not available.
Exam 70–175: Designing and Implementing Distributed Applications with Microsoft Visual Basic® 6.0	Course 1016: Mastering Enterprise Development Using Microsoft Visual Basic 6.0 (5 days) Course 1298: Mastering Distributed Application Design and Development Using Microsoft Visual Studio 6.0 (3 days)	Distributed Applications with Microsoft Visual Basic 6.0 MCSD Training Kit
Exam 70–216²: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure	Course 2153: Implementing a Microsoft Windows 2000 Network Infrastructure (5 days) Course 1560: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows 2000 (5 days)	MCSA/MCSE Self-Paced Training Kit: Microsoft Windows 2000 Network Infrastructure Administration, Second Edition (Exam 70-216) MCSE Readiness Review: Microsoft Windows 2000 Network Infrastructure (Exam 70-216) MCSE Self-Paced Training Kit: Microsoft Windows 2000 Core Requirements, Second Edition (Exams 70-210, 70-215, 70-216, 70-217) MCSE Readiness Review: Microsoft Windows 2000 Core Exam Set
Exam 70–305³: Developing and Implementing Web Applications with Microsoft Visual Basic® .NET and Microsoft Visual Studio® .NET	Course 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (5 days) Course 2373: Programming with Microsoft Visual Basic .NET (5 days) Course 2389: Programming ADO.NET (3 days)	MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET Microsoft ASP.NET Step by Step Microsoft ADO.NET Step by Step
Exam 70–306³: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET	Course 2565: Developing Microsoft .NET Applications for Windows (Visual Basic .NET) (3 days) Course 2373: Programming with Microsoft Visual Basic .NET (5 days) Course 2389: Programming with Microsoft ADO.NET (3 days)	MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET Microsoft ASP.NET Step by Step Microsoft ADO.NET Step by Step
Exam 70–310³: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework	Course 2524: Developing XML Web Services Using Microsoft ASP.NET (3 days) Course 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services (5 days) Course 2389: Programming with Microsoft ADO.NET (3 days)	MCAD/MCSD Self-Paced Training Kit: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and Microsoft Visual C# .NET Building XML Web Services for the Microsoft .NET Platform
Exam 70–315³: Developing and Implementing Web Applications with Microsoft Visual C#™ .NET and Microsoft Visual Studio .NET	Course 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (5 days) Course 2124: Programming with C# (5 days) Course 2389: Programming with Microsoft ADO.NET (3 days)	MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET Microsoft ASP.NET Step by Step Microsoft ADO.NET Step by Step
Exam 70–316³: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET	Course 2555: Developing Microsoft .NET Applications for Windows (Visual C# .NET) (3 days) Course 2124: Programming with C# (5 days) Course 2389: Programming with Microsoft ADO.NET (3 days)	MCAD/MCSD Self-Paced Training Kit: Developing Windows-Based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET Microsoft ADO.NET Step by Step Programming Microsoft Windows with C#
Exam 70–320³: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework	Course 2524: Developing XML Web Services Using Microsoft ASP.NET (3 days) Course 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services (5 days) Course 2389: Programming with Microsoft ADO.NET (3 days)	MCAD/MCSD Self-Paced Training Kit: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and Microsoft Visual C# .NET Building XML Web Services for the Microsoft .NET Platform

¹ Candidates who passed both Windows NT 4.0 Exams 70–067 and 70–068 fulfilled the networking system core exam requirement (these exams are no longer available—see the Discontinuation of Exams notice for more details):

Exam 70–067: Implementing and Supporting Microsoft Windows NT Server 4.0 (this exam is no longer available).
Exam 70–068: Implementing and Supporting Microsoft Windows NT Server 4.0 in the Enterprise (this exam is no longer available).

² Candidates who passed Windows NT 4.0 Exams 70–067, 70–068, and 70–073 had the option to take the comprehensive Exam 70–240, Microsoft Windows 2000 Accelerated Exam for MCPs Certified on Microsoft Windows NT 4.0. (This exam is no longer available. See the Discontinuation of Exams notice for more details.) Candidates who passed Exam 70–240 received credit for Exams 70–210, 70–215, 70–216, and 70–217. In the MCDBA track, Exam 70-240 counts as both a core exam (70–215) and an elective exam (70–216). Generally, an exam that can be used as either a core or an elective counts only once toward a certification. Exam 70–240 in the MCDBA track is an exception.

³ In the following combinations, candidates will receive credit for only one of the two exams: 70-305 or 70-315, 70-306 or 70-316, 70-310 or 70-320.

Free Newsletters

Privacy Statement

Accessibility