Library 6 : Technical MCSE

SQL Server 6.5 Series

Total Time: 24 hours

SQL Server 6.5: Introduction		4 hours	SQSC01
SQL Server 6.5: Introduction provides an overview of the use of SQL Enterprise Manager and how to use it to create and manage database objects in Microsoft (r) SQL Server (tm) 6.5.
Introduction to SQL Enterprise Manager		Creating and Altering Database Objects

SQL Server 6.5: Installation and Setup		4 hours	SQSC02
SQL Server 6.5: Installation and Setup provides instructions for installing Microsoft (r) SQL Server (tm) 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		4 hours	SQSC03
SQL Server 6.5: Users and Replication provides instruction on implementing security and user administration and on configuring replication in Microsoft (r) SQL Server (tm) 6.5.
Security and User Administration		Introduction to SQL Server 6.5 Replication

SQL Server 6.5: Database Administration		4 hours	SQSC04
SQL Server 6.5: Database Administration 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 (r) SQL Server (tm) 6.5 databases.
Defining, Altering, and Maintaining Databases and Logs		DBCC

SQL Server 6.5: System Management		4 hours	SQSC05
SQL Server 6.5: System Management 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 (r) SQL Server (tm) 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		4 hours	SQSC06
SQL Server 6.5: Tuning for Performance provides instruction on tuning Microsoft (r) SQL Server (tm) 6.5 to optimise performance
Configuring and Tuning SQL Server Optimising SQL Server Configuration Options		Measuring SQL Server System Performance Miscellaneous Performance Topics

Back

©2002 Purpletrain.Com Pte Ltd, Purpletrain.Com Logo and Informatics Holdings Ltd and the Informatics logo are registered trademarks of Informatics Holdings Ltd and Purpletrain.Com Pte Ltd. Informatics Holdings and Purpletrain.Com is a trademark herein used under license. All other brand names mentioned herein are used for identification purposes only and are trademarks of their respective owners.

This study guide and/or material is not sponsored by endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA™, CCDP™, CCNP™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc. in the United States and certain other countries. All other trademarks are trademarks of their respective owners.