Data Warehousing Terms, Concepts and Architecture

Course:   DWHTCA
Duration:   1 Day
Level:   I
On our website at:   http://www.verhoef-training.com/courses/DWHTCA.html
 
Course Summary

This Data Warehouse terminologies and concepts course addresses the following topics:

Topics Covered In This Course

DATA WAREHOUSE OVERVIEW

  • Overview
  • Typical uses
  • Architecture

DEFINITION, ARCHITECTURE AND CONCEPTS

  • Enterprise Data Model
  • Operational vs. historical data
  • Extract Transform Load (ETL)
  • Metadata
  • Data warehouse vs. data mart
  • Data mining
  • OLAP vs. OLTP
  • Logical design vs. physical design
  • Normalization vs. denormalization
  • Referential constraints

DATA MODELLING OPTIONS & OVERVIEW

  • Entity model
  • Star schema
  • Snowflake schema

MULTIDIMENSIONAL DESIGN

  • Overview
  • Metadata properties
  • Star schema
  • Snowflake schema
  • Cube
  • Measures and facts
  • Attributes and relationships
  • Dimension
  • Hierarchies
  • Joins
  • Summary tables and aggregation (i.e., materialized views)

IMPLEMENTATION OPTIONS

  • Overview
  • Top down
  • Bottom up
  • Sizing
  • Cleaning
  • Populating the data warehouse

PHYSICAL DESIGN CONSIDERATIONS

  • Denormalization
  • Index choices
  • Data placement
  • Free space
  • Summary tables
  • Data compression

DATA WAREHOUSE PERFORMANCE DESIGN

  • Large concurrent reports
  • Short running queries
  • Long running queries
  • On-line utilities
  • Partitioning and parallelism (e.g., LOADs)
  • Table spaces and buffer pools

INTRODUCTION TO STATISTICS, ANALYTIC AND OLAP SQL QUERIES

  • AVG
  • CORRELATION
  • COUNT
  • COUNT_BIG
  • CONVARIANCE
  • MAX
  • RAND
  • SUM
  • VARIANCE
  • Regression function
  • GROUPING, ROLLUP & CUBE

INTRODUCTION TO DW GUI TOOLS

What You Can Expect

Upon completion of this course, the participant should be conversant with terms and concepts as these relate to a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc.

Related Courses
Code Course Title Duration Level
DWCONI
Introduction to Data Warehouse Concepts
1 Day
I
Details
DWHFUN
Data Warehousing Fundamentals
3 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.