|
12 Month Subscription - $70
|
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
|
