Register
Wednesday, January 07, 2009
 

New Horizons CLC of Southern California
Call Us: 1(888) 825-6684
Anaheim  | Burbank  | Los Angeles (Culver City)  | Tri Counties 
   Laguna Hills  |  Santa Barbara   | Riverside  | San Bernardino 

Microsoft SQL Server


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.    

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


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–2152: 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–2162 : 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–5285,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–5266,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–5298: 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

1 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

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.

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:

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

8 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
Copyright 2008 New Horizons CLC of Southern California