SQL Server 6.5: Installation and Setup

Synopsis
SQL Server 6.5: Installation and Setup provides instructions for installing Microsoft ® SQL Server TM 6.5 and setting up physical and mirror devices.

Audience
This course is for anyone preparing for the MCSE Exam 70-026 System Administration for Microsoft ® SQL Server TM 6.5 or for a system administrator who needs to install or configure SQL Server 6.5.

Time
4 hours

Product Code: SQSC02

After completing SQL Server 6.5: Installation and Setup, the user should be able to:

Identifiy system administrator functionality

Configure Microsoft Windows NT for SQL Server installation

Configure SQL Executive to log on as a service

Load multiple Net-Libraries

Upgrade SQL Server 4.2x to SQL Server 6.5

Create a device

Responsibilities of the System Administrator

System and Database Administration

System Tables

System Stored Procedures

SQL Server installation and Connectivity

Hardware and Software Requirements

Upgrading from 4.2 or 6.0

Step by Step Server and Client Installation

Troubleshooting

Defining Physical and Mirror Devices

Disk Initialization

Disk Mirroring

This course is distributed with

Exercises, with sample files, that allow users to practice in SQL Server 6.5

A file containing the text of the exercises

Simulations that allow users to practice course skills, even if they don't have access to the SQL Server 6.5 product

A SQL Server 6.5 glossary