Data Engineering on Microsoft Azure: The Serving Layer

Azure 2021
  • 11 Videos | 1h 8m 38s
  • Includes Assessment
  • Earns a Badge
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
  • Locked
    4. 
    Parquet Files
    4m 59s
  • Locked
    5. 
    Dimensional Hierarchies
    11m 50s
  • Locked
    6. 
    Deploying Azure Synapse Analytics
    4m 51s
  • Locked
    7. 
    Deploying Azure Synapse Analytics Dedicated SQL Pools
    5m 56s
  • Locked
    8. 
    Deploying Azure Synapse Analytics Apache Spark Clusters
    5m 56s
  • Locked
    9. 
    Shared Metadata Tables
    5m 2s
  • Locked
    10. 
    Implementing Shared Metadata Tables
    8m 44s
  • Locked
    11. 
    Course Summary
    56s

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.