SQL Server 6.5 Series (Exam 70-026)
Total Time: 24 hours

---

Six courses in this series provide students with the in-depth technical training necessary to help them prepare for certification exam 70-026. These courses were specifically built around the Microsoft Certification Preparation Guides for this exam and they have received the Microsoft Approved Study Guide logo. All six SQL Server 6.5 courses must be taken to receive the minimum necessary training needed to help students prepare for certification exam 70-026.

SQL Server 6.5: Introduction Time: 4 hours SQSC01 SQL Server 6.5: Introduction provides an overview of the use of SQL Enterprise Manager and how to use it to create and manage database objects in Microsoft (r) SQL Server (tm) 6.5. Introduction to SQL Enterprise Manager Creating and Altering Database Objects

SQL Server 6.5: Installation and Setup Time: 4 hours SQSC02 SQL Server 6.5: Installation and Setup provides instructions for installing Microsoft (r) SQL Server (tm) 6.5 and setting up physical and mirror devices. Responsibilities of the System Administrator SQL Server installation and Connectivity Defining Physical and Mirror Devices

SQL Server 6.5: Users and Replication Time: 4 hours SQSC03 SQL Server 6.5: Users and Replication provides instruction on implementing security and user administration and on configuring replication in Microsoft (r) SQL Server (tm) 6.5. Security and User Administration Introduction to SQL Server 6.5 Replication

SQL Server 6.5: Database Administration Time: 4 hours SQSC04 SQL Server 6.5: 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 (r) SQL Server (tm) 6.5 databases. Defining, Altering, and Maintaining Databases and Logs DBCC

SQL Server 6.5: System Management Time: 4 hours SQSC05 SQL Server 6.5: 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 (r) SQL Server (tm) 6.5. Database Logging and Recovery SQL Server Database Backup and Restoration Remote Server Management The MS SQL Server Distributed Management Framework

SQL Server 6.5: Tuning for Performance Time: 4 hours SQSC06 SQL Server 6.5: Tuning for Performance provides instruction on tuning Microsoft (r) SQL Server (tm) 6.5 to optimize performance Configuring and Tuning SQL Server Optimizing SQL Server Configuration Options Measuring SQL Server System Performance Miscellaneous Performance Topics

---