Elastic Data Warehousing with Azure SQL Data Warehouse

LP Arrow

Please note: this lab content is in the process of being updated and may contain out of date information. If you have any questions, please do not hesitate to contact us

This lab provides an introduction to Azure SQL Data Warehouse, an elastic data warehouse as a service. SQL Data Warehouse has a “massively parallel” architecture but appears as one database to users. In addition, this lab explores visualizing data with Power BI, another key component of the Cortana Intelligence Suite.

In this lab, you will create a SQL Data Warehouse, load it with sample data, and explore some of its key features including the ability to quickly scale and pause as needed. You will also explore how to load data into your SQL Data Warehouse using T-SQL with PolyBase, then build a report with the data in Power BI.

Download the lab and you’ll learn about:

  • Creating a SQL Data Warehouse using the Azure Portal
  • Accessing your SQL DW database using SQL Server Data Tools / Visual Studio
  • Scaling your SQL DW compute resources up and down
  • Using T-SQL with PolyBase to create an external table with a file on blob storage
  • Using T-SQL to transform and load data
  • Visualizing data with Power BI
  • Deleting a SQL Data Warehouse database

BlueGranite developed this material in conjuction with Microsoft, and the lab and its contents are property of Microsoft. Microsoft holds no legal obligations on quality or performance of the lab material.   Fill out the form below to get access to the step-by-step lab document.  Click here for additional hands-on labs.

download Azure SQL Data Warehouse lab