Data Engineering on Microsoft Azure: The Serving Layer

Azure    |    Intermediate
  • 11 videos | 1h 4m 8s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)
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
    Upon completion of this video, you will be able to compare the traditional relational schema model with the modern data lake star schema. FREE ACCESS
  • Locked
    3.  Designing a Star Schema Database
    7m 17s
    After completing this video, you will be able to describe the steps required for modeling a star schema. FREE ACCESS
  • Locked
    4.  Parquet Files
    4m 59s
    Upon reviewing of this video, you will be able to define what a Parquet file is and how it's structured. FREE ACCESS
  • Locked
    5.  Dimensional Hierarchies
    11m 50s
    Discover how to design and query a dimensional hierarchy. FREE ACCESS
  • Locked
    6.  Deploying Azure Synapse Analytics
    4m 51s
    In this video, you will learn how to deploy an Azure Synapse Analytics workspace. FREE ACCESS
  • Locked
    7.  Deploying Azure Synapse Analytics Dedicated SQL Pools
    5m 56s
    Discover how to deploy an Azure Synapse Analytics Dedicated SQL pool. FREE ACCESS
  • Locked
    8.  Deploying Azure Synapse Analytics Apache Spark Clusters
    5m 56s
    In this video, find out how to deploy an Azure Synapse Analytics Apache Spark cluster and attach a notebook. FREE ACCESS
  • Locked
    9.  Shared Metadata Tables
    5m 2s
    After completing this video, you will be able to describe how Azure Synapse Analytics shares databases between Spark clusters. FREE ACCESS
  • Locked
    10.  Implementing Shared Metadata Tables
    8m 44s
    In this video, you will learn how to deploy a shared database and a shared metadata table. FREE ACCESS
  • Locked
    11.  Course Summary
    56s
    In this video, we will summarize the key concepts covered in this course. 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: Designing the Serving Layer
Rating 4.6 of 41 users Rating 4.6 of 41 users (41)
Course Microsoft Azure Infrastructure Solutions: Data Solutions
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Data Engineering on Microsoft Azure: Synapse Analytics
Rating 4.7 of 52 users Rating 4.7 of 52 users (52)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Engineering on Microsoft Azure: Data Partitioning
Rating 4.7 of 49 users Rating 4.7 of 49 users (49)
Course Azure Data Scientist Associate: Azure Data Platform Services
Rating 4.5 of 30 users Rating 4.5 of 30 users (30)
Course Data Engineering on Microsoft Azure: Designing Data Storage Structures
Rating 4.5 of 71 users Rating 4.5 of 71 users (71)