This course provides students with the knowledge & skills required to install, configure, administer & 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. The course content is being revised to reflect changes in the product.

Duration: 5 Days

Overview of SQL Server 2000
Installing SQL Server 2000
Preparing to Use SQL Server 2000
Upgrading to SQL Server
Understanding System & User Database
Creating & Configuring User Databases
Populating a Database
Developing a Data Restoration Strategy
Backing Up & Restoring SQL Server
Managing Access to SQL Server 2000
Managing SQL Server Permissions
Performing Administrative Tasks
Automating Administrative Tasks
Monitoring SQL Server Performance & Activity
Using SQL Server Replication
Maintaining High Availability

Experience using the Microsoft Windows 2000 operating system to:
Connect clients running Windows 2000 to networks & the Internet.
Configure the Windows 2000 environment.
Create & manage user accounts.
Manage access to resources by using groups.
Configure & manage disks & partitions, including disk striping & mirroring.
Manage data by using NTFS.
Implement Windows 2000 security.
Optimize performance in Windows 2000.