SQL Server 2000 System Administration

Course Description
Course Outline

Course 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.

We offer a range of SQL Server training courses

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

Publisher:	Microsoft
Version:	2000
Length:	4 days
Course-ID:	077461

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The trainer is always very knowledgeable, not only about the subject being taught, but other related topics ... having the all round knowledge sets you apart. Thanks again

- Heart of England TEC