SQL Server 6.5: Database Administration

Products

Resources

Specials

Summary:

This training 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 training 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

Outline:

Defining, Altering, and Maintaining Databases and Logs
DBCC

Features:

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

Applicability:

This training course is for anyone preparing for the MCSE Exam 70-026 System Administration for Microsoft SQL Server 6.5 or anyone who needs to manage data storage and databases.

Prerequisites:

Previous training course s in, or experience with, NT Server administrationSQL Server 6.5: IntroductionSQL Server 6.5: Installation and SetupSQL Server 6.5: Users and Replication

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Microsoft® is a registered trademark of Microsoft Corporation.
Windows NT® is a registered trademark of Microsoft Corporation.

Terms of Use:

None