Data Warehousing with Azure: Implementing Azure SQL Data Warehouse Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description Explore the practical implementation of Azure SQL Data Warehouse. Examine how to design, model, and apply ELT approaches of extracting loads and transforming data.
Expected Duration (hours)
1.1
Lesson Objectives Data Warehousing with Azure: Implementing Azure SQL Data Warehouse
list the essential features and architectural components of Azure SQL Data Warehouse
specify the distributed management system and the workload management system of Azure SQL data warehouse
demonstrate how to create Gen2 SQL Data Warehouse on Azure using the portal and PowerShell
connect and submit queries to SQL Data Warehouse using SQL Operations Studio and SSMS
demonstrate the steps of creating a SQL data warehouse and invoking queries using PowerShell
specify the various steps involved in designing a productive data warehouse solution
recall the best practices that should be adopted when working with SQL Data Warehouse
demonstrate how to pause and resume SQL Data Warehouse using the portal and PowerShell
scale the compute capability of SQL data warehouse in Azure
define the steps for implementing ELT for SQL Data Warehouse
connect to PowerShell and create SQL Data Warehouse using PowerShell
Course Number: it_dfdwaz_02_enus
Expertise Level
Intermediate