Call: 0118 3243000
Systematix Training Ltd

SQL Server 2000 System Administration

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
Request A Quote Ask Us A Question

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

Microsoft Registered Partner
BSI ISO 9000