| |

Microsoft.com Home | | | Site Map

|

Search Microsoft.com for:

Learning Home

Learning & Reference

Microsoft Training

Microsoft Press Books

Skills Assessments

Certification

Microsoft Certifications

Exams

Information For

IT Professionals

Developers

Home & Office Users

Business Managers

Educators

Beginners

Community

Patterns & Practices

Learning Support

Program Opportunities

Worldwide Sites

Microsoft Certifications  > Microsoft Certified Database Administrator (MCDBA)

MCDBA on Microsoft SQL Server 2000 Certification Requirements

Content Updated: June 27, 2003 |

|

On this page

| Core Exams: SQL Server Administration
|

| Core Exams: SQL Server Design
|

| Core Exams: Networking Systems
|

| Elective Exams
|

|

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.

NEW: Microsoft Windows Server™ 2003 exams now can be used to fulfill the networking systems core exam requirement in combination with SQL Server 2000 exams. See the Windows Server 2003 Exam Integration FAQ for details.

MCDBAs on Microsoft SQL Server 2000 are not required to pass Windows Server 2003 exams to retain MCDBA certification. The Windows 2000 Server exams and the Windows Server 2003 exams for the MCDBA on SQL Server 2000 certification 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 Server or one Windows Server 2003 exam to fulfill the networking systems core requirement.3

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.3

The following tables list Official Microsoft Learning Products 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–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
Exam 70–0283,4: 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.

Core Exams: SQL Server Design
(1 Exam Required)

Courses

Books

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

Exam 70–0293,4: 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.

Core Exams: Networking Systems1
(1 Exam Required)

Courses

Books

NEW: Exam 70–290: Managing and Maintaining a Microsoft Windows Server 2003 Environment

Course 2274: Managing a Microsoft Windows Server 2003 Environment (5 days)

Course 2275: Maintaining a Microsoft Windows Server 2003 Environment (3 days)

OR

Course 2208: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (3 days)

MCSA/MCSE Self-Paced Training Kit (Exam 70-290): Managing and Maintaining a Microsoft Windows Server 2003 Environment

MCSE Self-Paced Training Kit: Microsoft Windows Server 2003 Core Requirements, Exams 70-290, 70-291, 70-293, 70-294

NEW: 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 (2 days)

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

OR

Course 2208: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 (3 days)

MCSA/MCSE Self-Paced Training Kit (Exam 70-291): Implementing, Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

MCSE Self-Paced Training Kit: Microsoft Windows Server 2003 Core Requirements, Exams 70-290, 70-291, 70-293, 70-294

Exam 70–2152: 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)

OR

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)

MCSA Self-Paced Training Kit: Microsoft Windows 2000 Core Requirements, Second Edition (Exams 70-210, 70-215, 70-216 and 70-218)

Elective Exams (1 Exam Required)

Elective Exams
(1 Exam Required)

Courses

Books

Exam 70–2162: 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 Self-Paced Training Kit: Microsoft Windows 2000 Core Requirements, Second Edition (Exams 70-210, 70-215, 70-216, 70-217)

NEW: 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 (5 days)

MCSE Self-Paced Training Kit (Exam 70-293): Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

MCSE Self-Paced Training Kit: Microsoft Windows Server 2003 Core Requirements, Exams 70-290, 70-291, 70-293, 70-294

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)

Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET. This book is out of print. Check with your local retailer for availability.

Microsoft ASP.NET Step by Step. This book is out of print. Check with your local retailer for availability.

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) (5 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 Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET. This book is out of print. Check with your local retailer for availability.

Microsoft ASP.NET Step by Step. This book is out of print. Check with your local retailer for availability.

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)

Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET. This book is out of print. Check with your local retailer for availability.

Microsoft ASP.NET Step by Step. This book is out of print. Check with your local retailer for availability.

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) (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 Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET. This book is out of print. Check with your local retailer for availability.

Microsoft ADO.NET Step by Step

Programming Microsoft Windows with C#. This book is out of print. Check with your local retailer for availability.

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

Exam 70–0154: 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–0193,4: 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–1554: 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–1754: 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. This book is out of print. Check with your local retailer for availability.

1 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).

2 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.

3 Exams 70-019, 70-028, and 70-029 cannot be used to fulfill MCDBA on Microsoft SQL Server 2000 certification requirements if combined with exams 70-290 or 70-291. Please see the Windows Server 2003 exam FAQ for more details.

4 This exam is scheduled to be discontinued. For more information about discontinued exams, see the Discontinuation of Exams notice for more details.

|

Manage Your Profile |Contact Us |E-mail this page |Free Newsletter

©2004 Microsoft Corporation. All rights reserved. Terms of Use |Trademarks |Privacy Statement