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.

 

Home | Information Request | Resource Library | Store | Courses 
College Transfer Credit and CEU's | Client Relationship | Training Methodology

Copyright Learn Maintenance, Inc.