• Back to Microsoft Courses

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

Related Certifications

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

• MCSA Windows Server 2003
• MCSE Windows Server 2003

• Back to Top
• Back to Microsoft Courses