UMBC Training Centers logo

Maintaining a Microsoft SQL Server 2005 Database (Course 2780B)


Course Description | Outline | SQL Server Training | IT Training


This five-day instructor-led course provides students with the knowledge and skills 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. This course is equivalent fo Microsoft course 2780B, and will help students prepare for the Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) Certification.

After completing this course, students will be able to:
• Install and configure SQL Server 2005.
• Manage database files.
• Backup and restore databases.
• Manage security.
• Monitor SQL Server.
• Transfer data into and out of SQL Server.
• Automate administrative tasks.
• Replicate data between SQL Server instances.
• Maintain high availability.

MCTS: SQL Server 2005

Target Student

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


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of SQL.
  • Working knowledge of relational databases.


E-mail or call (443) 692-6599:
  • if you have any questions about this course,
  • to be notified when this course and any closely related courses are scheduled for open enrollment,
  • to request a quote for group training at your location or ours.