Experience using the Microsoft Windows® 2000 operating system to:

• Connect clients running Windows 2000 to networks and the Internet.
• Configure the Windows 2000 environment.
• Create and manage user accounts.
• Manage access to resources by using groups.
• Configure and manage disks and partitions, including disk striping and mirroring.
• Manage data by using NTFS.
• Implement Windows 2000 security.
• Optimize performance in Windows 2000.

For students who do not meet these prerequisites, the following courses provide students with the necessary knowledge and skills:

An understanding of basic relational database concepts, including:

• Logical and physical database design.
• Data integrity concepts.
• Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
• How data is stored in tables (rows and columns).

For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:

Module 1: SQL Server Overview

What Is SQL Server

SQL Server Integration

SQL Server Databases

SQL Server Security

Working with SQL Server

Module 2: 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

Module 3: 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

Module 4: 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

Module 5: Performing Administrative Tasks

Configuration Tasks Routine SQL Server Administrative Tasks Automating Routine Maintenance Tasks Creating Alerts Troubleshooting SQL Server Automation Automating Multiserver Jobs

Module 6: Backing Up Databases

Preventing Data Loss

Setting and Changing a Database Recovery Model

SQL Server Backup

When to Back Up Databases

Performing Backups

Types of Backup Methods

Planning a Backup Strategy

Performance Considerations

Module 7: Restoring Databases

SQL Server Recovery Process

Preparing to Restore a Database

Restoring Backups

Restoring Databases from Different Backup Types

Restoring Damaged System Databases

Module 8: Monitoring SQL Server for Performance

Why to Monitor SQL Server

Performance Monitoring and Tuning

Tools for Monitoring SQL Server

Common Monitoring and Tuning Tasks

Module 9: Transferring Data

Introduction to Transferring Data

Tools for Importing and Exporting Data in SQL Server

Introduction to DTS

Transforming Data with DTS

Module 10: Maintaining High Availability

Introduction to Availability

Increasing Availability Using Failover Clustering

Standby Servers and Log Shipping

Module 11: Introducing Replication

Introduction to Distributed Data

Introduction to SQL Server Replication

SQL Server Replication Agents

SQL Server Replication Types

Physical Replication Models