Maintaining A Microsoft SQL Server 2008 Database

Course details

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

At Course Completion

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.

Course Outline

• Module 1: Installing and Configuring SQL Server
• Module 2: Managing Databases and Files
• Module 3: Disaster Recovery
• Module 4: Managing Security
• Module 5: Transferring Data
• Module 6: Automating Administrative Tasks
• Module 7: Implementing Replication
• Module 8: Maintaining High Availability
• Module 9: Monitoring SQL Server
• Module 10: Troubleshooting and Performance Tuning