Data Warehousing Terms, Concepts and Architecture

Course:  DWHTCA
Duration:  1 Day
Level:  I
Course Summary

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

  • What is data warehousing?
  • What is a data mart?
  • What are the data modelling options?
  • What are the terms and concepts specific to data warehousing and OLAP design?
  • What are some common statistics, analytic and OLAP SQL queries?
« Hide The Details
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.

« Hide The Details
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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]