Administering a Microsoft SQL Server 2000 Database

Course Code: MS2072
Duration: 5 Days

Bookmark and Share

Overview

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. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0.

Leads to examination

  • 70-228 – Installing, Configuring, and Administering Microsoft SQL Server™ 2000 Enterprise Edition

Prerequisites

Before attending this course, students must have:

  • 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.
  • An understanding of basic relational database concepts, including: Logical and physical database design.
  • Data integrity concepts.
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
  • How data is stored in tables (rows and columns).
  • Knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE statements).

For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:
MS2071 Querying Microsoft SQL Server 2000

  • Familiarity with the role of the database administrator.

    • Delegates will learn how to

    • 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
    • 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
    • Monitor and optimise performance
    • Back up databases and implement a backup strategy

    Outline

    • Module 1: SQL Server Overview
    • Module 2: Planning to Install SQL Server
    • Module 3: Managing Database Files
    • Module 4: Managing Security
    • Module 5: Performing Administrative Tasks
    • Module 6: Backing Up Databases
    • Module 7: Restoring Databases
    • Module 8: Monitoring SQL Server for Performance
    • Module 9: Transferring Data
    • Module 10: Maintaining High Availability
    • Module 11: Introducing Replication

    Recommended follow on course

    Related Certifications

    This course forms part of the following certification track(s):