SQL Server 6.5 online training courses
Total Courses: 6    Estimated Training Time: 46 Hour(s)

Summary

1 Year Unlimited access to all 6 courses listed below, includes over 46 hours of online courseware.

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.

Current Price: $59.95 | List Price: $119.99

This SQL Server 6.5 online training series provides 46 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:

  1. Introduction
  2. Installation and Setup
  3. Users and Replication
  4. Database Administration
  5. System Management
  6. Tuning for Performance

Lesson Detail:

  • SQL Server 6.5: Introduction
    This course 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

  • SQL Server 6.5: Installation and Setup
    This course 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

  • SQL Server 6.5: Users and Replication
    This course 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

  • SQL Server 6.5: Database Administration
    This course 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

  • SQL Server 6.5: System Management
    This course 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

  • SQL Server 6.5: Tuning for Performance
    This course 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

Certification

SQL Server 6.5

Audience

This series is for anyone who wants an introduction to SQL Server 6.5 database objects and SQL Enterprise Manager.

Features

  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Exercises allow learners to practice in the actual application being studied.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.
  • Exercises allow learners to practice in the actual application being studied.
  • A file containing the text of the exercises.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.

Technical Requirements

  • Internet connection
  • Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.

What You Get

You will receive Unlimited Access to all of the SQL Server 6.5 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 50 countries. We have been providing web based training for the past 9 years.

Web-Based Training Products

You might also be interested in our Microsoft Certifications Package which includes all of the SQL Server 6.5 training courses listed above plus over 749 hours related training courses

Microsoft Certifications

Learn the latest in technical Microsoft topics and help prepare for the MCTS, MCITP, and MCSE core and elective exams required to earn Microsoft certifications.

81 Series

Price: $149.95