Up to Level
 Creating and Using Data Warehouses Overview
 SQL Server 2000 Tools for Data Warehouses
 Parts of a Data Warehouse
    Data Marts
    Relational Databases
    Data Sources
    Data Preparation Area
    Presentation Services
    End-User Analysis
 Creating a Data Warehouse
    Designing a Data Warehouse
       Using Dimensional Modeling
       Fact Tables
       Aggregation Tables
       Dimension Tables
       Indexes
    Creating the Data Preparation Area
    Creating the Data Warehouse Database
    Extracting Data from Operational Systems
    Cleansing and Transforming Data
    Loading Data into the Data Warehouse Database
    Preparing Presentation Information
    Distributing Data to Data Marts
 Using a Data Warehouse
    SQL Queries
    OLAP and Data Mining
    English Query
    Microsoft Office 2000
    Web Access and Reporting
    Offline OLAP Cubes
    Third-Party Applications
    Custom Applications
 Maintaining a Data Warehouse
    Updating Data Warehouse Data
       Scheduling Data Updates
       Synchronizing OLAP Cubes
       Updating Data Marts
    Administering a Data Warehouse
       Backing Up Data Warehouse Data
       Automating Data Warehouse Tasks
    Tuning Data Warehouse Performance