- Duration: 3h 6m 40s
- Skill Level: Intermediate
- Released: March 26, 2014
- Viewers: 35,850
Learn the most in-demand business, tech and creative skills from industry experts.
Course detailsLearn how to design and implement an enterprise data warehouse. Microsoft Certified Trainer Martin Guidry shows how to design fact and dimension tables using both the star and snowflake techniques, use data quality services to cleanse data, and implement an ETL process with SQL Server integration services.
- [Voiceover] Hi. This is Martin Guidry, and welcome to Implementing a Data Warehouse with Microsoft SQL Server 2012. In this course, we'll look at designing and building an Enterprise Data Warehouse using Microsoft SQL Server. I'l start off by showing you how to design fact and dimension tables using the star and snowflake techniques. Then I'll show you how to use data quality services to cleanse data, we'll see how to implement an ETL process using SQL Server integration services. We'll cover all these, plus plenty of other tools and techniques; now let's get started with Implementing a Data Warehouse with Microsoft SQL Server 2012.
Practice while you learn with exercise filesDownload the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.Download the exercise files for this course. Get started with a free trial today.
Watch this course anytime, anywhere. Get started with a free trial today.