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 |
See the following table for related training resources.
|
Required exam |
Classroom training |
|
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) |
|
|
There is no classroom training currently available. |
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 |
See the following table for related training resources.
|
Required exam |
Classroom training |
|
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) |
|
|
There is no classroom training currently available. |