Using SQL 7.0 OLAP Services

Course Code IP1430

Contents

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

Screenshot

Description

The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) Services . It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP Services. The students will be able to design and optimize an OLAP database. 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 components, architecture, and features of OLAP Services install OLAP Services build an OLAP database for use with a data warehouse build an OLAP cube create cube partitions optimize partition of a cube or a partition implement database security for OLAP Services

Topics Include

Introducing SQL OLAP Services

• Features of OLAP Services
• Installing OLAP Services
• Quiz

Building an OLAP Database

• Designing an OLAP Database
• Building OLAP Cubes
• Quiz

Optimizing an OLAP Database

• Partitioning Cube Data
• Optimizing Database Performance
• Implementing Database Security
• 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 Version 6.02 or higher.

Media

Web Based Training