|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Data Warehousing Level 2 |
 |
Training
Provided by 123-CBT Computer Based Training
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 Utility and the BULK INSERT Statement
2.7 Data Transformation Services (DTS)
2.8 Transferring a File Using DTS
2.9 Transforming Data by Using an ActiveX Script
2.10 Transforming Data by Using a Lookup Query
2.11 Defining Transactions
2.12 Tracking Data Lineage
2.13 Creating a DTS Package Programmatically
3.0 The DTS Utility (9 Mins)
3.1 Combing Previous Techniques into one DTS Package
4.0 Cubes (30 Mins)
4.1 OLAP Manager
4.2 Introduction to Cubes
4.3 Cube Structure & Components
4.4 Identifying a Fact Table
4.5 Private VS Shared Dimensions
4.6 Managing Aggregations
4.7 Incorporating a Fact Table & Dimensions into a Cube
SQL 7.0 Data Warehousing 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 Utility and the BULK INSERT Statement
2.7 Data Transformation Services (DTS)
2.8 Transferring a File Using DTS
2.9 Transforming Data by Using an ActiveX Script
2.10 Transforming Data by Using a Lookup Query
2.11 Defining Transactions
2.12 Tracking Data Lineage
2.13 Creating a DTS Package Programmatically
3.0 The DTS Utility (9 Mins)
3.1 Combing Previous Techniques into one DTS Package
4.0 Cubes (30 Mins)
4.1 OLAP Manager
4.2 Introduction to Cubes
4.3 Cube Structure & Components
4.4 Identifying a Fact Table
4.5 Private VS Shared Dimensions
4.6 Managing Aggregations
4.7 Incorporating a Fact Table & Dimensions into a Cube
|
|
||||||||
SQL Server 7 0 Data Warehousing Level 2
--
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
-...
