CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2072 - Administering a Microsoft SQL Server 2000 Database

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000.

Click here for a printer-friendly version of this page

Prerequisites

Course MS2151, Microsoft Windows 2000 Network and Operating System Essentials and Course MS2152, Implementing Microsoft Windows 2000 Professional and Server or equivalent knowledge.

Detailed Class Syllabus

SQL Server Overview

What is SQL Server

SQL Server Integration

SQL Server Databases

SQL Server Security

Working with SQL Server

Planning to Install SQL Server

Hardware Installation Considerations

SQL Server 2000 Editions

Software Installation Considerations

Methods of Installing SQL Server

Verifying the Installation

Configuring SQL Server Enterprise Manager

Troubleshooting

Managing Database Files

Introduction to Data Structures

Creating Databases

Managing Databases

Placing Database Files and Logs

Optimizing the Database Using Hardware-based RAID

Optimizing the Database Using Filegroups

Optimizing the Database Using Filegroups with Hardware-based RAID

Capacity Planning

Performance Considerations

Managing Security

Implementing an Authentication Mode

Assigning Logins to Users and Roles

Assigning Permissions to Users and Roles

Managing Security within SQL Server

Managing Application Security

Managing SQL Server Security in the Enterprise

Performing Administrative Tasks

Configurations Tasks

Routine SQL Server Administrative Tasks

Automating Routine Maintenance Tasks

Creating Alerts

Troubleshooting SQL Server Automation

Automating Multiserver Jobs

Backing up Databases

Preventing Data Loss

Setting and Changing a Database Recovery Model

SQL Server Backup

When to Backup Databases

Performing Backups

Types of Backup Methods

Planning a Backup Strategy

Performance Considerations

Restoring Databases

SQL Server Recovery Process

Preparing to Restore a Database

Restoring Backups

Restoring Databases from Different Backup Types

Restoring Damaged System Databases

Monitoring SQL Server for Performance

Why to Monitor SQL Server

Performance Monitoring and Tuning

Tools for Monitoring SQL Server

Common Monitoring and Tuning Tasks

Transferring Data

Introduction to Transferring Data

Tools for Importing and Exporting Data in SQL Server

Introduction to DTS

Transforming Data with DTS

Maintaining High Availability

Introduction to Availability

Increasing Availability Using Failover Clustering

Standby Servers and Log Shipping

Introducing Replication

Introduction to Distributed Data

Introduction to SQL Server Replication

SQL Server Replication Agents

SQL Server Replication Types

Physical Replication Models