THE Information Solution Provider P.O Box : 705 Westville 3630
Tel : (031) 266 8130
Fax : (031) 266 9610
Email: info@acbsa.co.za
Microsoft® Certifications End User Technical Programming Database
Booking Form
Services Queries
Services Support Pricing Queries Web Mail - Netsolution Web Mail - TC
Specials
Vista Versions Windows Media Center Thin Client VOIP
Contact Us
Subscribe Unsubscribe

Skip Navigation LinksACB South Africa > Certifications > MCDBA

Microsoft Accreditations: Advanced Infrastructure Solutions(amongst others) Our Microsoft accreditations: Microsoft Certified Learning Solution Provider(amongst others)


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 Microsoft SQL Server databases.

MCDBAs on Microsoft SQL Server 2000 are not required to pass Microsoft Windows Server 2003 exams to retain MCDBA certification. The Microsoft Windows 2000 Server exams and the Windows Server 2003 exams for the MCDBA on SQL Server 2000 certification remain available concurrently.

NEW Candidates using Microsoft SQL Server 2005 should consider the new Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) credentials. They provide IT professionals who administer, develop, or analyze Microsoft SQL Server 2005 databases with a simpler and more targeted framework to showcase their technical skills and their ability to create database solutions for business problems.

Core exams (three 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 (one 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

 

How to Earn Your MCSE: Messaging on Microsoft Windows 2000

The following tables list official Microsoft Learning Courses and Microsoft Press books that are designed to help MCDBA candidates prepare for the required exams. See individual Exam Preparation Guides for exam availability.

 


Core exams (three exams required)
Core Exams: SQL Server Administration (One Exam Required) Classroom Training Microsoft E–Learning Microsoft Press Books

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

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

(Prerequisite) Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)

There are no E-Learning courses currently available.

MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, Second Edition

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

There are no Official Microsoft Learning Products currently available.

There are no E-Learning courses currently available.

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 (One Exam Required) Classroom Training Microsoft E–Learning Microsoft Press Books

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)

(Prerequisite) Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)

There are no E-Learning courses currently available.

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition

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

There are no Official Microsoft Learning Products currently available.

There are no E-Learning courses currently available.

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 Systems (One Exam Required) Classroom Training Microsoft E–Learning Microsoft Press Books

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

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

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

or

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

Course 2274: Managing a Microsoft Windows Server 2003 Environment (21 hours)

Course 2275: Maintaining a Microsoft Windows Server 2003 Environment (17 hours)

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

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)

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

or

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

Course 2276: Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts (10 hours)

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

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–215 2: Installing, Configuring, and Administering Microsoft Windows 2000 Server

Course 2151: Microsoft Windows 2000 Network and Operating System Essentials (three days)

Course 2152: Implementing Microsoft Windows 2000 Professional and Server (five days)

or

Course 1560: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows 2000 (five days)

There are no E-Learning courses currently available.

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
Elective Exams: (One Exam Required) Classroom Training Microsoft E–Learning Microsoft Press Books

Exam 70–216 2 : Implementing and Administering a Microsoft Windows 2000 Network Infrastructure

Course 2153: Implementing a Microsoft Windows 2000 Network Infrastructure (five days)

Course 1560: Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows 2000 (five days)

There are no E-Learning courses currently available.

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)

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)

Course 2278: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure (22 hours)

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–528 5,7: TS: Microsoft .NET Framework 2.0 — Web–Based Client Development

Workshop 2543: Core Web Application Development with Visual Studio 2005 (three days)

Workshop 2544: Advanced Web Application Development with Visual Studio 2005 (two days)

Workshop 2541: Core Data Access Development with Visual Studio 2005 (three days)

Workshop 2542: Advanced Data Access Development with Visual Studio 2005 (two days)

Collection 2543: Core Web Application Development with Visual Studio 2005 (18 hour series)

Collection 2544: Advanced Web Application Development with Visual Studio 2005 (12 hour series)

Collection 2541: Core Data Access Development with Visual Studio 2005 (18 hour series)

Collection 2542: Advanced Data Access Development with Visual Studio 2005 (12 hour series)

MCTS/MCPD Self-Paced Training Kit (Exams 70-528 and 70-547): Developing Web Applications (available late 2006)

Programming Microsoft Visual C# 2005: The Language

Programming Microsoft Visual Basic 2005: The Language

Programming Microsoft ADO.NET 2.0 Core Reference

Programming Microsoft ASP.NET 2.0 Core Reference

NEW: Exam 70–526 6,7: TS: Microsoft .NET Framework 2.0 — Windows–Based Client Development

Workshop 2546: Core Windows Application Development with Visual Studio 2005 (three days)

Workshop 2547: Advanced Windows Application Development with Visual Studio 2005 (two days)

Workshop 2541: Core Data Access Development with Visual Studio 2005 (three days)

Workshop 2542: Advanced Data Access Development with Visual Studio 2005 (two days)

Collection 2546: Core Windows Application Development with Visual Studio 2005 (18 hour series)

Collection 2547: Advanced Windows Application Development with Visual Studio 2005 (12 hour series)

Collection 2541: Core Data Access Development with Visual Studio 2005 (18 hour series)

Collection 2542: Advanced Data Access Development with Visual Studio 2005 (12 hour series)

MCTS/MCPD Self-Paced Training Kit (Exams 70-526 and 70-548): Developing Windows-Based Applications (available late 2006)

Programming Microsoft Visual C# 2005: The Language

Programming Microsoft Visual Basic 2005: The Language

Programming Microsoft ADO.NET 2.0 Core Reference

NEW: Exam 70–529 8: TS: Microsoft .NET Framework 2.0 — Distributed Application Development

Workshop 2548: Core Distributed Application Development with Visual Studio 2005 (three days)

Workshop 2549: Advanced Distributed Application Development with Visual Studio 2005 (three days)

Collection 2548: Core Distributed Application Development with Visual Studio 2005 (18 hour series)

Collection 2549: Advanced Distributed Application Development with Visual Studio 2005 (12 hour series)

MCTS/MCPD Self-Paced Training Kit (Exams 70-529 and 70-549): Distributed Application Development/Developing Enterprise Applications (available late 2006)

Programming Microsoft Visual C# 2005: The Language

Programming Microsoft Visual Basic 2005: The Language

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 (five days)

Course 2373: Programming with Microsoft Visual Basic .NET (five days)

Course 2389: Programming ADO.NET (three days)

Course 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (17 hours)

Course 2640: Upgrading Web Development Skills from ASP to Microsoft ASP.NET (14 hours)

Course 2389: Programming with Microsoft ADO.NET (18 hours)

Microsoft ADO.NET Step by Step

MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition

MCAD/MCSD Self-Paced Training Kit: Microsoft .NET Core Requirements, Exams 70-305/70-315, 70-306/70-316, 70-310/70-320, and 70-300

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) (five days)

Course 2373: Programming with Microsoft Visual Basic .NET (five days)

Course 2389: Programming with Microsoft ADO.NET (three days)

Course 2565: Developing Microsoft .NET Applications for Windows (Visual Basic .NET) (13 hours)

Course 2389: Programming with Microsoft ADO.NET (18 hours)

MCAD/MCSD Self-Paced Training Kit: Developing Windows-Based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition

MCAD/MCSD Self-Paced Training Kit: Microsoft .NET Core Requirements, Exams 70-305/70-315, 70-306/70-316, 70-310/70-320, and 70-300

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 (three days)

Course 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services (five days)

Course 2389: Programming with Microsoft ADO.NET (three days)

Course 2524: Developing XML Web Services Using Microsoft ASP.NET (12 hours)

Course 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services (22 hours)

Course 2389: Programming with Microsoft ADO.NET (18 hours)

MCAD/MCSD Self-Paced Training Kit: Developing Windows-Based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition

MCAD/MCSD Self-Paced Training Kit: Microsoft .NET Core Requirements, Exams 70-305/70-315, 70-306/70-316, 70-310/70-320, and 70-300

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 (five days)

Course 2124: Programming with C# (five days)

Course 2389: Programming with Microsoft ADO.NET (three days)

Course 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET (17 hours)

Course 2640: Upgrading Web Development Skills from ASP to Microsoft ASP.NET (14 hours)

Course 2389: Programming with Microsoft ADO.NET (18 hours)

Microsoft ADO.NET Step by Step

MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition

MCAD/MCSD Self-Paced Training Kit: Microsoft .NET Core Requirements, Exams 70-305/70-315, 70-306/70-316, 70-310/70-320, and 70-300

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) (five days)

Course 2124: Programming with C# (five days)

Course 2389: Programming with Microsoft ADO.NET (three days)

Course 2555: Developing Microsoft .NET Applications for Windows (Visual C# .NET) (14 hours)

Course 2389: Programming with Microsoft ADO.NET (18 hours)

Microsoft ADO.NET Step by Step

MCAD/MCSD Self-Paced Training Kit: Developing Windows-Based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition

MCAD/MCSD Self-Paced Training Kit: Microsoft .NET Core Requirements, Exams 70-305/70-315, 70-306/70-316, 70-310/70-320, and 70-300

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 (three days)

Course 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services (five days)

Course 2389: Programming with Microsoft ADO.NET (three days)

Course 2524: Developing XML Web Services Using Microsoft ASP.NET (12 hours)

Course 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services (22 hours)

Course 2389: Programming with Microsoft ADO.NET (18 hours)

MCAD/MCSD Self-Paced Training Kit: Developing Windows-Based Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition

MCAD/MCSD Self-Paced Training Kit: Microsoft .NET Core Requirements, Exams 70-305/70-315, 70-306/70-316, 70-310/70-320, and 70-300

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

                

                

                

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

                

                

                

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

                

                

                

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

                

                

                


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
  • Exam 70–068: Implementing and Supporting Microsoft Windows NT Server 4.0 in the Enterprise

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 has been discontinued. For more information about discontinued exams, see the Discontinuation of Exams Notice for more details.

5 Candidates who have obtained Microsoft Certified Application Developer (MCAD) certification may substitute Exam 70-551: UPGRADE: MCAD Skills to MCPD Web Developer by Using the Microsoft .NET Framework for Exam 70-528: TS: Microsoft .NET Framework 2.0 - Web-based Client Development.

6 Candidates who have obtained Microsoft Certified Application Developer (MCAD) certification may substitute Exam 70-552: UPGRADE: MCAD Skills to MCPD Windows Developer by Using the Microsoft .NET Framework for Exam 70-526: TS: Microsoft .NET Framework 2.0 – Windows-based Client Development.

7 Candidates who have obtained Microsoft Certified Solutions Developer (MCSD) certification may substitute Exam 70-553: UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 1 for either of the following:




Email the webmaster with questions or comments about this web site
Terms and Conditions
Copyright © 2006 A.C.B South Africa