Software Training Back to Course Listings
Back to Course Categories

Course Name Administering a Microsoft SQL Server 2000 Database
Course No. 2072
Course Description

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

Who Should Attend This course is intended for database administrators whose job is to install, configure, and support Microsoft SQL Server and databases, including managing storage; setting up user accounts; assigning permissions; securing SQL Server; backing up and restoring databases; performing other administrative tasks; transferring data in and out of SQL Server databases; diagnosing system problems, and ensuring high-availability.
Prerequisites
  • Experience using the Microsoft Windows® 2000 operating system to:
    • Connect clients running Windows 2000 to networks and the Internet.
    • Configure the Windows 2000 environment.
    • Create and manage user accounts.
    • Manage access to resources by using groups.
    • Configure and manage disks and partitions, including disk striping and mirroring.
    • Manage data by using NTFS.
    • Implement Windows 2000 security.
    • Optimize performance in Windows 2000.
Length 40 hours
Class Size Up to 12
CEU's Awarded 3.5

This course helps you prepare for the Microsoft Certified Professional exam 70-228: System Administration for Microsoft SQL Server 2000
Format Hands-on Workshop. One lab station for every participant.
Learning Objectives Participants will learn to:

  • Describe SQL Server architecture.

  • Plan for a SQL Server installation, and then install an instance of SQL Server.

  • Manage files and databases, including determining resource requirements.

  • Choose a login security method, configure login security, plan and implement database permissions, and describe how to secure SQL Server in an enterprise network.

  • Perform and automate administrative tasks and create custom administrative tools.

  • Back up databases and implement a backup strategy.

  • Restore databases.

  • Monitor and optimize SQL Server performance.

  • Transfer and migrate data into databases.

  • Maintain the high availability of SQL Server.

  • Describe how to 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.