About this Course

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. 

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 

TARGET AUDIENCE

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

PRE-REQUISITE

Before attending this course, students must have:

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

5 days

Rate this course:

Log in to submit

Comments