SQL Server 6.5
DescriptionThis 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.
Covers SQL Enterprise Manager and how to use…
Frequently asked questions
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
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
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
Qualification: Printable TranscriptOn 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.
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.
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.