203-220-2218
skip to the main content area of this page
Training: Course Outline

2008 Training Schedules

To register call:
1-203-220-2218

Course 2780: Maintaining a Microsoft SQL Server 2005 Database

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

Audience

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

At Course Completion

After completing the 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
  • Recommended: Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
  • Recommended: Course 2779: Implementing a Microsoft SQL Server 2005 Database

Course Contents
  • Module 1: Installing and Configuring SQL Server 2005
    • Preparing to install SQL Server
    • Installing SQL Server
    • Managing a SQL Server 2005 Installation
  • Module 2: Managing Databases and Files
    • Planning databases
    • Creating databases
    • Managing databases
  • Module 3: Disaster Recovery
    • 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
    • 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
    • Viewing Current Activity
    • Using System Monitor
    • Using SQL Server Profiler
    • Using DDL Triggers
    • Using Event Notifications
  • Module 6: Transferring Data
    • Overview of Data Transfer
    • Introduction to SQL Server Integration Services
    • Using SQL Server Integration Services
  • Module 7: Automating 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
    • Introduction to High Availability
    • Implementing Server Clustering
    • Implementing Database Mirroring
    • Implementing Log Shipping
  • Module 9: Introduction to Replication
    • Overview of Replication
    • Replication Scenarios

Student Responsibilities
In order for a class to be successful, all students should share the same general level of knowledge and experience. If a participant does not demonstrate these, the instructor will take the necessary steps either to prepare the participant or place him/her in a more appropriate course. This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule