Data Warehousing with Azure: Implementing Azure SQL Data Warehouse

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

  • Playable
    1. 
    Azure SQL Data Warehouse Features and Architecture
    6m 38s
    UP NEXT
  • Playable
    2. 
    MPP and Workload Management
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 214 Likes 214  
Likes 85 Likes 85  
Likes 993 Likes 993