Warehouse Training on CD-ROM
From 123-CBT Computer Based Training
SQL Server 2000 Data Warehousing Set of 5
... 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?
more...
SQL Server 7 0 Data Warehousing Set of 4
...ns 1.6 Data Marts 1.7 Know the Flow 1.8 Microsoft Data Warehouse Tools 1.9 Data Warehouse Characteristics 2.0 Designing a Data Warehouse (1 Hr 11 Mins) 2.1 Analyzing Business Requirements 2.2 The Data Warehousing System 2.3 Comparing Database Modeling Environments 2.5 Using a Star Schema 2.6 Using a Snowflake Schema 2.7 Choosing a Schema 2.8 Choosing a Grain 2.9 Defining
more...
SQL Server 7 0 Data Warehousing Level 1
...ns 1.6 Data Marts 1.7 Know the Flow 1.8 Microsoft Data Warehouse Tools 1.9 Data Warehouse Characteristics 2.0 Designing a Data Warehouse (1 Hr 11 Mins) 2.1 Analyzing Business Requirements 2.2 The Data Warehousing System 2.3 Comparing Database Modeling Environments 2.5 Using a Star Schema 2.6 Using a Snowflake Schema 2.7 Choosing a Schema 2.8 Choosing a Grain 2.9 Defining
more...
SQL Server 7 0 Data Warehousing Level 2
...rehousing Level 2 (1 Hr 48 Mins) 1.0 Building the Data Warehouse (15 Mins) 1.1 Overview 1.2 Build Database 1.3 Build Dimension Tables 1.4 Using Scripts & Building a Fact Table 2.0 Validating and Transforming Data (53 Mins) 2.1 Process Overview 2.2 Methods of Populating a Data Warehouse 2.3 Tools for Populating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query 2.6 bcp
more...
SQL Server 7 0 Data Warehousing Level 3
SQL 7.0 Data Warehousing Level 3 (1 Hr 28 Mins) 1.0 Storing & Processing Cubes (32 Mins) 1.1 MOLAP, ROLAP, & HOLAP Storage Structures 1.2 Comparing ROLAP & MOLAP 1.3 Review & Compare Storage Options 1.4 Storing Partitions & Processing Cubes 1.5 Calculated Members 1.6 The Virtual Cube, Cube Security & Roles 2.0 Analyzing Data Using Clients (28 Mins) 2.1 Navigating Warehouse Data &
more...
From Makau Corporation
SQL Server 7.0

Learn to manage data retrieval and exportation, create advanced queries, control security, configure, replicate, and monitor all information contained within your SQL 7.0 database. Then move on to data warehouse managment, cubes, MDX statements, and much more in the tutorial series for SQL Server 7.0.
12 levels - 224 training modules
more...
