Provided by: 123-CBT Computer Based Training

SQL Server 7 0 Data Warehousing Level 2

Click here for more information or to take this course

Search for Training

Find Your Genius!

Training Provided by 123-CBT Computer Based Training

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

Training Avaliability and Delivery

This is primarily cdrom training
	This program may be available on CD
	Contact 123-CBT Computer Based Training for more information

Training Presented in:

English

Related Keywords: microsoft sql server 7.0 databases enterprise microsoft information technology

Training Program Details

About 123-CBT Computer Based Training - Training Provider

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 - Dreamweaver MX -...

More Microsoft SQL Server 7 0 Training from 123-CBT Computer Based Training

Click here for more information or to take this course

Custom Search

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/19/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you a Microsoft sql server 7.0 training provider?

You could be on this page today - for FREE!