Implementing and Maintaining Microsoft SQL Server 2008 R2 - Live Learning and Expert Encore

Implementing and Maintaining Microsoft SQL Server 2008 R2 Expert Live with Encore

Overview

Implementing and Maintaining Microsoft SQL Server 2008 R2 teaches professionals to accomplish technical tasks such as installing, configuring, maintaining, and optimizing SQL Server instances. Securing data using transparent data encryption, managing data resource usage with the resource governor and standardizing data with policies are a few of relatively new features that are covered in this class. Master data services, utility control points and deploying data-tier application packages are new to SQL Server 2008 R2 and are also taught in this class.

Target Audience

This course is recommended for individuals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles.

Expected Duration

45 hours

Prerequisites

Candidates for the exam should have one to two years of experience using SQL Server 2008 or R2. Students who are not taking the exam but are interested in learning about SQL Server 2008 R2 should have previous experience in database environments. These environments can be driven by any vendor's database solution.

Objectives

• Install, configure and maintain SQL Server instances
• Secure and maintain data
• Import, export and compress data
• Monitor, troubleshoot and optimize databases
• Implement highly available data solutions

Outline

• Module 1: Installing and Configuring SQL Server 2008 R2
• Module 2: Maintaining SQL Server Databases
• Module 3: Data Recovery in SQL Server 2008 R2
• Module 4: Security
• Module 5: Maintaining SQL Server Instances
• Module 6: Data Management Tasks
• Module 7: Monitoring Performance, Troubleshooting, and Optimizing SQL Server
• Module 8: SQL Server 2008 R2 Replication
• Module 9: Maintaining High Availability