Course code: MOC 2780« Back

Maintaining a Microsoft SQL Server 2005 Database

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

This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department ( or business department (

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 26 950 CZK included in course price 50
Brno5 26 950 CZK included in course price 50
Bratislava5 675,00 EUR 268,00 EUR 50

Who is the course for

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

What we teach you

  • 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

    Required skills

  • 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

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    The student kit includes a comprehensive workbook.

    Course Outline

    Installing and Configuring SQL Server 2005

    • Preparing to install SQL Server.
    • Installing SQL Server.
    • Managing a SQL Server 2005 Installation.

    Managing Databases and Files

    • Planning databases.
    • Creating databases.
    • Managing databases.

    Managing Security

    • Overview of SQL Server Security.
    • Securing the Server Scope.
    • Securing the Database Scope.
    • Implementing Cryptography in SQL Server.

    Disaster Recovery

    • Planning a Backup Strategy.
    • Backing Up User Databases.
    • Restoring User Databases.
    • Recovering Data from Database Snapshots.
    • System Database and Disaster Recovery.

    Monitoring SQL Server

    • Viewing Current Activity.
    • Using System Monitor.
    • Using SQL Server Profiler.
    • Using DDL Triggers.
    • Using Event Notifications.

    Transferring Data

    • Overview of Data Transfer.
    • Introduction to SQL Server Integration Services (SSIS).
    • Using SQL Server Integration Services.

    Automating Administrative Tasks

    • Automating Administrative Tasks in SQL Server 2005.
    • Configuring the SQL Server Agent.
    • Creating Jobs and Operators.
    • Create Alerts.
    • Managing Multiple Servers.
    • Managing SQL Server Agent Security.

    Maintaining High Availability

    • Introduction to High Availability.
    • Implementing Server Clustering.
    • Implementing Database Mirroring.
    • Implementing Log Shipping.

    Introduction to Replication

    • Overview of Replication.
    • Creating a Publication.
    • Creating A Subscription

    Previous courses

    no preceding courses

    Next courses

    no following course
    Tištěná příručka MOC 2780a

    6950 CZK
    Tištěná příručka MOC 2780a

    268 EUR
    The prices are without VAT.