This course discusses the role of the modern data warehouse and draws the distinction between Traditional, Operational and Logical data warehouses. It then positions the main data warehouse options provided by Microsoft, specifically SQL Server 2016, Azure Data Warehouse and Azure Data Lake. It then goes on to discuss in more detail the following topics: SQL Data Warehouse topology and architecture, Data warehouse, Database design, ETL, Data movement and distribution theory using SQL Data Warehouse, Big data and SQL Server integration with PolyBase, BI integration with Power BI & Azure Machine Learning.
This learning path will help you prepare for the training requirements for the Data Platform MPN Competency. For guidance on accessing Partner University please see our FAQ https://partner.microsoft.com/en-us/training/assets/collection/faqs-partner-university#/