Wednesday, September 08, 2010

You are here : Courses » Courses By Certification » Microsoft » Microsoft SQL Server » MCDBA Database Administrator

Microsoft SQL Server

MCTS SQL Server 2005

MCTS SQL Server 2005 Business Intelligence

MCITP Database Developer

MCITP Database Administrator

MCITP Business Intelligence Developer

MCDBA Microsoft Certified Database Administrator

Microsoft Certified Database Administrator (MCDBA)

Overview

The Microsoft® Certified Database Administrator (MCDBA) credential is the premier certification for professionals who implement and administer Microsoft SQL Server™ databases. By becoming a certified MCDBA, you demonstrate the skills necessary to lead organizations in the successful design, implementation, and administration of SQL Server databases.

Who's It For?

The certification is geared toward database administrators, analysts and developers who create physical database designs, develop logical data models, create physical databases, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.

Prerequisites

MCDBA candidates should have at least one year of experience working with SQL Server.

Path To Certification

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

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

Core exams (three exams required)

Core Exams: SQL Server Administration

Core Exams: SQL Server Administration (One Exam Required)

Related Courses

Search Dates

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)

Dates

Dates

Core Exams: SQL Server Design

Core Exams: SQL Server Design (One Exam Required)

Related Courses

Search Dates

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)

Dates

Dates

Core Exams: Networking Systems

Core Exams: Networking Systems (One Exam Required)	Related Courses	Search Dates
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)	Dates Dates Dates
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)	Dates Dates
Exam 70–215²: 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)	Dates Dates

Elective Exams

Elective Exams: (One Exam Required)	Related Courses	Search Dates
Exam 70–216² : Implementing and Administering a Microsoft Windows 2000 Network Infrastructure	Course 2153: Implementing a Microsoft Windows 2000 Network Infrastructure (five days)	Dates
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)	Dates
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)	Dates Dates Dates Dates
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)	Dates Dates Dates Dates
Exam 70–529⁸: 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)	Dates Dates
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)	Dates Dates Dates
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)	Dates Dates Dates
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)	Dates Dates Dates
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)	Dates Dates Dates
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)	Dates Dates Dates
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)	Dates Dates Dates

¹ Candidates who passed both Windows NT 4.0 Exams 70–067 and 70–068 fulfilled the networking system core exam requirement.

•	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

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

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

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

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

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

•	Exam 70-526: TS: Microsoft .NET Framework 2.0 - Windows-based Client Development
•	Exam 70-528: TS: Microsoft .NET Framework 2.0 - Web-based Client Development

⁸ Candidates who have obtained Microsoft Certified Solutions Developer (MCSD) certification may substitute Exam 70-554: UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 2 for Exam 70-529: TS: Microsoft .NET Framework 2.0 – Distributed Application Development.

Privacy Statement | Terms Of Use

New Horizons

Northern New England

603-882-4900

Stay Connected

Search for a Class

Microsoft Certified Database Administrator (MCDBA)

Overview

Who's It For?

Prerequisites

Core exams (three exams required)

Elective exams (one exam required)

Core exams (three exams required)

Core Exams: SQL Server Administration

Core Exams: SQL Server Design

Core Exams: Networking Systems

Elective Exams