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
|
