Optimizing a MS SQL Server 7.0 Data Warehouse

Course Code IP0300

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This course helps the student to identify tasks for data warehouse maintenance and optimization.  The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse.  In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).

Audience

This course is intended for all system administrators, help desk/support personnel, and application developers who design and implement data warehouse solutions by using Microsoft SQL Server 7.0.

Prerequisites

The student should be familiar with the relational database and data warehousing concepts and terminology and should have an experience in designing database management systems. The student should also have an understanding of Windows NT 4.0 Server and should have a knowledge of basic ANSI statements.

Objective

Upon completion of this course, the student will be able to:

• perform database maintenance
• maintain database indexes
• verify database consistency
• determine the performance of a database query
• optimize query performance
• describe the procedures for backing up a data warehouse
• describe the procedures for restoring a data warehouse
• describe the methods for optimizing backup and restore performance
• optimize backup and restore performance
• describe the features of automated administration
• create jobs, operators, and alerts
• schedule backup and replication jobs
• schedule DTS packages

Topics Include

Optimizing Data Warehouse Performance

• Maintaining Databases
• Monitoring Query Performance

Optimizing Backup and Restore

• Backing Up and Restoring Data
• Optimizing Backup and Restore

Managing Administrative Tasks

• Automating Administrative Tasks
• Scheduling Jobs

Duration

4 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.

Media

Web Based Training