SQL Server 2000 System Administration

4 days

Overview

Students will learn how to install, configure, administer, and troubleshoot Microsoft SQL Server 2000 in a Windows 2000 Server environment.

Prerequisites

Windows 2000 Installation and Administration, or equivalent knowledge.

Target student

Students attending this course should be able to complete the tasks necessary to implement and administer a Windows NT Server 4/Windows 2000 Professional domain.

Introduction to Microsoft SQL Server

Exploring the Components of SQL Server
Administering SQL Server

Installing SQL Server

Identifying the Requirements for Installing SQL Server
Installing SQL Server
Exploring the SQL Server Installation
Troubleshooting the 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