Massively Parallel Processing with ADW (Azure Data Warehouse) (17491)

Last Modified 2017-04-11

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. In this learning path, modules are arranged in order, left to right, top row first.