Go Back
SQL Server 6.5 Series (Exam 70-026)
Total Time: 46 hours

SQL Server 6.5: Introduction Time: 9 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: 5 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: 9 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: 9 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: 7 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: 7 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

    • Go Back