MCITP Database Administrator
- Course Code:
- MCITP
- Duration:
- 600 hours & 4 in-centre days
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.
Prerequisites
MCITP candidates must first complete 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
You must take the following core exams:
-
70-443
Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
You will gain an understanding of 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.)
-
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.)
Related Courses
System Requirements
- 512MB RAM (1GB recommended)
- 8 GB available hard drive space
- 1024 x 768 resolution and 16 bit display
- CD/ DVD drive (DVD drive recommended)
- Microsoft Internet Explorer 6 Web browser
- Broadband Internet connection
- 600MHz Pentium III processor
- (1 GHz or faster recommended)
- Recommended Operating Systems:
- Microsoft Windows 2000 Professional or
- Server with Service Pack 4/
- Windows XP Professional with Service Pack 2/
- Windows Server 2003 Standard with Service Pack 1/
- Windows Server 2003 Enterprise with Service Pack 1/
- Windows Server 2003 Datacentre Edition with Service Pack 1
