|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? Discover the answers to these questions and others as you create functioning data warehouses. Take the mystery out of data warehouse design through simple examples and by learning complex jargon in everyday terms. Learn star and snowflake schemas, fact and dimension table designs, measures and dimensional attributes, and more. Microsoft SQL Server is used, but the concepts learned are applicable to all database software. Prerequisites: SQL Programming Level 2 or equivalent knowledge. Textbook included ($50 value).