Microsoft SQL Server 6.5 System Administration

Call 644-6106, ext. 107

or

e-mail

for course registration or more information

Overview

This course provides students with the knowledge and skills required to install, configure, administer, and trouble-shoot Microsoft SQL Server client/server data-base management system version 6.5.

At course completion, students will be able to:

• Install and configure SQL Server 6.5.
• Manage the storage requirements of a data-base.
• Manage user accounts, login security, and database permissions.
• Manage the import, export, and replication of data.
• Maintain the system and perform day-to-day operations including:

  - Backing up and restoring a database.
  - Recovering from a system disaster.
  - Scheduling tasks.
  - Setting alerts.
  - Monitoring.
  - Tuning.

Course prerequisites

Knowledge and familiarity of Windows NT 4.0 Server.

Course outline

Introduction to SQL Server Administration

Microsoft SQL Server 6.5 overview
SQL Server system administration
Administrative challenges of current data management systems
Distributed management framework
SQL Server administration tools

Installing and Configuring

Hardware and software requirements
Where to install SQL Server
Installing server software
Starting and stopping SQL Server
Logging in to SQL Server
Verifying the installation
System databases
Installing client software
Post-installation configuration
Testing the installation

Managing Databases and Devices

Creating devices
Creating databases
Expanding devices
Resizing databases
Expanding the transaction log
Dropping devices and databases
Estimating storage requirements

Managing User Accounts

Introduction to database access
Planning for database access
Managing database groups
Managing login IDs and database users
Displaying user information

Managing Login Security

Introduction to login security
Implementing standard security
Implementing integrated security
Implementing mixed security

Assigning User Permissions

Introduction to user permissions
Permission hierarchy
Granting and revoking permissions
Ownership chains
Permissions on views
Permissions on stored procedures
Displaying information on permissions

Backing Up System and User Databases

Preventing data loss
Backup overview
Implementing backups
Using SQL Enterprise Manager
Obtaining information on dump devices

Restoring System and User Databases

Restore overview
Methods of recovery
Recovering user databases after a media failure
Restoring a database and its log
Restoring the master database
Restoring the msdb database

Importing, Exporting, and Distributing Data

Managing data overview
Using the Transfer Management Interface
Using the Bulk Copy Program
Moving data using the backup and restore commands
Distributing data on removable media

Scheduling Tasks and Setting Alerts

Task scheduling and alerts overview
SQL Executive
Managing task scheduling
Implementing SQLMail
Managing alerts
Using an alerts management server

Monitoring and Tuning

Goals of monitoring and tuning
Factors that impact performance
SQL Performance Monitor overview
Monitoring and tuning memory
Creating tempdb in memory
Monitoring locks

Setting Up and Configuring Replication

Distributed data overview
Benefits of replication
SQL Server 6.5 replication overview
Types of replication scenarios
Replication server event processing
Setting up replication
Using SQL Enterprise Manager