Knowledge United

Introduction:

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.

This course incorporates material from the following Official Microsoft Learning Product (OMLP):

• Course 2780: Maintaining a Microsoft SQL Server 2005 Database

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

Audience:

• Professional database administrators who optimize and maintain database solutions, typically in an enterprise or a medium-sized organization.

At Course Completion:

After completing this course, students will be able to:

• 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

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

Prerequisites:

• Three or more years dedicated to database work, which may include two or more of the following phases in the product life cycle: design, development, deployment, optimization, maintenance, or support.
• Experience using Microsoft SQL Server 2005

Microsoft Certified Professional Exams

This course will help the student prepare for the following Microsoft Certified Professional exams:

• No MCP exam currently exists for this course.

Student Materials:

The course materials are yours to keep. The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline:

• 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

• 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

• 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