System Administration for Microsoft SQL Server 7.0

Software Training

Back to Course Listings
Back to Course Categories

Course Name

System Administration for Microsoft SQL Server 7.0
Course No. 832

Course Description

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft® SQL Server™ client/server database management system version 7.0.

Who Should Attend

This course is intended for system administrators whose job is to install, configure, and support Microsoft SQL Server in an enterprise network, including managing storage, setting up user accounts, assigning permissions, transferring data in an out of SQL Server databases, and diagnosing system problems.

Prerequisites

Course 922, Supporting Microsoft Windows NT® 4.0 Core Technologies, or equivalent knowledge
An understanding of basic relational database concepts
Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements)
Familiarity with the role of the database administrator

Length

40 hours

Class Size

Up to 12

CEU's Awarded

3.5

This course helps you prepare for the Microsoft Certified Professional exams 70-028: System Administration for Microsoft SQL Server 7.0

Format

Hands-on Workshop. One lab station for every participant.

Learning Objectives

Participants will learn to:

To describe SQL Server architecture
Plan for a SQL Server installation
Install SQL Server
Configure SQL Server; manage files and databases
Choose a login security method
Configure login security; plan and implement database permissions
Back up databases
Restore databases
Automate administrative tasks using SQL Server Agent
Import, export and transform data; monitor and maintain SQL Server performance
Replicate data from one SQL Server to another

Course Customization

Call 1-800-777-0753 for a detailed outline or for information about tailoring this course to your specific needs.

For scheduling please call your
Customer Representative at 1-800-777-0753.