Maintaining a Microsoft SQL Server 2005 Database

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.

 

Class Agenda:

  • Module 1: Installing and Configuring SQL Server 2005

    This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.

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

    Module 2: Managing Databases and Files

    This module explains how to manage databases and files.

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

    Module 3: Disaster Recovery

    This module explains how to plan and implement a backup and restore strategy.

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

    Module 4: Managing Security

    This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

    • Overview of SQL Server Security.
    • Securing the Server Scope.
    • Securing the Database Scope.
    • Managing Keys and Certificates in SQL Server.

    Module 5: Monitoring SQL Server

    This module explains how to monitor SQL Server performance and activity.

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

    Module 6: Transferring Data

    This module explains how to transfer and transform data.

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

    Module 7: Automating Administrative Tasks

    This module explains how to use the SQL Server Agent to automate administrative tasks.

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

    Module 8: Maintaining High Availability

    This module explains how to implement high availability technologies with SQL Server 2005.

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

    Module 9: Introduction to Replication

    This module explains considerations for implementing replication.

    • Overview of Replication.
    • Replication Scenarios.

Audience:

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

Materials Furnished:

  • Student Manual

Course Length: Three Days

List Price: $1495