Warehousing Level 2 Training on CD-ROM
From 123-CBT Computer Based Training
SQL Server 2000 Data Warehousing Set of 5
... 4.2 Planning a Hierarchy 4.3 Special dimensions Data Warehousing Level 2 1.0 Building a Data Mart 1.1 Creating the Database 1.2 Creating the Fact Table 1.3 Creating Dimension Tables 1.4 Creating Constraints and Indexes 2.0 Loading the Data Mart 2.1 Using Staging Tables 2.2 Using Transact SQL for Data Migration 2.3 Loading Data using Data Transformation Services 2.4 Advanced DTS
more...
SQL Server 7 0 Data Warehousing Set of 4
...ndexes & The Index Tuning Wizard 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
more...
SQL Server 7 0 Data Warehousing Level 2
...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
more...
