MCITP Database


Database Administrator 2005

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.

Prerequisite MCTS exam

 

Exam 70-431

Review the preparation guide for Exam 70–431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance

 

Professional Series exams

 

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

Prerequisite MCTS exam for an MCDBA

 

Exam 70-431

Review the preparation guide for Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance

 

Upgrade exam for an MCDBA

 

Exam 70-447

Review the preparation guide for Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005

 

Database Administrator 2008

See the following table for related training resources.

Required exam

Classroom training

Exam 70-432

Course 6231A: Maintaining a Microsoft SQL Server 2008 Database (five Days)

or

Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (three Days)

Exam 70-450

There is no classroom training currently available.

 

Database Developer 2005

Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) certification demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.

Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data by using SQL queries or tune and optimize queries. Database developers are typically employed by medium-sized to large organizations.

How to earn your MCITP: Database Developer

To achieve this certification, you must pass three exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and two Professional Series exams.

This certification will retire when Microsoft discontinues mainstream support for the related technology.

Prerequisite MCTS certification

 

Exam 70-431

Review the preparation guide for Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance

 

Professional Series exams

 

Exam 70-441

Review the preparation guide for Exam 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005

Exam 70-442

Review the preparation guide for Exam 70-442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Database Developer 2008

See the following table for related training resources.

Required exam

Classroom training

Exam 70-433

Course 6232A: Implementing a Microsoft SQL Server 2008 Database (five Days)

or

Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (three Days)

Exam 70-451

There is no classroom training currently available.