Publisher: Microsoft

Version: 7
Length: 4 day s
Course-ID: 044461

Course Overview

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

Prerequisites

Windows NT 4 System Architecture and Network Support, 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 domain.


Introduction to Microsoft SQL Server
  • Exploring the components of SQL Server
  • Identifying SQL Server administration tasks
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
Backing up SQL Server databases
  • Planning backups
  • Performing a backup
  • Designing your backup strategy
  • Restoring SQL Server databases
Recovering system databases Automating SQL Server administration
  • Configuring SQL Server to send mail
  • Defining SQL operators
  • Managing jobs
  • Managing alerts
  • Designing and implementing replication