OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

MS 2780: Maintaining a Microsoft SQL Server 2005 Database

Duration: 5 Days Instructor-Led

This five-day instructor-led course provides students with the 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.

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

Prerequisites

  • 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

Course Outline
Module 1: Installing and Configuring SQL Server 2005
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Monitoring SQL Server
Module 6: Transferring Data
Module 7: Automating Administrative Tasks
Module 8: Maintaining High Availability
Module 9: Introduction to Replication

Print this page Print this page