Planning an SQL 7.0 Data Warehouse

Course Code IP1060

Contents

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

Screenshot

Description

The Planning an SQL 7.0 Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides students 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

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:

identify the features of a data warehouse identify the SQL Server features that support data warehousing list the benefits of using a data warehouse describe characteristics of data marts describe the components of a data warehouse identify different types of data warehouse models that are available analyze business requirements for creating a data warehouse describe the process of extracting and loading data in a data warehouse select a schema design for a relational database build a database

Topics Include

Introduction to Data Warehousing

• Data Warehousing Fundamentals
• Data Warehouse Architecture
• Quiz

Data Warehouse Models

• Data Warehouse Models
• Data Warehouse Design Plan
• Quiz

Designing a Data Warehouse

• Extracting and Loading Data
• Building a Data Warehouse
• 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