MS SQL Server 6.5: Installation & Administration

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Description

In this course, students will be presented with a task-based, real-world scenario covering the implementation, administration and troubleshooting of Microsoft SQL Server 6.5. Implementation of SQL Server includes the installation of the software and the setup of the SQL database. Administration of SQL Server includes managing storage, the setting up of user accounts and assigning permissions. The optimization and configuration of the SQL Server and the diagnostics of system problems with also be covered.

Audience

This course is designed for system administrators responsible for implementation and maintenance of Microsoft SQL Servers in an enterprise network.

Prerequisites

The student should have a Microsoft Windows NT Server 3.51 course or equivalent and two years experience performing system administration or support in a networked environment.

Objective

Topics Include

Installing SQL Server 6.5

• Install and Upgrade SQL 6.5: Verify Hardware Requirements
• Determine Software Requirements
• Create a SQL Executive Account
• Install SQL 6.5 Server
• Identify SQL Network Protocols
• Upgrade to Server 6.5
• Verify SQL Installation
• Install SQL Client
• Integrate SQL Server 6.5: Determine Security Requirements
• Integrate SQL Login Security
• Examine the NT Registry
• Examine Server Integration
• Examine SQL and MAPI
• Troubleshoot SQL Installation: Determine Install Failure
• Examine Upgrade Problems
• Examine SQL Mail Problems

Configuring SQL Server 6.5

• Configure Enterprise Database: Use the Enterprise Manager
• Configure SQL Server
• Manage SQL Server
• Administer SQL Server
• Set Alerts and Task Schedules: Examine SQL Executive Services
• Schedule Tasks
• Set Alerts
• Create an Operator
• Create an Alert
• Troubleshoot SQL Configuration: Examine Alert Problems

Administering SQL Databases

• Create SQL Databases: Explore System Databases
• Create a Database Device
• Estimate Database Space
• Create a Database
• Administer SQL Databases
• Create a Database Object
• Alter a Device
• Alter a Database
• Troubleshoot SQL Databases: Check Object Integrity
• Investigating a Suspect Database

Duration

3 hrs

Minimum Requirements

IBM 486 Compatible PC; VGA color monitor (256 colors); 8 MB RAM; 20MB hard disk space; MS Windows 3.x/Windows 95 or Windows NT 3.5 x/4.x; IBM 0S/2, Microsoft Mouse, 3.5 inch diskette drive.

Media

Diskette
CDROM
Web Based Training

© Copyright Serebra Learning Corp., 2002