Data Warehousing with Azure: Implementing Azure SQL Data Warehouse

Azure 2018    |    Intermediate
  • 11 videos | 1h 7m 17s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
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

Course Microsoft Azure Infrastructure Solutions: Migrating to Azure
Course Microsoft Azure Infrastructure Solutions: Blob Management
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: Analytics & Reporting
Likes 34 Likes 34  
Course Designing BI Infrastructure
Likes 184 Likes 184  
Course Azure Data Fundamentals: Modern Data Warehousing
Likes 41 Likes 41