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.

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.

1 - 1: Installing and Configuring SQL Server 
The students will be introduced to planning for a SQL Server installation. The students will then be introduced to installing, configuring, and managing SQL Server. Lessons

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

• Installing SQL Server
• Configuring SQL Server

• Explain how to prepare the hardware and other resources necessary to install SQL Server.
• Install SQL Server.
• Manage and configure SQL Server.

• Planning Databases
• Creating Databases
• Using Policy-Based Managemen t

• Creating a Database
• Monitoring and Managing Filegroup Usage
• Creating a Policy

• Plan a database implementation that meets an organization's requirements.
• Create a SQL Server database.
• Manage a SQL Server database.

• 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 Re covery

• Implementing a Backup Strategy
• Restoring and Recovering a Database
• Performing Piecemeal Backup and Restore Operations
• Restoring the Master Database

• Plan a backup strategy for a database.
• Back up user databases.
• Restore user databases from backups.
• Restore data in a user database while it is online.
• Recover data for a user database from a database snapshot.
• Restore and recover system databases.

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

• Creating Logins and Assigning Server-Scope Permissions
• Creating Database Users and Assigning Database-Scope and Schema-Scope Permissions
• Encrypting Data Using Certificates and Keys
• Implementing SQL Server Audit

• Describe how SQL Server manages security.
• Protect SQL Server at the server level.
• Protect SQL Server databases.
• Use keys and certificates to protect SQL Server objects.
• Audit SQL Server security.

• Overview of Data Transfer
• Introduction to SQL Server Integration S ervices

• Using the Import/Export Wizard
• Performing a Bulk Load
• Creating an SSIS Solution

• Use UI and command-line tools to import and export data.
• Describe the features of SQL Server Integration Services.

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

• Configuring SQL Server Agent
• Creating Operators and Jobs
• Creating Alerts

• Define SQL Server administrative tasks and schedule those tasks to run automatically.
• Configure SQL Server Agent to support automatic task scheduling.
• Script tasks by using SQL Server jobs, and define operators for managing those jobs.
• Define alerts to warn operators about events raised by SQL Server.
• Define and manage administrative tasks that span multiple servers.
• Configure SQL Server Agent security.

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

• Implementing Snapshot Replication
• Implementing Peer-to-Peer Transactional Replication
• Implementing HTTP Merge Replication

• Describe replication and its components.
• Configure and implement replication.
• Use replication to meet the requirements of some common scenarios.

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

• Configuring Log Shipping
• Configuring Database Mirroring

• Describe the factors affecting database availability.
• Describe how to implement log shipping to support fast recovery of a standby SQL Server database.
• Describe how to use SQL Server mirroring to implement a software solution for fast failover.
• Explain how to implement clustering to support fast failover of computers running SQL Server instances.
• Describe how to implement distributed high availability solutions.

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

• Monitoring SQL Server Activity
• Tracing SQL Server Activity
• Using DDL Triggers
• Using Event Notifications

• Examine the current activity in a SQL Server instance.
• Use SQL Server Profiler to trace server and database activity.
• Use DDL triggers to monitor changes to the structure of database objects.
• Use event notifications to capture and monitor significant events for a SQL Server instance.

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

• Troubleshooting Connectivity Problems
• Troubleshooting Concurrency Problems
• Using the Database Engine Tuning Advisor
• Implementing Resource Governor
• Implementing Data Collector

• Troubleshoot common SQL Server problems, such as connectivity, concurrency, and job and disk space problems.
• Perform basic performance tuning tasks in SQL Server using the Database Engine Tuning Advisor, index tuning, and query tuning.
• Use Resource Governor to manage SQL Server workloads and resources.
• Use Data Collector to obtain performance data about your computer and the instances of SQL Server running on your computer.