SQL 2005 Certifcation Path

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.

Core Exams (3 Exams Required)

Core Exams: SQL Server Administration (1 Exam Required)

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

in order to pass this exam you will need the following:

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

Core Exams: SQL Server Design (1 Exam Required)

Exam 70–229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

in order to pass this exam you will need the following:

Course 2073: Programming a Microsoft SQL Server 2000 Database (5 days)

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

Core Exams: Networking Systems (1 Exam Required)

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)

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)

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

Exam 70-294: Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure

in order to pass this exam you will need the following:

Course 2279: Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure (5 days)

Elective Exam (1 Exam Required)

Exam 70–086: Implementing and Supporting Microsoft Systems Management Server 2.0

in order to pass this exam you will need the following:

Course 828: Deploying and Supporting Microsoft Systems Management Server 2.0 (5 days)

Course 827: Administering Microsoft Systems Management Server 2.0 (3 days)

Exam 70-227: Installing, Configuring, and Administering Microsoft Internet Security and Acceleration (ISA) Server 2000, Enterprise Edition

in order to pass this exam you will need the following:

Course 2159: Deploying and Managing Microsoft Internet Security and Acceleration Server 2000 (3 days)

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

in order to pass this exam you will need the following:

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

Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

in order to pass this exam you will need the following:

Course 2073: Programming a Microsoft SQL Server 2000 Database (5 days)

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

Exam 70-232: Implementing and Maintaining Highly Available Web Solutions with Microsoft Windows 2000 Server Technologies and Microsoft Application Center 2000

in order to pass this exam you will need the following:

Course 2203: Deploying and Managing Microsoft Application Center 2000 (2 days)

Exam 70-281: Planning, Deploying, and Managing an Enterprise Project Management Solution

in order to pass this exam you will need the following:

Course 2732: Planning, Deploying, and Managing an Enterprise Project Management Solution (5 days)

Exam 70-282: Designing, Deploying, and Managing a Network Solution for a Small- and Medium-Sized Business

in order to pass this exam you will need the following:

Course 2395: Designing, Deploying, and Managing a Network Solution for the Small and Medium-Sized Business

Exam 70-284: Implementing and Managing Microsoft Exchange Server 2003

in order to pass this exam you will need the following:

Course 2400: Implementing and Managing Microsoft Exchange Server 2003

Exam 70-285: Designing a Microsoft Exchange Server 2003 Organization

in order to pass this exam you will need the following:

Course 2008: Designing a Microsoft Exchange Server 2003 Organization (2 days)

Exam 70-297: Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure

in order to pass this exam you will need the following:

Course 2282: Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure (5 days)

Exam 70-298: Designing Security for a Microsoft Windows Server 2003 Network

in order to pass this exam you will need the following:

Course 2830: Designing Security for Microsoft Networks (3 days)

Exam 70-299: Implementing and Administering Security in a Microsoft Windows Server 2003 Network

in order to pass this exam you will need the following:

Course 2823: Implementing and Administering Security in a Microsoft Windows Server 2003 Network

MCTS: SQL Server 2005 Certification Requirements

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.

Microsoft Skills Assessments for SQL Server 2005 help database administrators, database developers, and business intelligence developers focus their exam preparation training and find learning resources.

How to earn your MCTS: SQL Server 2005

MCTS candidates must pass one exam that focuses on the implementation and maintenance of SQL Server 2005. The following table lists Official Microsoft Learning Products and Microsoft Press books that are designed to help you prepare for the required exams. See the individual exam preparation guides for exam availability.

MCTS: SQL Server 2005 Business Intelligence

The Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI) implement and maintain business intelligence solutions. They have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite. They have knowledge of database schemas and of debugging, monitoring, and troubleshooting Business Intelligence solutions, and they know how to work with Microsoft .NET Framework. They can write database queries, use SQL Server Analysis Services (SSAS) data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages. Typically, Technology Specialists pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.

Microsoft skills assessments for SQL Server 2005 help business intelligence developers focus their exam preparation training and find learning resources.