Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444)
- Course Code:
- 70-444
- Duration:
- 2 in-centre days
The “Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005” examination is required alongside the “Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005” examination, in order to achieve MCITP accreditation.
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-size to large organizations.
Prerequisites
MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 certification (one exam). After earning this certification, candidates earn their MCITP: Database Administrator by passing two required exams.
If you are a Microsoft Certified Database Administrator (MCDBA), you may upgrade to the MCITP: Database Administrator certification by taking one upgrade exam instead of the two required exams.
MCDBAs must still obtain the MCTS: SQL Server 2005 certification as a prerequisite.
Learning Objectives
-
70-444
Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
This course will teach you about the following topics:
- Defining high-availability solutions
- Automating administrative tasks
- Defining security solutions
- Monitoring and troubleshooting the database server
- Designing and executing deployments
- Defining the infrastructure (storage, hardware, and number of servers or instances, etc.)
Certifications
You will achieve the following certifications from this programme:
-
MCITP More Exams
MCITP More Exams




