Total Time: 9 hour(s)

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.

Ojectives: 
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

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.