Hi,

I'm certified in Oracle8i database administration but am more interested in database development and data-warehousing development.

I'm looking for a data-warehousing engineer job, will the following course be useful? I realised it's stated "This couse is intended for supervisors and managers", so it wouldn't be useful for engineer?

Thanks in advance for any replies!


SQL Server 2000 Analysis Services

MIS INFORMATION TECHNOLOGIES EDUCATION CENTRE

URL: www.misuniversal.com

Overview & Objectives
This course provides students with the knowledge and
skills needed to use SQL Analysis Services to build
solutions that take advantage of the powerful dataanalysis
services. The student will discover these
services make it easier to analyze huge amounts of data
quickly and how to develop wide range of dimensionaldata
applications – from enterprise reporting tools to
advanced decision support systems.

Who Should Attend
This course is intended for supervisor and manager who
want to learn to use the SQL Analysis Services tool to
analyze huge amount of data.

Course Material
Microsoft(r) SQL Server(tm) 2000
Analysis Services Step by Step
by OLAP Train and Reed Jacobson

Course Outline
1. A Data Analysis Foundation
1.1. Understanding Data Warehousing
1.2. The Structure of a Data Warehouse
1.3. Understanding Analysis Services

2. Analysis Manager from 500 Feet
2.1. Previewing Analysis Manager
2.2. Preparing to Create a Cube
2.3. Designing a Cube by Using the Cube Wizard
2.4. Processing and Browsing a Cube

3. Dimension and Cube Editors
3.1. Working with a Standard Star Schema
Dimension
3.2. Working with a Standard Snowflake
Dimension
3.3. Working with Time Dimensions
3.4. Working with a Cube
3.5. Working with Measures in a Cube
3.6. Working with a Parent-Child Dimension

4. Advanced Dimensions and Cubes
4.1. Creating a Finance Cube
4.2. Creating an Internet Tracking Cube
4.3. Creating a Forecast Cube
4.4. Creating a Virtual Cubes

5. Office 2000 Analysis Components
5.1. Creating an Excel PivotTable Report
5.2. Creating an Office PivotTable List
5.3. Creating a Local Cube

6. MDX Values
6.1. Creating Simple MDX Expressions
6.2. Retrieving Values from Cells
6.3. Calculating Relative Contribution

7. MDX Sets
7.1. Preparing to Create MDX Queries
7.2. Creating Basic MDX Queries
7.3. Creating Calculations by Using Aggregation
Functions

8. Storage Optimization
8.1. Specifying Options for Optimizing Storage
8.2. Managing the Pool of Potential Aggregations

9. Processing Optimization
9.1. Understanding OLAP Processing
9.2. Managing OLAP Processing
9.3. Working with Partitions
9.4. Automating the Processing of a Database

10. Dimension Optimization
10.1. Optimizing Dimensions in a Cube
10.2. Creating Virtual Dimensions

11. Security
11.1. Creating Security Roles
11.2. Applying Security to a Dimension
11.3. Applying Cell-Level Security to a Cube

No comment?