Technical Training - Administering a Microsoft SQL Server 2000 Database

Course No: 2072 Course Length: 5 Days

Who Should Attend:
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 ServerTM2000. Course 2072 is a revision of course 832: System Administration for Microsoft SQL Server 7.0.

Pre-Requisites:

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.

Module 1: SQL Server Overview
What Is SQL Server
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server

Module 2: Planning to Install SQL Server
Hardware Installation Considerations
SQL Server 2000 Editions
Software Installation Considerations
Methods of Installing SQL Server
Verifying the Installation
Configuring SQL Server Enterprise Manager
Troubleshooting

Module 3: Managing Database Files
Introduction to Data Structures
Creating Databases
Managing Databases
Placing Database Files and Logs
Optimizing the Database Using Hardware-based RAID
Optimizing the Database Using Filegroups
Optimizing the Database Using Filegroups with Hardware-based RAID
Capacity Planning
Performance Considerations

Module 4: Managing Security
Implementing an Authentication Mode
Assigning Logins to Users and Roles
Assigning Permissions to Users and Roles
Managing Security Within SQL Server
Managing Application Security
Managing SQL Server Security in the Enterprise

Module 5: Performing Administrative Tasks
Configuration Tasks Routine SQL Server
Administrative Tasks Automating Routine
Maintenance Tasks Creating Alerts
Troubleshooting SQL Server Automation
Automating Multiserver Jobs

Module 6: Backing Up Databases
Preventing Data Loss
Setting and Changing a Database Recovery Model
SQL Server Backup
When to Back Up Databases
Performing Backups
Types of Backup Methods
Planning a Backup Strategy
Performance Considerations

Module 7: Restoring Databases
SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases

Module 8: Monitoring SQL Server for Performance
Why to Monitor SQL Server
Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks

Module 9: Transferring Data
Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL Server
Introduction to DTS
Transforming Data with DTS

Module 10: Maintaining High Availability
Introduction to Availability
Increasing Availability Using Failover Clustering
Standby Servers and Log Shipping

Module 11: Introducing Replication
Introduction to Distributed Data
Introduction to SQL Server Replication
SQL Server Replication Agents
SQL Server Replication Types
Physical Replication Models

Site by Notcon