SQL Server 2000 - Administering a Database

Duration: 35 hours

Description: Students learn to install, configure, and support Microsoft SQL Server databases. Topics include: Planning the SQL Server installation; managing database files and security; performing administrative tasks; backing up and restoring; monitoring for performance; transferring data; introduction to replication and maintaining high availability. Prerequisite: Querying SQL Server 2000 with Transact-SQL or equivalent knowledge.

Objective: Students learn to install, configure, and support Microsoft SQL Server databases.

Course Content:

SQL Server Overview

Planning to Install SQL Server

Managing Database Files

Managing Security

Managing Permissions

Performing Administrative Tasks

Configuring SQL Server

Creating Jobs and Operators

Creating Alerts

Backing Up Databases

Restoring Databases

Monitoring SQL Server for Performance

Transferring Data

Maintaining High-Availability

Automating the Maintenance of a Standby Server

Introducing Replication