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:
- 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?
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.