MCDBA on Microsoft SQL Server 2000 Certification Requirements

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.

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.

You Will Learn:

•  To install Microsoft SQL Server

•  To Administer Microsoft SQL Server

•  To Support Microsoft SQL Server

  Career Opportunities:

•  Information System (IS) Professionals

•  Database Administrators

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

LearnKey Course

Exam 70–228 : Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Course 2072 : Administering a Microsoft SQL Server 2000 Database (5 days)

41258
SQL Server 2000 Administration

Exam 70–028 3,4 : Administering Microsoft SQL Server 7.0

Discontinued

Course 832 : System Administration for Microsoft SQL Server 7.0 (5 days)

 

 

Core Exams: SQL Server Design
(1 Exam Required)

Courses

LearnKey Course

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)

411398
SQL Server 2000 Implementing Database Design

Exam 70–029 3,4 : Designing and Implementing Databases with Microsoft SQL Server 7.0

Discontinued

Course 833 : Implementing a Database on Microsoft SQL Server 7.0 (5 days)

 

 

Core Exams: Networking Systems 1
(1 Exam Required)

Courses

LearnKey Course

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)

 

680418
Managing a Network Environment

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)

 

680358
Implementing Network Infrastructure

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

600518
Windows 2000 Server Administration

Elective Exams (3 Exams Required)

Elective Exams
(1 Exam Required)

Courses

LearnKey Course

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

 

600278
Windows 2000 Network Infrastructure Administration

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)

680478
Planning Network Infrastructure

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)

 

371898
ASP.NET for Developers Series Parts 1 & 2

441138
VB.NET for Developers Series Parts 1, 2 & 3

372538
ADO.NET for Developers Series Parts 1 & 2

 

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)

371898
ASP.NET for Developers Series Parts 1 & 2


441138
VB.NET for Developers Series Parts 1, 2 & 3

 372538
ADO.NET for Developers Series Parts 1 & 2

   

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)

372018
XML.NET for Developers

370682
COM+ for Developers (Windows based not .NET will need to supplement)

372538
ADO.NET for Developers Series Parts 1 & 2

 

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)

371898
ASP.NET for Developers Series Parts 1 & 2

371588
C# for Developers

 372538
ADO.NET for Developers Series Parts 1 & 2

 

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)

 

371588
C# for Developers

   

372538
ADO.NET for Developers Series Parts 1 & 2

   

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)

372018
XML.NET for Developers

370682
COM+ for Developers (Windows based not .NET, will need to supplement)


372538
ADO.NET for Developers Series Parts 1 & 2

 

Exam 70–015 4 : Designing and Implementing Distributed Applications with Microsoft Visual C++® 6.0

Discontinued

Course 1015 : Mastering MFC Developing using Microsoft Visual C++ 6.0 (5 days)

 

Exam 70–019 3,4 : Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0

 

Discontinued

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)

 

Exam 70–155 4 : Designing and Implementing Distributed Applications with Microsoft Visual FoxPro® 6.0

Discontinued

Currently, corresponding Microsoft Official Curriculum is not available .

 

Exam 70–175 4 : Designing and Implementing Distributed Applications with Microsoft Visual Basic® 6.0

Discontinued

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)

 

 

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):

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


4. This exam is scheduled to be discontinued.