Data Warehousing with Azure: Implementing Azure SQL Data Warehouse

Azure    |    Intermediate
  • 11 videos | 1h 7m 17s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 8 users Rating 4.4 of 8 users (8)
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 38s
    After completing this video, you will be able to list the essential features and architectural components of Azure SQL Data Warehouse. FREE ACCESS
  • 6m 11s
    Upon 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
  • Locked
    3.  Creating SQL Data Warehouse
    9m 26s
    In this video, you will learn how to create a Gen2 SQL Data Warehouse on Azure using the portal and PowerShell. FREE ACCESS
  • Locked
    4.  Connect and Query SQL Data Warehouse
    4m 35s
    During 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
  • Locked
    5.  Create and Query SQL Data Warehouse using PowerShell
    6m 30s
    Find out how to create a SQL data warehouse and invoke queries using PowerShell. FREE ACCESS
  • Locked
    6.  Data Warehouse Design
    6m 30s
    After completing this video, you will be able to specify the various steps involved in designing a productive data warehouse solution. FREE ACCESS
  • Locked
    7.  Design and Best Practices for SQL Data Warehouse
    6m 18s
    After completing this video, you will be able to recall the best practices for working with SQL Data Warehouse. FREE ACCESS
  • Locked
    8.  Pause and Resume Functionality
    6m 12s
    In this video, you will learn how to pause and resume SQL Data Warehouse using the portal and PowerShell. FREE ACCESS
  • Locked
    9.  Scale Compute in Azure SQL Data Warehouse
    2m 5s
    In this video, find out how to scale the compute capability of your SQL data warehouse in Azure. FREE ACCESS
  • Locked
    10.  ELT Process for Azure SQL Data Warehouse
    8m 24s
    In this video, find out how to define the steps for implementing ELT for SQL Data Warehouse. FREE ACCESS
  • Locked
    11.  Exercise: Working with SQL Data Warehouse
    4m 31s
    During 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.

YOU MIGHT ALSO LIKE

Course Microsoft Azure Fundamentals: Azure Cloud Computing
Rating 4.6 of 1713 users Rating 4.6 of 1713 users (1713)
Course Microsoft Azure Fundamentals: Managing Azure Storage
Rating 3.0 of 1 users Rating 3.0 of 1 users (1)
Journey Working with Microsoft Azure SQL
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Warehouse Essential: Architecture Frameworks & Implementation
Rating 4.5 of 202 users Rating 4.5 of 202 users (202)
Course Data Types & Normalization
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Course Core DevOps Skills: Moving toward DevOps
Rating 4.5 of 139 users Rating 4.5 of 139 users (139)