Learn to administer information systems that incorporate SQL Server 2000 Enterprise Edition. Learn to install and configure SQL 2000 Server. Then create, manage, and troubleshoot SQL 2000 databases, extra and transfer data, and SQL 2000 Security. Paul Sheriff and Michael Lee will teach you everything you need to know to manage your data successfully.

About the Trainers

Paul D. Sheriff is the owner of PDSA Inc., a Microsoft Solutions Provider for Visual Basic and SQL Server. Paul has 10 years experience and is Visual Basic certified. He is one of the top instructors on Visual Basic and speaks at Advisor Developer Conferences and Microsoft TechEd every year. He is also the author of over 25 articles in major publications.

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.
 

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 Modeling & Planning
• 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
• 3.1 What is a fact?
• 3.2 Measures
• 4.0 Planning Dimensions
• 4.1 Planning Dimension Tables
• 4.2 Planning a Hierarchy
• 4.3 Special dimensions

Data Warehousing Level 2

• 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
• 2.0 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

Data Warehousing Level 3

• 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 & 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 Basic Dimension Properties
• 3.6 Using Member Properties
• 3.7 Virtual Dimensions
• 3.8 Multiple Hierarchies
• 4.0 Creating Cubes
• 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

Data Warehousing Level 4

• 1.0 Managing Cube Partitions
• 1.1 Partitions Concepts
• 1.2 Creating Cube Partitions
• 1.3 Merging Partitions
• 2.0 Optimizing Cubes
• 2.1 Optimizing Aggregations with Storage Models
• 2.2 Usage-Based Optimizations
• 2.3 Tuning the Analysis Server
• 3.0 Special Features
• 3.1 Using Drillthrough
• 3.2 Creating and Using Actions (Demo: Custom 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
• 5.0 Introduction to Data Mining
• 5.1 Data Mining Basics
• 5.2 Creating Data Mining Models

Data Warehousing Level 5

• 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
• 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 (Demo: Creating a Calculated Member)
• 3.0 Interacting with Cubes
• 3.1 Anatomy of an MDX Query
• 3.2 Basic MDX Queries
• 3.3 Tuple Expressions (Demo: _____)
• 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

Regular price: $449.95Sale price: $429.95

Click here for Secure Yahoo Order: SQL Server 2000 Data Warehousing Training Series

Get Train in SQL
SQL Training CD

Best Regards,
Oracle Database, SQL, Application, Programming Tips