Maintaining a Microsoft SQL Server 2008 Database

• Provides the knowledge and skills to maintain a Microsoft SQL Server 2008 database.
• How to use SQL Server 2008 product features and tools related to maintaining a database.
• 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.

IT Professionals who administer and maintain SQL Server databases.

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

1- Installing and Configuring SQL Server
   • Preparing to Install SQL Server.
   • Installing SQL Server.
   • Configuring a SQL Server Installation.

2- Managing Databases and Files
   • Planning Databases.
   • Creating Databases.
   • Using Policy-Based Management.

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

4- Managing Security
   • Overview of SQL Server Security.
   • Protecting the Server Scope.
   • Protecting the Database Scope.
   • Protecting the Server Scope.
   • Auditing Security.

5- Transferring Data
   • Overview of Data Transfer.
   • Introduction to SQL Server Integration Services.

6- 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.

7- Implementing Replication
   • Overview of Replication.
   • Managing Publications and Subscriptions.
   • Configuring Replication in Some Common Scenarios.

8- Maintaining High Availability
   • Introduction to High Availability.
   • Implementing Log Shipping.
   • Implementing Database Mirroring.
   • Implementing Server Clustering.
   • Using Distributed High Availability Solutions.

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

10- Troubleshooting and Performance Tuning
   • Troubleshooting SQL Server.
   • Performance Tuning in SQL Server.
   • Using Resource Governor.
   • Using Data Collector.