Business Intelligence Certificate Programs
|Data Warehouse Design (1.2 CEUs)
What's the difference between a standard database and a data warehouse database? What is a Star or Snowflake schema? In this class you will find the answers to these questions and others as you create functioning data warehouses. By using simple examples and explaining complex jargon in everyday terms this class will take the mystery out of data warehouse design. Topics include; Star and Snowflake schemas, Fact and Dimension table designs, Measures and Dimensional attributes, and much more. This class will be taught using Microsoft SQL server, the concepts learned are applicable to all database software. Prerequisites: SQL Programming Level 2 or equivalent knowledge. Textbook included ($50 value).