Maintaining a 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.

Who should attend?

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

Delegates will be able to

• Install and configure SQL Server 2008
• Manage database files
• Backup and restore databases
• Managing security
• Transferring data into and out of SQL Server
• Automate administrative tasks
• Replicate data between SQL Server instances
• Maintain high availability
• Monitor SQL Server 

Prerequisites

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL
• Working knowledge of relational databases

Topics covered

Installing and Configuring SQL Server 

• Introduction in planning for an SQL Server installation
• Introduction to installing, configuring, and managing SQL Server

Managing Databases and Files

• Introduction in planning, creating, and using database options to control database behaviour.

Disaster Recovery

• Introduction to disaster recovery techniques for SQL Server
• How to perform different types of backup and restore operations, including online restores and backup and restores of system databases

Managing Security

• Protecting the SQL Server
• How to use SQL Server security features to control access to databases and their contents

Transferring Data

• How to transfer data to and from SQL Server using UI and command-line tools
• Transferring and transforming data with SQL Server Integration Services

Automating Administrative Tasks

• How to automate routine administrative tasks using jobs, operators, and alerts

Implementing Replication

• Introduction to techniques for configuring SQL Server replication

Maintaining High Availability

• Introduction to concepts and methods for maintaining high availability with SQL Server

Monitoring SQL Server

• Introduction to monitoring SQL Server performance and activity

Troubleshooting and Performance Tuning

• How to troubleshoot a variety of common SQL Server problems
• How to tune SQL Server for improved performance using a variety of tools