Optimizing a SQL 7.0 Data Warehouse

Course Code IP1440

Contents

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

Screenshot

Description

The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students 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

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

Before taking this course, the user should be familiar with the relational database and data warehousing concepts and terminology and should have an experience in designing database management systems. The user 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 perform index tuning verify database consistency monitor and optimize query performance describe the procedures for backing up and restoring data optimize backup and restore performance schedule backup, replication, and DTS packages using jobs and alerts

Topics Include

Optimizing Data Warehouse Performance

• Maintaining Databases
• Monitoring Query Performance
• Quiz

Optimizing Backup and Restore

• Backing up and Restoring Data
• Optimizing Backup and Restore
• Quiz

Managing Administrative Tasks

• Automating Administrative Tasks
• Scheduling Jobs
• Quiz

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