SQL Server 6.5

This series provides an overview of Microsoft SQL Server 6.5. The SQL Enterprise Manager and its use for creation and management of database objects is explained in detail. Instructions for installing SQL Server 6.5 and setting up physical and mirror devices is provided, along with instructions on implementing security, user administration, and configuring replication. Database administration is covered in detail, including creating and maintaining databases and database logs, and using OBCC for maintenance. Advanced topics covered include system management, remote and distributed management options, and performance tuning.

Syllabus

INTRODUCTION

Covers SQL Enterprise Manager and how to use it to create and manage database objects in Microsoft SQL Server 6.5.

• Introduction to SQL Enterprise Manager
• Creating and Altering Database Objects

INSTALLATION AND SETUP

Provides instructions for installing Microsoft SQL Server 6.5 and setting up physical and mirror devices.

• Responsibilities of the System Administrator
• SQL Server installation and Connectivity
• Defining Physical and Mirror Devices

USERS AND REPLICATION

Provides instruction on implementing security and user administration and on configuring replication in Microsoft SQL Server 6.5.

• Security and User Administration
• Introduction to SQL Server 6.5 Replication

DATABASE ADMINISTRATION

Provides instruction on creating and maintaining databases and database logs. It also explains how to use DBCC to maintain the efficiency and reliability of Microsoft SQL Server 6.5 databases.

• Defining, Altering, and Maintaining Databases and Logs
• DBCC

SYSTEM MANAGEMENT

Provides instruction on database maintenance through transaction logs and recovery as well as backup and restore. It also covers remote and distributed management options of Microsoft SQL Server 6.5.

• Database Logging and Recovery
• SQL Server Database Backup and Restoration
• Remote Server Management
• The MS SQL Server Distributed Management Framework

TUNING FOR PERFORMANCE

Provides instruction on tuning Microsoft SQL Server 6.5 to optimize performance.

• Configuring and Tuning SQL Server
• Optimizing SQL Server Configuration Options
• Measuring SQL Server System Performance
• Miscellaneous Performance Topics

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.