Introduction to Microsoft SQL Server
Exploring the Features of Microsoft SQL Server
Discussing the Components of SQL Server
Identifying the Default Databases and System Tables
Understanding the SQL Server Architecture
Determining SQL Server Administration Tasks
Identifying Administrative Utilities

Installing SQL Server
Identifying the Requirements for Installing SQL Server
Installing SQL Server
Exploring the SQL Server Installation
Troubleshooting the SQL Server Installation

Designing and Implementing Databases
Developing a Strategy for Implementing Databases
Creating Databases
Managing Databases

Creating and Managing Tables
Creating Tables
Using Transact-SQL to Work with Tables

Designing and Configuring SQL Server Security
Identifying the Security Features of SQL Server
Creating Login Accounts
Assigning Login Accounts as Database Users
Implementing Statement and Object Permissions
Defining Linked Servers

Importing and Exporting Data
Introduction to Data Transfer
Bulk Data Transfers
Configuring XML Support

Backing Up SQL Server Databases
Planning Backups
Performing a Backup
Designing Your Backup Strategy

Restoring SQL Server Databases
Restoring User-defined Databases
Recovering System Databases

Automating SQL Server Administration
Configuring SQL Server to Send Mail
Defining SQL Operators
Managing Jobs
Managing Alerts

Designing, Configuring, and Managing Replication
Introduction to Replication
Configuring Replication
Monitoring and Maintaining Replication
Troubleshooting Replication

Implementing Fault Tolerance
Configuring Fault Tolerance in SQL Server 2000

Monitoring SQL Server
Designing a Strategy for Monitoring SQL Server
Using Monitoring Tools