◊ SQL SERVER 6.5 ONLINE TRAINING SERIES
Online SQL Server 6.5 Training
Database » SQL Server
Check out these great money-saving course packages:
Only $42.95
SQL Server 6.5 Series (46 hours)
ONLINE TRAINING FEATURES
- Learn online with these interactive online courses.
- Affordable Pricing (Only $42.95 for the complete series)
- A full year to complete the courses
- Retake the courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
1. Introduction
Time: 9 hours
This course covers SQL Enterprise Manager and how to use it to create and manage database objects in Microsoft SQL Server 6.5.
Objectives
- 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
2. Installation and Setup
Time: 5 hours
This course provides instructions for installing Microsoft SQL Server 6.5 and setting up physical and mirror devices.
Objectives
- 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
3. Users and Replication
Time: 9 hours
This course provides instruction on implementing security and user administration and on configuring replication in Microsoft SQL Server 6.5.
Objectives
- 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
4. Database Administration
Time: 9 hours
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
- 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
5. System Management
Time: 7 hours
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
- 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
6. Tuning for Performance
Time: 7 hours
This course provides instruction on tuning Microsoft SQL Server 6.5 to optimize performance.
Objectives
- 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
Resources for SQL Server 6.5
