Student Profile: Individuals involved in Data Warehousing who are not familiar with the concepts and techniques.

Course Duration: Three days.

Prerequisites: None.

Course Objectives: This course follows an outline that provides an in-depth examination of the technical perspectives of a data warehouse project. What is the right type of DW? How will the ETL process be executed? What degree of auditing is necessary and how will that be carried out? It will start with gaining a clear understanding of the business drivers behind building a data warehouse and use these as guidelines for many of the technical decisions.

The course is presented in a discussion, lecture and exercise format. Extensive student participation is built in to the class. Instructors make every attempt to incorporate student projects into the training materials. Concepts are reinforced through the use of team lab exercises.

Outline:
Introduction to Data Warehousing
Business Drivers
Determining the Scope
Terminology
Methodology
Information Requirements
Deliverables
Dimensional Data Structure Design
Data Cube
Operational Data Modeling
Dimensional Data Modeling
Granularity of Data
Special Issues
Extract, Transform and Load
Sourcing Data
Data Staging
Data Cleansing
Quality Assurance and Auditing
Scheduling
Accessing the Data
Categorizing Access
Business Intelligence
The Web and Internet
Related Topics
OLAP, ROLAP, MOLAP, HOLAP
Metadata
Continuous Improvement

Participants will learn how to create queries and modify database tables and views using SQL. SQL and database efficiency are examined along with the appropriate use of indexes.