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
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
