|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Data Warehousing Level 1 |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 Course Prerequisites
1.2 System Setup
1.3 Defining Data Warehousing
1.4 Operational & Analytical Systems
1.5 Comparing Transactional and Data Warehousing Solutions
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 Dimension Characteristics
2.10 Defining Conventional Dimensions
2.11 Sharing Dimensions
2.12 Defining other Types of Dimensions
2.13 Defining the Fact Table
2.14 Defining Pre-calculations
2.15 Minimizing the Fact Table Size & Balancing Size & Performance
2.16 Estimating Size of the Data Warehouse
2.17 Creating a Database
2.18 Creating Constraints
2.19 Creating Indexes & The Index Tuning Wizard
SQL 7.0 Data Warehousing Level 1 (1 Hr 41 Mins)
1.0 Prerequisites (28 Mins)1.1 Course Prerequisites
1.2 System Setup
1.3 Defining Data Warehousing
1.4 Operational & Analytical Systems
1.5 Comparing Transactional and Data Warehousing Solutions
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 Dimension Characteristics
2.10 Defining Conventional Dimensions
2.11 Sharing Dimensions
2.12 Defining other Types of Dimensions
2.13 Defining the Fact Table
2.14 Defining Pre-calculations
2.15 Minimizing the Fact Table Size & Balancing Size & Performance
2.16 Estimating Size of the Data Warehouse
2.17 Creating a Database
2.18 Creating Constraints
2.19 Creating Indexes & The Index Tuning Wizard
|
|
||||||||
SQL Server 7 0 Data Warehousing Level 1
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
