Data Engineering on Microsoft Azure: Designing the Serving Layer

Azure 2021    |    Intermediate
  • 11 Videos | 1h 16m 31s
  • Includes Assessment
  • Earns a Badge
The serving layer is where data is stored for consumption by processing services. In this course, you'll explore dimensional data modeling and hierarchies. You'll learn how to define slowly changing dimensions and temporal design within databases. Then, you'll learn about the differences between the star and snowflake schemas as well as how to design a star schema. Next, you'll examine incremental data loading for stream processing and the options for analytical data stores. Finally, you'll learn about options for creating metastores for use by Azure Databricks and Azure Synapse Analytics. 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
    recognize the concepts of dimensional data modeling
    describe multidimensional data modeling dimensional hierarchies
    describe slowly changing dimensions used to capture changing data over time, as well as the various types and their applications
    describe temporal databases and steps for designing a database for temporalness
    describe the differences between the star and snowflake schemes for data modeling
  • recognize the rules and best practices to follow when designing a star schema
    implement incremental data loading using Azure Data Factory
    select the appropriate technology for analytical data storage
    describe the options for storing metadata external to Azure Synapse Analytics and Azure Databricks
    summarize the key concepts covered in this course

IN THIS COURSE

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 Azure Data Fundamentals: Azure Data Ingestion & Processing
COURSE Azure Data Fundamentals: Azure Analytics Workloads
COURSE Data Engineering on Microsoft Azure: Synapse Analytics
Likes 1 Likes 1