Experience Digitally Assisted Learning at it's Best

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
    		•

     

     


    © 2003 Bridgeway Cyber Academy
     334 Second Street
    Catasauqua PA 18032

    Designed & Administered by PolyWeb Development