Data Warehousing with Azure: Implementing Azure SQL Data Warehouse

Azure 2018    |    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 38s
  • 6m 11s
  • Locked
    3.  Creating SQL Data Warehouse
    9m 26s
  • Locked
    4.  Connect and Query SQL Data Warehouse
    4m 35s
  • Locked
    5.  Create and Query SQL Data Warehouse using PowerShell
    6m 30s
  • Locked
    6.  Data Warehouse Design
    6m 30s
  • Locked
    7.  Design and Best Practices for SQL Data Warehouse
    6m 18s
  • Locked
    8.  Pause and Resume Functionality
    6m 12s
  • Locked
    9.  Scale Compute in Azure SQL Data Warehouse
    2m 5s
  • Locked
    10.  ELT Process for Azure SQL Data Warehouse
    8m 24s
  • Locked
    11.  Exercise: Working with SQL Data Warehouse
    4m 31s

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

Book Mapping Data Flows in Azure Data Factory: Building Scalable ETL Projects in the Microsoft Cloud
Course Microsoft Azure Infrastructure Solutions: Data Solutions
Book Pro Serverless Data Handling with Microsoft Azure: Architecting ETL and Data-Driven Applications in the Cloud

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Warehousing with Azure: Data Lake Implementation Using Azure
Course Data Warehouse Essential: Concepts
Course Data Warehousing with Azure: Managing Azure Data Lake