After completing SQL Server 7 Admin: Database Management the user should be able to:

	Create and manage databases
	Create data files filegroups and transaction log files
	Specify growth characteristics
	Manage database size
	Set database options
	Document and script a database
	Set up a database maintenance plan
	Delete a database

Creating a Database

	Managing a database
	Creating data files and filegroups
	Specifying growth characteristics

Managing Database Size

	Shrinking a database
	Deleting data and log files

Database Options and Scripts

	Setting database options
	Documenting and scripting a database

Managing and Deleting Databases

	Setting up a database maintenance plan
	Deleting a database

This course has the following features:

	Exercises that allow users to practice in SQL Server 7.0
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0
	A glossary
	A Skill Assessment

	Courses on Relational Database Management Systems or equivalent experience
	Courses on Windows NT administration or equivalent experience
	Courses on Database Concepts or equivalent experience
	Courses on SQL or equivalent experience
	SQL Server 7 Admin: Security Strategy (LA7C01)
	SQL Server 7 Admin: System Requirements (LA7C02)
	SQL Server 7 Admin: Migration Planning (LA7C03)
	SQL Server 7 Admin: Replication Plans (LA7C04)
	SQL Server 7 Admin: Installing the Server (LA7C05)
	SQL Server 7 Admin: Other Installations (LA7C06)
	SQL Server 7 Admin: Configuring (LA7C07)
	SQL Server 7 Admin: Security Management (LA7C08)
	SQL Server 7 Admin: Managing Accounts (LA7C09)
	SQL Server 7 Admin: Managing Permissions (LA7C10)

Microsoft® is a registered trademark of Microsoft Corporation.