Maintaining a Microsoft SQL Server 2005 Database

Course 2780: 3 Days; Instructor-led

Introduction

This three-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Audience

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

At Course Completion

After completing this course, students will be able to:

• Install and configure SQL Server 2005.

• Manage database files.

• Manage security.

• Perform administrative tasks.

• Back up databases.

• Restore databases.

• Monitor SQL Server.

• Troubleshoot SQL Server.

• Transfer data.

• Maintain high availability.

Prerequisite

Before attending this course, students must:

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

In addition, it is recommended, but not required, that students have completed:

• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.

• Course 2779: Implementing a Microsoft SQL Server 2005 Database.