Skip to main content

Delivering a Relational Data Warehouse Microsoft

About This Course

This computer science course from Microsoft provides learners with the knowledge and skills required to design, implement, and load a relational data warehouse. In this four week course, you’ll learn how to analyze business requirements, design dimension and fact tables, index and partition the data for performance, and create ETL solutions for ongoing loading of the warehouse.

This course is taught with short-form lectures, demonstrations, and interviews with industry experts. Quizzes and hands-on labs, using Microsoft SQL Server 2016 and Azure SQL Database, will help to reinforce your knowledge, practice skills, and solve problems.

What you'll learn

  • Map business reporting requirements to logical data entities
  • Design dimension and fact tables in a star schema
  • Indexing and partitioning strategies to provide performance and scale
  • Load the data warehouse with Extract, Transform, and Load (ETL) techniques

Course Staff

Course Staff Image #1

Peter Myers

Consultant, Trainer and Presenter

Microsoft

Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services. He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.

Course Staff Image #2

Chris Randall

Senior Content Developer, Microsoft Learning Experiences

Microsoft

Chris is a trainer, consultant, and author with 25 years of industry experience, specializing in SQL Server and the Microsoft data platform. He is a Microsoft Certified Solutions Expert for the SQL Server Data Platform and Business Intelligence, and works in the Microsoft Learning Experiences team as a senior content developer, where he plans and creates content for developers and data professionals who want to get the best out of Microsoft technologies.

  1. Course Number

    DAT216x
  2. Classes Start

Enroll