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.
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.
To earn this certification, you must pass three exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and two Professional Series exams.
| Course Code | Course Name | Duration |
| 70 – 431 | TS: Microsoft SQL Server 2005 – Implementation and Maintenance | 10 Days |
| 70 – 443 | PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 | 7 Days |
| 70 – 444 | PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 | 5 Days |
Course Outline:-
70-431
- Installing and Configuring SQL Server 2005
- Implementing High Availability and Disaster Recovery
- Supporting Data Consumers Maintaining Databases
- Monitoring and Troubleshooting SQL Server Performance
- Creating and Implementing Database Objects
70-443
- Designing a Database Server Infrastructure
- Designing Security for a Database Server Solution
- Designing a Physical Database
- Designing a Database Solution for High Availability
- Designing a Data Recovery Solution for a Database
- Designing a Strategy for Data Archiving
70-444
- Optimizing the Performance of Database Servers and Databases
- Optimizing and Implementing a Data Recovery Plan for a Database
- Designing a Strategy to Monitor and Maintain a Database Solution
- Designing a Database Data Management Strategy
- Designing a Strategy to Manage and Maintain Database Security
