Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
SQL Server 7 Admin: Database Management shows users how to create and maintain SQL server databases.

Audience
This course is for database administrators who want to learn how to administer SQL Server 7.0 or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.

Time
3 hours

Product Code: LA7C11
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.

 
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.