MCITP: Database Administrator
They must have strong knowledge of data archiving, consolidation, distribution and recovery techniques. Administrators must understand the importance of capacity analysis and be able to focus on its design. It is their responsibility to design security measures for database systems using Microsoft SQL Server.
|
Exam |
Courses |
Duration |
|
Exam 70-431 |
Course 2780B: Maintaining a Microsoft SQL Server 2005 Database (five days) |
40 hrs |
|
Course 2779B: Implementing a Microsoft SQL Server 2005 Database (five days) |
40 hrs |
|
|
Exam 70-443 |
Course 2786: Designing a Microsoft SQL Server 2005 Infrastructure (two days) |
16 hrs |
|
Course 2787: Designing Security for Microsoft SQL Server 2005 (two days) |
16 hrs |
|
|
Course 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (three days) |
24 hrs |
|
|
Exam 70-444 |
Course 2787: Designing Security for Microsoft SQL Server 2005 (two days) |
16 hrs |
|
Course 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers (one day) |
8 hrs |
|
|
Course 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days) |
16 hrs |
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 |
Courses |
Duration |
|
Exam 70-431 |
Course 2780B: Maintaining a Microsoft SQL Server 2005 Database (five days) |
40 hrs |
|
Course 2779B: Implementing a Microsoft SQL Server 2005 Database (five days) |
40 hrs |
|
|
Exam 70-447 |
Course 2786: Designing a Microsoft SQL Server 2005 Infrastructure (two days) |
16 hrs |
|
Course 2787: Designing Security for Microsoft SQL Server 2005 (two days) |
16 hrs |
|
|
Course 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (three days) |
24 hrs |
|
|
Course 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers (one day) |
8 hrs |
|
|
Course 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days) |
16 hrs |
To earn the MCITP: Server Administrator certification, you must pass three exams: two Microsoft Certified Technology Specialist (MCTS) exams and one Professional Series exam