Custom Search

Using MS SQL Server 7.0 OLAP Services

MS SQL Server

Serebra Learning Corporation
Training Provided by Serebra Learning Corporation This course provides the student 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).
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Duration:3 hours
Training Presented in:English
Using MS SQL Server 7.0 OLAP Services Course Outline - IP0290 - Using MS SQL Server 7.0 OLAP Services

Using MS SQL Server 7.0 OLAP Services

Course Code IP0290

Contents

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

Screenshot


click to enlarge

Description

This course provides the student 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

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:

  • describe the architecture of OLAP Services
  • identify the features of OLAP Services
  • identify the system requirements for installing OLAP Services
  • install OLAP Services
  • identify the design considerations in creating a data warehouse for use with OLAP Services
  • build an OLAP database
  • build an OLAP cube using the Cube Wizard
  • describe the storage modes supported by OLAP Services
  • partition cube data to provide scalability
  • merge partitions for faster data processing
  • optimize the performance of a cube or a partition
  • analyze a cube’s usage patterns
  • describe the security features provided by SQL Server OLAP Services
  • describe the operational considerations for using OLAP Services

Topics Include

Introducing SQL OLAP Services

  • Features of OLAP Services
  • Installing OLAP Services

Building an OLAP Database

  • Designing an OLAP Database
  • Building OLAP Cubes

Optimizing an OLAP Database

  • Partitioning Cube Data
  • Optimizing Database Performance
  • Implementing Database Security

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

Serebra Learning Corporation, 1660 - 999 West Hastings, Vancouver, BC    V6C 2W2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Want to market your database training?
tcw11-gfc-v396M-10/25/09-10:39:40-()[A]-[A]-[B] -18:34:09