Scheda corso MOC6231

Maintaining a Microsoft SQL Server 2008 Database

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Obiettivi

After completing this course, students will be able to:

• Install and configure SQL Server 2008.

• Manage database files.

• Backup and restore databases.

• Manage security.

• Transfer data into and out of SQL Server.

• Automate administrative tasks.

• Replicate data between SQL Server instances.

• Maintain high availability.

• Monitor SQL Server.

Prerequisiti

Contenuti

Module 1: Installing and Configuring SQL Server

• Lesson 1: Preparing to Install SQL Server

• Lesson 2: Installing SQL Server

• Lesson 3: Configuring a SQL Server Installation

Module 2: Managing Databases and Files

• Lesson 1: Planning Databases

• Lesson 2: Creating Databases

• Lesson 3: Using Policy-Based Management

Module 3: Disaster Recovery

• Lesson 1: Planning a Backup Strategy

• Lesson 2: Backing Up User Databases

• Lesson 3: Restoring User Databases

• Lesson 4: Performing Online Restore Operations

• Lesson 5: Recovering Data from Database Snapshots

• Lesson 6: System Databases and Disaster Recovery

Module 4: Managing Security

• Lesson 1: Overview of SQL Server Security

• Lesson 2: Protecting the Server Scope

• Lesson 3: Protecting the Database Scope

• Lesson 4: Protecting the Server Scope

• Lesson 5: Auditing Security

Module 5: Transferring Data

• Lesson 1: Overview of Data Transfer

• Lesson 2: Introduction to SQL Server Integration Services

Module 6: Automating Administrative Tasks

• Lesson 1: Automating Administrative Tasks in SQL Server

• Lesson 2: Using SQL Server Agent

• Lesson 3: Creating Maintenance Plans

• Lesson 4: Implementing Alerts

• Lesson 5: Managing Multiple Servers

• Lesson 6: Managing SQL Server Agent security

Module 7: Implementing Replication

• Lesson 1: Overview of Replication

• Lesson 2: Managing Publications and Subscriptions

• Lesson 3: Configuring Replication in Some Common Scenarios

Module 8: Maintaining High Availability

• Lesson 1: Introduction to High Availability

• Lesson 2: Implementing Log Shipping

• Lesson 3: Implementing Database Mirroring

• Lesson 4: Implementing Server Clustering

• Lesson 5: Using Distributed High Availability Solutions

Module 9: Monitoring SQL Server

• Lesson 1: Viewing Current Activity

• Lesson 2: Using SQL Server Profiler

• Lesson 3: Monitoring with DDL Triggers

• Lesson 4: Using Event Notifications

Module 10: Troubleshooting and Performance Tuning

• Lesson 1: Troubleshooting SQL Server

• Lesson 2: Performance Tuning in SQL Server

• Lesson 3: Using Resource Governor

• Lesson 4: Using Data Collector