Data Engineering on Microsoft Azure: The Serving Layer

Azure 2021    |    Intermediate
  • 11 Videos | 1h 4m 8s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
Implementing an effective serving layer requires consideration for the design, methods, and tools. In this course, you'll learn how traditional relational models can be replaced by the star schema and how to design a star schema. Then, you'll explore the purpose and structure of Parquet files used by Azure Databricks. You'll learn how to design and query a dimensional hierarchy. You'll move on to examine Azure Synapse Analytics, including deploying dedicated SQL pools and Apache Spark clusters. Finally you'll learn how to create shared metadata tables between Spark clusters. This course is one in a collection that prepares learners for the Microsoft Data Engineering on Microsoft Azure (DP-203) exam.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    compare the traditional relational schema model with the modern data lake star schema
    describe the steps required for modeling a star schema
    define what a Parquet file is and how it's structured
    design and query a dimensional hierarchy
    deploy an Azure Synapse Analytics workspace
  • deploy an Azure Synapse Analytics Dedicated SQL pool
    deploy an Azure Synapse Analytics Apache Spark cluster and attach a notebook
    describe how Azure Synapse Analytics shares databases between Spark clusters
    deploy a shared database and a shared metadata table
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 24s
    UP NEXT
  • Playable
    2. 
    Relational and Star Schemas
    7m 14s
  • Locked
    3. 
    Designing a Star Schema Database
    7m 17s
    FREE ACCESS
  • Locked
    4. 
    Parquet Files
    4m 59s
    FREE ACCESS
  • Locked
    5. 
    Dimensional Hierarchies
    11m 50s
    FREE ACCESS
  • Locked
    6. 
    Deploying Azure Synapse Analytics
    4m 51s
    FREE ACCESS
  • Locked
    7. 
    Deploying Azure Synapse Analytics Dedicated SQL Pools
    5m 56s
    FREE ACCESS
  • Locked
    8. 
    Deploying Azure Synapse Analytics Apache Spark Clusters
    5m 56s
    FREE ACCESS
  • Locked
    9. 
    Shared Metadata Tables
    5m 2s
    FREE ACCESS
  • Locked
    10. 
    Implementing Shared Metadata Tables
    8m 44s
    FREE ACCESS
  • Locked
    11. 
    Course Summary
    56s
    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 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

COURSE Data Engineering on Microsoft Azure: Synapse Analytics
Likes 48 Likes 48  
COURSE Data Engineering on Microsoft Azure: Data Solution Optimization
Likes 29 Likes 29  
COURSE Azure Data Scientist Associate: High Availability & Disaster Recovery