SQLTraining Data Warehousing
 When you complete this course you will feel prepared to
design your own database. Topics include security, connectivity, tables, constraints, indexes, queries, OLE DB & ODBC, maintenance, operators, indexes, data transfers and error logs. SQL 2000 Training
- Administration levels 1-4 cover requirements for Exam 70-028
- Implementation levels 1-4 cover requirements for Exam 70-029
See our SQL Server 7.0 Implementing a Database Design Course
Also available:
Crystal Reports
Learn to create reports from your database and integrate with SQL.
SQL 7 Data Warehousing Training for Programming Video Course
MCSD SQL Server Database Implementation 7.0 Training
CD-ROMs and Videos Details
|
Data Warehousing - 4 Video Set Description
|
kysqdwa
|
$329.95
|
|
|
Database Implementation - 4 Video Set
|
kysq7a
|
$329.95
|
|
|
All Eight Videos (4 Data Warehousing and 4 Database Implementation Videos)
|
kysq7d
|
$599.95
|
|
|
Database Implementation - 4 CD Set
|
kysq7am
|
$329.95
|
|
SQL 7 Data Warehousing Video Training Course
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
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
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
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
|
