SQL 7.0 Data Warehousing Set of Four Training Videos

SQL 7.0 Data Warehousing Level 1 (1 Hour 41 Minutes)

1.0 Prerequisites (28 Minutes)
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 Hour 11 Minutes)
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 2 (1 Hour 48 Minutes)

1.0 Building the Data Warehouse (15 Minutes)
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 Minutes)
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 Minutes)
3.1 Combing Previous Techniques into one DTS Package
4.0 Cubes (30 Minutes)
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 3 (1 Hour 28 Minutes)

1.0 Storing & Processing Cubes (32 Minutes)
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 Minutes)
2.1 Navigating Warehouse Data & Data Mining
2.2 Local Cubes
2.3 OLAP Manager & Excel 2000
2.4 Publishing to the Web
2.5 Creating Local Cubes with Excel 2000
3.0 MDX Statements (27 Minutes)
3.1 What is MDX?
3.2 The MDX SELECT Statement
3.3 Axes
3.4 Sets
3.5 Functions
3.6 Additional Set Functions
3.7 Tuples
3.8 Slicer Dimensions
3.9 Calculated Members

SQL 7.0 Data Warehousing Level 4 (1 Hour 32 Minutes)

1.0 Building OLAP Clients (27 Minutes)
1.1 Overview of Client/Server Architecture
1.2 ADO MD, Catalog Object & Cubedef Object
1.3 Retrieving Data About Cubes & Using Cellsets
1.4 Creating Local Cubes through MDX & ADO MD
2.0 Microsoft English Query (35 Minutes)
2.1 Introduction to Microsoft English Query
2.2 Domains, Entities, & Relationships
2.3 Database Normalization
2.4 Identify Schema & Defining Entities
2.5 Setting Up Schema & Entities
2.6 Build Test Application for Queries
2.7 Multi-dimensional Databases & Deployment
3.0 Maintaining & Managing (29 Minutes)
3.1 Synchronization & Maintenance
3.2 Cubes
3.3 Backing Up and Restoring
3.4 Automating Tasks
3.5 Dimensions
3.6 Optimization
3.7 Partitions

Regular price: $359.95padSale price: $339.95

Click here for Secure Yahoo Order: SQL 7.0 Data Warehousing Set of Four Training Videospad

Get Train in SQL
SQL Software Training

Best Regards,
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.