SQL Server 2000 Data Warehousing training

C/C++
- Compilers
- Add-ons/Utilities

Delphi/Pascal
- Compilers
- Add-ons/Utilities

Java
- Compilers
- Add-ons/Utilities

Visual Basic
- Compilers
- Add-ons/Utilities

Generic Tools
  - .NET Tools
  - Comm. Tools
  - Database/SQL Tools
  - Debugging/Testing
  - Demo Development
  - Editing Tools
  - Embedded Tools
  - Help Development
  - Imaging/Graphics
  - Installation
  - Internationalisation
  - Internet
  - Misc. Tools
  - Security
  - Version Control/SCM
  - Web Development
  - XML Tools

Vendor Partners

Download Area

Feedback

MicroWay Sitemap

Take Learning to a Whole New Level

SQL Server 2000 Data Warehousing

Interactive Instructor Based Video Training Courses and Study Guides

Outline

Buy Options

Contents

- Products
- Downloads
- Pricing
- Secure Order

SQL Server 2000 Data Warehousing: Level 1

1.0 Introduction
1.1 Topic Overview
1.2 Transactional vs. Analytical Data Systems
1.3 Data Warehouse Defined
1.4 Data Warehouses vs. Data Marts/OLAP

2.0 Dimensional Modelling & Planning
2.1 Entity-Relationship modelling vs. Dimensional modelling
2.2 Elements of the Dimensional model

2.3 The Role of User Requirements
2.4 Identifying Source data
2.5 Implementing the Data Warehouse Bus

3.0 Planning Facts
3.1 What is a fact?
3.2 Measures

4.0 Planning Dimensions
4.1 Planning a Hierarchy


	SQL Server 2000 Data Warehousing: Level II
	1.0 Building a Data Mart 1.1 Creating the Database 1.2 Creating the Fact Table 1.3 Creating Dimension Tables 1.4 Creating Constraints and indexes Loading the Data-Mart 2.1 Using Staging Tables 2.2 Using Transact SQL for Data Migration	2.3 Loading Data using Data Transformation Services 2.4 Advanced DTS Issues 2.5 Evaluating a Typical Load Scenario 3.0 Maintaining the Data Mart 3.1 Backup and Restoration Considerations 3.2 Handling Changing Facts 3.3 Handling Changing Dimensions 3.4 Securing the Data Mart


	SQL Server 2000 Data Warehousing: Level III
	1.0 Introduction to OLAP 1.1 OLAP Concepts 1.2 Analysis Services Architecture 2.0 Cube Basics 2.1 Cube Basics & Measures 2.2 Dimensions and Hierarchies 2.3 Aggregations 2.4 Using the Analysis Manager	3.0 Creating Dimensions 3.1 Defining Terms 3.2 Creating Dimensions with the Dimension Wizard 3.3 Creating Time Dimensions 3.4 Using the Dimension Editor 3.5 Using Member Properties 3.6 Virtual Dimensions 3.7 Multiple Hierarchies


	SQL Server 2000 Data Warehousing: Level IV
	1.0 Managing Cube Partitions 1.1 Partitions Concepts 1.2 Creating Cube Partitions 1.3 Merging Partitions 2.0 Optimising Cubes 2.1 Optimising Aggregations with Storage Models 2.2 Usage-Based Optimisations 2.3 Tuning the Analysis Server	3.0 Special Features 3.1 Using Drillthrough 3.2 Creating and Using Actions 4.0 Connecting Clients Using OLE DB 4.1 Analysis Application Architecture 4.2 Using Excel as an Analysis Server Client 4.3 Overview of Client Interfaces

SQL Server 2000 Data Warehousing: Level V

1.0 MDX Concepts Overview
1.1 What is MDX?
1.2 Role of MDX in Application Architecture
1.3 Creating Calculated Members Within Cubes
1.4 Using MDX in Client Applications
1.5 MDX Examples

2.0 Creating Simple MDX Expressions
2.1 Understanding the Hierarchy
2.2 Using Brackets
2.3 Identifying Members
2.4 Qualifying Sets of Members
2.5 Creating Calculated Members

3.0 Interacting With Cubes
3.1 Anatomy of an MDX Query
3.2 Basic MDX Queries
3.3 Tuple Expressions

4.0 Performing Aggregations
4.1 Calculating data in an MDX Query
4.2 Using Aggregate Functions
4.3 Using Time Set Functions

5.0 Using MDX with ADOMD
5.1 Connecting to an Analysis Server
5.2 Executing an MDX Query
5.3 Manipulating Results

Note: Course outlines are subject to change.

Buying Options - Pricing

SQL Server 2000 Data Warehousing on DVD-ROM - Desktop Learning Library Edition
5 Levels (91 Lessons) Single User

SQL Server 2000 Data Warehousing Online
5 Levels (91 Lessons) Single User

SQL Server 2000 Data Warehousing on VHS
5 Levels (91 Lessons) Single User

For more information please contact the MicroWay sales team:

Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
sales@microway.com.au

Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
sales@microway.com.au

International: call +61 3 9580 1333, fax +61 3 9580 8995