Become certified on SQL Server 2005.
This Boot Camp provides the opportunity for IT professionals to obtain the Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 certification and the Microsoft Certified IT Professional (MCITP): Database Administrator certification, two of Microsoft's new generation of certifications introduced to better reflect technology and job-role skills. Existing MCDBA (SQL 2000) candidates may also attend this Boot Camp to upgrade their certification. All the exams to become certified are included in the Boot Camp as well as one free retake voucher for each exam if needed.
You Will Take These Exams:
New MCITP Candidates:
All MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 certification (one exam). After earning the MCTS certification, new candidates earn their MCITP: Database Administrator by passing two required exams.
Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance
Exam 70-443: Pro: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Exam 70-444: Pro: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Existing MCDBA (SQL 2000) Candidates:
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 MCITP exams for new candidates. MCDBAs must still obtain the MCTS: SQL Server 2005 certification as a prerequisite.
- Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance
- Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
Should any student fail the initial exam, he or she will be eligible to receive a second exam voucher.
What You'll Learn
- Key topics and concepts covered on the MCITP exams
- Structure of the MCITP exams and the most effective test-taking strategies
- Use Transcender test-preparation software to reinforce learning objectives, validate current knowledge, and review the most comprehensive and realistic exam questions
- Pinpoint your weak areas and strengthen them to ensure success on the MCITP exams
Course Outline
The course will track Microsoft's knowledge domain requirements.
1. Microsoft SQL Server 2005 - Implementation and Maintenance
- 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
2. Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
- 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
3. Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
- Optimizing the Performance of Database Servers and Databases
- Optimizing and Implementing a Data Recovery Plan for Databases
- 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
