Five Day Course

Course Description

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.

Performance-Based Objectives

Upon successful completion of 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.

 Prerequisites

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

Course Content

Installing and Configuring SQL Server

• Preparing to Install SQL Server
• Installing SQL Server
• Configuring a SQL Server Installation

Managing Databases and Files

• Planning Databases
• Creating Databases
• Using Policy-Based Management

Disaster Recovery

• Planning a Database Backup Strategy
• Backing Up a User Database
• Restoring User Databases
• Performing Online Restore Operations
• Recovering Data from Database Snapshots
• System Databases and Disaster Recovery

Managing Security

• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Managing Keys and Certificates
• Auditing Security

Transferring Data

• Overview of Data Transfer
• Introduction to SQL Server Integration Services

Automating Administrative Tasks

• Automating Administrative Tasks in SQL Server
• Using SQL Server Agent
• Creating Maintenance Plans
• Implementing Alerts
• Managing Multiple Servers
• Managing SQL Server Agent Security

Implementing Replication

• Overview of Replication
• Managing Publications and Subscriptions
• Configuring Replication in Some Common Scenarios

Maintaining High Availability

• Introduction to High Availability
• Implementing Log Shipping
• Implementing Database Mirroring
• Implementing Server Clustering
• Using Distributed High Availability Solutions

Monitoring SQL Server

• Viewing Current Activity
• Using SQL Server Profiler
• Monitoring with DDL Triggers
• Using Event Notifications

Troubleshooting and Performance Tuning

• Troubleshooting SQL Server
• Performance Tuning in SQL Server
• Using Resource Governor
• Using Data Collector

For more information on Acumen Classes
Please contact Deb Wagnon 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it

1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63119