You are in Training / Microsoft / SQL Server / Course MS2780
 

MS2780 Maintaining a Microsoft SQL Server 2005 Database Training and Courseware
To view the course outline click here.
This five-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.
What you will learn
After completing this course, students will be able to:
  • Install and configure SQL Server 2005
  • Manage database files.
  • Manage security.
  • Perform administrative tasks.
  • Backup databases.
  • Restore databases.
  • Monitor SQL Server.
  • Troubleshoot SQL Server.
  • Transfer data.
  • Maintain high availability.
Prerequisites
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.
In addition, it is recommended, but not required, that students have completed:
  • Course 2778, Writing Queries Using Microsoft SQL Server Transact-SQL.
  • Course 2779, Implementing a Microsoft SQL Server 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.
Duration
Five days; Instructor-led