Administering a MS SQL Server 2000 Database
Course
Course
Number:
Duration: 40
hours
Objectives
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.
Target Audience
This course is intended for SQL Server database
administrators, implementers, system engineers, and
developers who are responsible for writing queries.
Topics
SQL Server Overview, Planning to Install SQL Server,
Managing Database Files, Managing Security,
Performing Administrative Tasks, Backing Up
Databases, Restoring Databases, Monitoring SQL
Server for Performance, Transferring Data,
Maintaining High Availability, Introducing
Replication.
Prerequisites
Experience using the Microsoft Windows operating
system to: Connect clients running Windows to
networks and the Internet, Configure the Windows
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 security, Optimize performance in Windows.
