Learn 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.
Penetration Testing Team Lead at PerspectaMartin Guidry is a Microsoft Certified Trainer and an authority on topics such as SQL Server and SharePoint.
Martin has over 3,000 hours of classroom experience teaching over 600 students, and he has passed 46 Microsoft Certification exams, which prompted Microsoft to hire him to write future exams. A native of Carencro, Louisiana, Martin earned a bachelor's degree from University of Louisiana, where he pursued graduate work in computer science. Martin has done freelance consulting in software development and database design since 1997.
Skills covered in this course
- [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 files
Download 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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Watch this course anytime, anywhere. Get started with a free trial today.