Implement a Data Warehouse with Azure SQL Data Warehouse

Beginner
Data Engineer
Azure
Azure Portal
Storage
SQL Data Warehouse

Azure SQL Data Warehouse provides a relational big data store that can scale to Petabytes of data. In this learning path, you will learn how Azure SQL Data Warehouse can achieve this scale with its’ Massively Parallel Processing (MPP) architecture. Create a data warehouse in minutes and use familiar querying language to build reports. Load massive amounts of data in minutes, and ensure that your data warehouse is secure.

In this learning path, you will:

  • Learn how to create an Azure SQL Data Warehouse
  • Issue queries and visualize data from an Azure SQL Data Warehouse
  • Import data into Azure SQL Data Warehouse using Polybase
  • Understand the security controls provided by Azure Storage and Azure SQL Data Warehouse

Prerequisites:

None

Modules in this learning path

Design a data warehouse with Azure SQL Data Warehouse

Learn how to create a data warehouse in Azure SQL Data Warehouse in minutes to take advantage of massively parallel processing (MPP) and run complex queries at petabyte scale quickly.

Query data in Azure SQL Data Warehouse

Learn how to issue simple queries against Azure SQL Data Warehouse and how to visualize the data in both Excel and Power BI.

Import data into Azure SQL Data Warehouse by using PolyBase

Load petabytes of data into an Azure SQL Data Warehouse database in minutes by using PolyBase.

Data warehouse security

Learn about the security controls that Azure SQL Data Warehouse provides to help secure your data warehouse infrastructure and the data that's stored in it.