Course Locations
Anaheim, CA
Atlanta, GA
Austin, TX
Baltimore, MD
Boston, MA
Burbank, CA
Calgary, AB
Charleston, SC
Charlotte, NC
Chicago, IL
Columbia, MD
Columbus, OH
Dallas-Ft Worth, TX
Denver, CO
Detroit, MI
Edison, NJ
El Paso, TX
Framingham, MA
Houston, TX
Kansas City, MO
Lansing, MI
Los Angeles, CA
Minneapolis, MN
Ottawa, ON
Pittsburgh, PA
Toronto, ON
Virtual Classroom
Popular Courses
Project Management, IT Service Management, .NET, SAS, Rexx, ASP, JavaScript, HTML, XML, ColdFusion, Visual Basic, COBOL, Assembler, Java, J2EE, Java Wireless, WebSphere, WebLogic, UNIX, LINUX, AIX, Solaris, z/OS, OS/390, CICS, IMS, VSAM, Easytrieve, AS/400, Oracle, BusinessObjects, SQL, DB2, Crystal Reports
Browse Courses
 |
 |
 |
 |
 |
Course Schedule: | |
Relational and Dimensional Data Warehouse Design
Summary:
This course provides students with the skills necessary to design a successful data warehouse using both relational and dimensional data modeling techniques.
Duration:
3 Days/Lecture & Lab
Audience:
This course is targeted at technical staff, team leaders and project managers who need to understand how to design a data warehouse using both relational (Bill Inmon style) and dimensional (Ralph Kimball style) data warehousing design techniques.
Topics:
- Introduction
- Fundamental Relational Concepts
- Understanding the Business Model
- Developing the Model
- Creating and Maintaining Keys
- Modeling the Calendar
- Modeling Hierarchies
- Modeling Transactions
- Data Warehouse Optimization
- Accommodating Business Change
- Maintaining the Models
- Deploying the Relational Solution
- Comparison of Data Warehouse Methodologies
Prerequisites:
Students should have some knowledge of how to design a data base through at least third normal form (3NF) as well as some knowledge of how to code Structured Query Language (SQL).
Last Update: May 24, 2013
