Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








SQL Server 6.5
 Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works
This online course includes: Time Needed
Introduction 9 hours
Installation and Setup 5 hours
Users and Replication 9 hours
Database Administration 9 hours
System Management 7 hours
Tuning for Performance 7 hours
Estimated time needed to complete entire course 46 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $67

OR

Buy the Microsoft Pack, and receive this course plus many more, for only $197



Benefits
  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements
All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer.  Prices shown are per user.




What You will Learn
This online training course 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.




Introduction
  • Access the features of SQL Enterprise Manager
  • Understand the terminology and options available in SQL Enterprise Manager

 

  • Create database objects with SQL Enterprise Manager
  • Modify and manage database objects
  • Manipulate and control database objects



Installation and Setup
  • Identify system administrator functionality
  • Configure Microsoft Windows NT for SQL Server installation
  • Load multiple Net Libraries
  • Create a device
  • Configure SQL Executive to log on as a service
  • Upgrade SQL Server 4.2x to SQL Server 6.5



Users and Replication
  • Set up a security mode
  • Identify how SQL Server is integrated with Windows NT
  • Manage user accounts
  • Manage permissions
  • Identify and implement the appropriate replication scenario



Database Administration
  • Create and alter a database
  • Estimate space requirements for database storage
  • Set database options
  • Check object integrity
  • Investigate a database that is marked suspect



System Management
  • Identify how automatic recovery works
  • Perform a database dump and load a database dump
  • Perform a striped backup
  • Configure and manage server in the enterprise
  • Set up alerts and schedule tasks



Tuning for Performance
  • Select the appropriate settings for locks
  • Configure the number of worker threads
  • Select the appropriate settings for read ahead
  • Identify the benefits of installing the tempdb database in RAM
  • Tune and monitor memory use






 

 

Copyright © 2007 TrainingCenter.com