Microsoft SQL 2000 Training Data Warehousing
 After completing this course you will have the knowledge and skills necessary to design a data warehouse and to populate
data marts by using Data Transformation Services (DTS) in Microsoft SQL Server 2000.
About the Trainer
Michael Lee is a Senior Trainer and Consultant with Saqqara Technology, Inc., a MIcrosoft Certified Partner located in Henderson, Nevada. Michael has over 10 years technology
training experience and has published numerous books about SQL Server and Client/Server development. He is a popular speaker and presenter, and is demanded at client sites and conferences all over the US and Europe.
|
5 Video Set SQL 2000 Server Data Warehousing Levels 1- 5
|
kysqd2b
|
$449.95
|
|
|
5 CD Set SQL 2000 Server Data Warehousing Levels 1- 5
|
kysqd2bm
|
$449.95
|
|
|
16 Video Set Server Administration, Implementing & Design and Data Warehousing Videos
|
kysq2d
|
$1299.95
|
|
|
16 CD Set Server Administration, Implementing & Design and Data Warehousing Videos
|
kysq2dm
|
$1299.95
|
|
MS SQL Server Data Warehousing 2000 Course for
MCSD Certification Training on Videos and CD-ROMS
Level 1 (2 hrs)
1.0 Introduction (20 min)
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 Modeling & Planning (40 min)
2.1 Entity-Relationship Modeling vs. Dimensional Modeling
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 (20 min)
3.1 What is a fact?
3.2 Measures
4.0 Planning Dimensions (40 min)
4.1 Planning Dimension Tables
4.2 Planning a Hierarchy
4.3 Special dimensions
Level 2 (1 hr 45 min)
1.0 Building a Data Mart (40 min)
1.1 Creating the Database
1.2 Creating the Fact Table
1.3 Creating Dimension Tables
1.4 Creating Constraints and Indexes
2.0 Loading the Data Mart (50 min)
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 (15 min)
3.1 Backup and Restoration Considerations
3.2 Handling Changing Facts
3.3 Handling Changing Dimensions
3.4 Securing the Data Mart
Level 3 (2 hrs)
1.0 Introduction to OLAP (15 min)
1.1 OLAP Concepts
1.2 Analysis Services Architecture
2.0 Cube Basics (20 min)
2.1 Cube Basics & Measures
2.2 Dimensions & Hierarchies
2.3 Aggregations
2.4 Using the Analysis Manager
3.0 Creating Dimensions (45 min)
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 Basic Dimension Properties
3.6 Using Member Properties
3.7 Virtual Dimensions
3.8 Multiple Hierarchies
4.0 Creating Cubes (40 min)
4.1 Selecting Facts and Measures
4.2 Choosing Dimensions
4.3 Creating Calculated Measures
4.4 Storage Models
4.5 Processing Dimensions
4.6 Processing Cubes
4.7 Using Cube Properties
Level 4 (1 hr 40 min)
1.0 Managing Cube Partitions (15 min)
1.1 Partitions Concepts
1.2 Creating Cube Partitions
1.3 Merging Partitions
2.0 Optimizing Cubes (25 min)
2.1 Optimizing Aggregations with Storage Models
2.2 Usage-Based Optimizations
2.3 Tuning the Analysis Server
3.0 Special Features (15 min)
3.1 Using Drillthrough
3.2 Creating and Using Actions
4.0 Connecting Clients Using OLE DB (30 min)
4.1 Analysis Application Architecture
4.2 Using Excel as an Analysis Server Client
4.3 Overview of Client Interfaces
5.0 Introduction to Data Mining
5.1 Data Mining Basics
5.2 Creating Data Mining Models
Level 5 (1 hr 40 min)
1.0 MDX Concepts Overview (15 min)
1.1 What is MDX?
1.2 Role of MDX in Application Architecture
1.3 MDX Examples
2.0 Creating Simple MDX Expressions (20 min)
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 (20 min)
3.1 Anatomy of an MDX Query
3.2 Basic MDX Queries
3.3 Tuple Expressions
4.0 Performing Aggregations (25 min)
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
(20 min)
5.1 Connecting to an Analysis Server
5.2 Executing an MDX Query
5.3 Manipulating Results
|
