2072 – Administering MS SQL Server 2000 Database

Course Specifications

Course length: 5 days

Location: Entre Technology Services, LLC  1501 N. 14th St. West, Suite 1511

Registration: Call your Account Manager at 406.256.5700 or use our Registration Forms

Course Description

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.  In addition, this course assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition.

At Course Completion

At the end of the course, students will be able to:

Describe SQL Server architecture. 

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. 

Perform and automate administrative tasks and create custom administrative tools. 

Back up databases and implement a backup strategy. 

Restore databases. 

Monitor and optimize SQL Server performance. 

Transfer and migrate data into databases. 

Maintain the high availability of SQL Server. 

Describe how to replicate data from one SQL Server to another Microsoft Certified Professional Exams

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. 


For students who do not meet these prerequisites, the following courses provide students with the necessary knowledge and skills:

Course 2151, Microsoft Windows 2000 Network and Operating System Essentials 

Course 2152, Implementing Microsoft Windows 2000 Professional and Server

Course Content

Lesson 1: SQL Server Overview

What Is SQL Server 

SQL Server Integration 

SQL Server Databases 

SQL Server Security 

Working with SQL Server 

Lesson 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 

Lesson 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 

Lesson 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 

Lesson 5: Performing Administrative Tasks

Configuration Tasks 

Routine SQL Server Administrative Tasks

Automating Routine Maintenance Tasks 

Creating Alerts 

Troubleshooting SQL Server

Automation Automating Multiserver Jobs 

Lesson 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 

Lesson 7: Restoring Databases

SQL Server Recovery Process 

Preparing to Restore a Database 

Restoring Backups 

Restoring Databases from Different Backup Types 

Restoring Damaged System Databases 

Lesson 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 

Lesson 9: Transferring Data

Introduction to Transferring Data 

Tools for Importing and Exporting Data in SQL Server 

Introduction to DTS 

Transforming Data with DTS 

Lesson 10: Maintaining High Availability

Introduction to Availability 

Increasing Availability Using Failover Clustering 

Standby Servers and Log Shipping 

Lesson 11: Introducing Replication

Introduction to Distributed Data 

Introduction to SQL Server Replication 

SQL Server Replication Agents 

SQL Server Replication Types 

Physical Replication Models