Azure SQL DW (Audio) - Channel 9

In this short video, learn how BI and BA professionals can transfer existing skills in the world of data science and the Cortana Intelligence Suite. This video shares the perspective of Chris Testa-O'Neill as he makes the transition from BI professional to a Data Science career.

This video will cover the key concepts of Azure SQL Data Warehouse and the Massively Parallel Processing architecture. At the end of this session you will also be able to create an Azure SQL Data Warehouse. Scale and pause a Database and understand the concepts that drive Massively Parallel Processing.

In this video, you will explore the different methods for loading data into a Data Warehouse and have a clear understanding of the efficient method to load. You will also understand the role of a "load user" and why it is important to create a dedicated account for loading. You will also learn how to import and export data and integrate Azure SQL Data Warehouse with Azure Data Factory.

In this video, you will be able to create a database and tables within an Azure SQL Data Warehouse. The content will also explore the key considerations such as partitions, indexes and statistics. You will gain a firm understanding of distribution and how you can influence how the data is spread across a Massively Parallel Processing architecture.