Call: 0118 3243000
Systematix Training Ltd
Home | SQL Server | SQL Server 2000 System Administration

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