Data Warehousing with Azure: Implementing Azure SQL Data Warehouse
Azure
| Intermediate
- 11 videos | 1h 7m 17s
- Includes Assessment
- Earns a Badge
Explore the practical implementation of Azure SQL Data Warehouse. Examine how to design, model, and apply ELT approaches of extracting loads and transforming data.
WHAT YOU WILL LEARN
-
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
IN THIS COURSE
-
6m 38sAfter completing this video, you will be able to list the essential features and architectural components of Azure SQL Data Warehouse. FREE ACCESS
-
6m 11sUpon completion of this video, you will be able to specify the distributed management system and the workload management system of Azure SQL Data Warehouse. FREE ACCESS
-
3. Creating SQL Data Warehouse9m 26sIn this video, you will learn how to create a Gen2 SQL Data Warehouse on Azure using the portal and PowerShell. FREE ACCESS
-
4. Connect and Query SQL Data Warehouse4m 35sDuring this video, you will learn how to connect and submit queries to SQL Data Warehouse using SQL Operations Studio and Microsoft SQL Server Management Studio. FREE ACCESS
-
5. Create and Query SQL Data Warehouse using PowerShell6m 30sFind out how to create a SQL data warehouse and invoke queries using PowerShell. FREE ACCESS
-
6. Data Warehouse Design6m 30sAfter completing this video, you will be able to specify the various steps involved in designing a productive data warehouse solution. FREE ACCESS
-
7. Design and Best Practices for SQL Data Warehouse6m 18sAfter completing this video, you will be able to recall the best practices for working with SQL Data Warehouse. FREE ACCESS
-
8. Pause and Resume Functionality6m 12sIn this video, you will learn how to pause and resume SQL Data Warehouse using the portal and PowerShell. FREE ACCESS
-
9. Scale Compute in Azure SQL Data Warehouse2m 5sIn this video, find out how to scale the compute capability of your SQL data warehouse in Azure. FREE ACCESS
-
10. ELT Process for Azure SQL Data Warehouse8m 24sIn this video, find out how to define the steps for implementing ELT for SQL Data Warehouse. FREE ACCESS
-
11. Exercise: Working with SQL Data Warehouse4m 31sDuring this video, you will learn how to connect to PowerShell and create a SQL Data Warehouse using PowerShell. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
