|
获得MCDBA认证的途径
Exam retirements: Many of the exams in this certification track retire in March 2009. You must successfully fulfill all listed requirements to complete the credential. The credential will not expire.
Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 candidates need to pass three core exams and one elective exam. These exams 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 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. (See the tables that follow for a complete list of exams and related training resources.)
Candidates who administer, develop, or analyze Microsoft SQL Server 2005 databases should consider the Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) credentials. These credentials give IT professionals a simpler and more targeted framework to display their technical skills and their ability to create database solutions for business problems.
How to earn your MCDBA
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
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: SQL Server Administration
|
Exam 70-2289: 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 is no Microsoft E-Learning training currently available.
|
MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, Second Edition
|
|
Exam 70-0283,4: Administering Microsoft SQL Server 7.0
|
There is no classroom training currently available.
|
There is no Microsoft E-Learning training 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
|
Exam 70-2299: 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 is no Microsoft E-Learning training currently available.
|
MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition
|
|
Exam 70-0293,4: Designing and Implementing Databases with Microsoft SQL Server 7.0
|
There is no classroom training currently available.
|
There is no Microsoft E-Learning training 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
|
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-2152,10: 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 is no Microsoft E-Learning training 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
|
Exam 70-2162,10: 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 is no Microsoft E-Learning training 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-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)
|
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 Self-Paced Training Kit (Exam 70-528): Microsoft .NET Framework 2.0 Web-Based Client Development
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
|
|
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)
|
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 Self-Paced Training Kit (Exam 70-526): Microsoft .NET Framework 2.0 Windows-Based Client Development
MCPD Self-Paced Training Kit (Exams 70-536, 70-526, 70-548): Microsoft .NET Framework Windows Developer Core Requirements
Programming Microsoft Visual C# 2005: The Language
Programming Microsoft Visual Basic 2005: The Language
Programming Microsoft ADO.NET 2.0 Core Reference
|
|
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)
|
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 Self-Paced Training Kit (Exam 70-529): Microsoft .NET Framework 2.0 Distributed Application Development
Programming Microsoft Visual C# 2005: The Language
Programming Microsoft Visual Basic 2005: The Language
|
|
Exam 70-3059: 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-3069: 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-3109: 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-3159: 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-3169: 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-3209: 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
|
|
Exam 70-0154: Designing and Implementing Distributed Applications with Microsoft Visual C++ 6.0
|
There is no classroom training currently available.
|
There is no Microsoft E-Learning training currently available.
|
There are no Microsoft Press books currently available.
|
|
Exam 70-0193,4: Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0
|
There is no classroom training currently available.
|
There is no Microsoft E-Learning training currently available.
|
There are no Microsoft Press books currently available.
|
|
Exam 70-1554: Designing and Implementing Distributed Applications with Microsoft Visual FoxPro 6.0
|
There is no classroom training currently available.
|
There is no Microsoft E-Learning training currently available.
|
There are no Microsoft Press books currently available.
|
|
Exam 70-1754: Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0
|
There is no classroom training currently available.
|
There is no Microsoft E-Learning training currently available.
|
There are no Microsoft Press books currently available.
|
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.
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. Please see the Windows Server 2003 Exam FAQ for more details.
4 This exam retired in June 2004.
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:
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.
9 This exam retires in March 2009.
10 This exam retired in March 2008.
从 MCDBA 认证升级成为 MCITP: Database Administrator认证
Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week.
Candidate profile
Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-sized to large organizations.
How to earn your MCITP: Database Administrator
To earn this certification, you must pass three exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and two Professional Series exams.
There is an upgrade path of only two exams for a Microsoft Certified Database Administrator (MCDBA).
This certification will retire when Microsoft discontinues mainstream support for the related technology.
|
Exam 70-431
|
Review the preparation guide for Exam 70–431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance
|
|
Exam 70-443
|
Review the preparation guide for Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
|
|
Exam 70-444
|
Review the preparation guide for Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
|
Upgrade path for an MCDBA
If you are an MCDBA, because of your existing expertise you can upgrade to this certification with a shorter path, as shown in the following table.
|
Exam 70-431
|
Review the preparation guide for Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance
|
|
Exam 70-447
|
Review the preparation guide for Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
|
(责任编辑：admin) |
