70-450 PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008

Overview

This course is designed to validate the cadiadtes skills around the areas of Microsoft Microsoft SQL Server 2008. Candidates will be exposed to all of the examinable topics as well as various methods and tools to help them manage similar systems in a production environment out in the real world.

Course Materials

All delegates are provided with official Microsoft Press release courseware. This includes the complete book on disk as well as many other resources like official technical drafts, white-papers and case studies. All students are furnished with materials like examination pads, pens, highlighters and other necessary stationary. Many other study aids are provided throughout the course ensuring each student a unique learning experience...

Course Duration

5 Days

Certification

Exam: 70-450

Required for: MCITP Database Administrator

Prerequisites

Candidates require an MCITP Server Administrator qualification or equivalent experience.

Course Topics

• Designing a SQL Server Instance and a Database Solution
• Design for CPU, memory, and storage capacity requirements.
• Design SQL Server instances.
• Design physical database and object placement.
• Design a migration, consolidation, and upgrade strategy.
• Designing a Database Server Security Solution (15 percent)
• Design instance authentication
• Design instance-level security configurations
• Design database, schema, and object security paramaters
• Design a security policy and an audit plan
• Design an encryption strategy
• Designing a Database Solution for High Availability
• Design a failover clustering solution
• Design database mirroring
• Design a high-availability solution that is based on replication
• Design a high-availability solution that is based on log shipping
• Select high-availability technologies based on business requirements
• Designing a Backup and Recovery Solution
• Design a backup strategy
• Design a recovery strategy
• Design a recovery test plan
• Designing a Monitoring Strategy
• Design a monitoring solution at the operating system level
• Design a monitoring solution at the instance level
• Design a solution to monitor performance and concurrency
• Designing a Strategy to Maintain and Manage Databases
• Design a maintenance strategy for database servers
• Design a solution to govern resources
• Design policies by using Policy-Based Management
• Design a data compression strategy
• Design a management automation strategy

Related Courses

MCITP Database Administrator