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

  • 1m 24s
  • 7m 14s
    d6c2f8f8-12d2-4dac-990a-450a726e2bef FREE ACCESS
  • Locked
    3.  Designing a Star Schema Database
    7m 17s
    051877cf-2ab3-45f2-b333-9b6e417322dc FREE ACCESS
  • Locked
    4.  Parquet Files
    4m 59s
    51d0121b-36a9-4ad2-97a8-6294d9dc3652 FREE ACCESS
  • Locked
    5.  Dimensional Hierarchies
    11m 50s
    ac662b14-276e-491a-9cfc-5c1c5e9c9ec1 FREE ACCESS
  • Locked
    6.  Deploying Azure Synapse Analytics
    4m 51s
    ce426372-f92b-4b7e-8dc9-a4939adb81dc FREE ACCESS
  • Locked
    7.  Deploying Azure Synapse Analytics Dedicated SQL Pools
    5m 56s
    fbb830a4-f08e-4455-8ea1-4cc93e9b7069 FREE ACCESS
  • Locked
    8.  Deploying Azure Synapse Analytics Apache Spark Clusters
    5m 56s
    df1b4f36-5bde-4d72-8e15-be28f39f6226 FREE ACCESS
  • Locked
    9.  Shared Metadata Tables
    5m 2s
    4c2bc56a-d8a1-43f1-9d84-2e6293ce1772 FREE ACCESS
  • Locked
    10.  Implementing Shared Metadata Tables
    8m 44s
    a2b924bc-80a7-4f2b-be91-af4f661d4b8f FREE ACCESS
  • Locked
    11.  Course Summary
    56s
    03afb0e0-2905-435c-aa34-7d8802bd607f 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 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 Data Engineering on Microsoft Azure: Synapse Analytics
Likes 48 Likes 48  
Course Microsoft Azure Fundamentals: Managing Storage
Course Data Engineering on Microsoft Azure: Databricks
Likes 46 Likes 46  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Engineering on Microsoft Azure: Data Process Monitoring
Likes 25 Likes 25  
Course Data Engineering on Microsoft Azure: Data Flow Transformations
Likes 34 Likes 34  
Course Data Engineering on Microsoft Azure: Physical Data Storage Structures
Likes 38 Likes 38