Planning an MS SQL Server 7.0 Data Warehouse

Course Code IP0270

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 provides the student with an introduction to the core technologies, concepts, architecture, and various features of data warehouses.  It also provides the student with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0  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:

• identify the features of a data warehouse
• describe SQL Server 7.0 features that support data warehousing
• describe the characteristics of data marts
• describe the components of a data warehouse
• identify the five main data warehouse models
• describe the strategies for implementing a data warehouse
• plan and manage data warehouse projects
• identify a data warehouse project requirements
• describe data extraction, data validation, and data scrubbing
• describe data integration and data transformation
• select a schema for a data warehouse database
• design the database schema for a data warehouse

Topics Include

Data Warehousing

• Data Warehousing Fundamentals
• Data Warehousing Architecture

Data Warehouse Models

• Data Warehouse Models
• Data Warehouse Design Plan

Designing a Data Warehouse

• Extracting and Loading Data
• Building a Data Warehouse Model

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