Implementing an SQL 7.0 Data Warehouse

Course Code IP1070

Contents

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

Screenshot

Description

The Implementing an SQL 7.0 Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for accessing a data source. 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:

describe the considerations involved in designing a database create files and filegroups choose an API for accessing a data source identify the various indexing schemes provided by an SQL Server 7.0 create and optimize indexes

Topics Include

Managing Databases

Creating Databases

Accessing a Data Source

Indexing Tables

Managing Data

Summarizing Data

Manipulating Data

Populating a Data Warehouse

DTS Architecture

Using Import Export Tools

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