computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

SQL Server 6.5

12 Month Subscription - $70
Live Mentor +$30

Summary:
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.

Audience:
This series is for anyone preparing for the MCSE Exam 70-026 System Administration for Microsoft SQL Server 6.5 or anyone who wants an introduction to SQL Server 6.5 database objects and SQL Enterprise Manager.

Features:
●  Exercises that allow users to practice the application
●  A file containing the text of the exercises
●  Simulations that allow users to practice course skills, even if they don't have access to the application
●  A glossary

Topics included in this course:
SQL Server 6.5 : Introduction
SQL Server 6.5 : Installation and Setup
SQL Server 6.5 : Users and Replication
SQL Server 6.5 : Database Administration
SQL Server 6.5 : System Management
SQL Server 6.5 : Tuning for Performance

SQL Server 6.5 : Introduction
Summary:
This course covers SQL Enterprise Manager and how to use it to create and manage database objects in Microsoft SQL Server 6.5.

Objectives:
After completing this course, students will be able to:
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

Topics:
Introduction to SQL Enterprise Manager
Creating and Altering Database Objects
top

SQL Server 6.5 : Installation and Setup
Summary:
This course provides instructions for installing Microsoft SQL Server 6.5 and setting up physical and mirror devices.

Objectives:
After completing this course, students will be able to:
Identifiy system administrator functionality
Configure Microsoft Windows NT for SQL Server installation
Configure SQL Executive to log on as a service
Load multiple Net-Libraries
Upgrade SQL Server 4.2x to SQL Server 6.5
Create a device

Topics:
Responsibilities of the System Administrator
SQL Server installation and Connectivity
Defining Physical and Mirror Devices
top

SQL Server 6.5 : Users and Replication
Summary:
This course provides instruction on implementing security and user administration and on configuring replication in Microsoft SQL Server 6.5.

Objectives:
After completing this course, students will be able to:
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

Topics:
Security and User Administration
Introduction to SQL Server 6.5 Replication
top

SQL Server 6.5 : Database Administration
Summary:
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.

Objectives:
After completing this course, students will be able to:
Create and alter a database
Estimate space requirements for database storage
Set database options
Check object integrity
Investigate a database that is marked suspect

Topics:
Defining, Altering, and Maintaining Databases and Logs
DBCC
top

SQL Server 6.5 : System Management
Summary:
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.

Objectives:
After completing this course, students will be able to:
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

Topics:
Database Logging and Recovery
SQL Server Database Backup and Restoration
Remote Server Management
The MS SQL Server Distributed Management Framework
top

SQL Server 6.5 : Tuning for Performance
Summary:
This course provides instruction on tuning Microsoft SQL Server 6.5 to optimize performance.

Objectives:
After completing this course, students will be able to:
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

Topics:
Configuring and Tuning SQL Server
Optimizing SQL Server Configuration Options
Measuring SQL Server System Performance
Miscellaneous Performance Topics top

12 Month Subscription - $70
Live Mentor +$30