Always be learning. Invest in you.
Personalized learning experiences, courses taught by real-world professionals.
Start my 1-month free trial

Implementing a Data Warehouse with Microsoft SQL Server 2012

Course by: Martin Guidry
Implementing a Data Warehouse with Microsoft SQL Server 2012 Watch preview
  • Course details

    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.

    Instructor

    • Martin Guidry

      Martin Guidry

      Penetration Testing Team Lead at Perspecta
      View on LinkedIn

      Martin 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.

      View all courses by Martin Guidry
  • Welcome

    - [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.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents