Data Engineering on Microsoft Azure: Designing the Serving Layer
Azure 2021
| Intermediate
- 11 Videos | 1h 12m 1s
- 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 courserecognize the concepts of dimensional data modelingdescribe multidimensional data modeling dimensional hierarchiesdescribe slowly changing dimensions used to capture changing data over time, as well as the various types and their applicationsdescribe temporal databases and steps for designing a database for temporalnessdescribe the differences between the star and snowflake schemes for data modeling
-
recognize the rules and best practices to follow when designing a star schemaimplement incremental data loading using Azure Data Factoryselect the appropriate technology for analytical data storagedescribe the options for storing metadata external to Azure Synapse Analytics and Azure Databrickssummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 31sUP NEXT
-
2.Dimensional Modeling10m
-
3.Dimensional Hierarchies5m 57s
-
4.Slowly Changing Dimensions6m 59s
-
5.Temporal Design5m 54s
-
6.Star and Snowflake Schemas11m 9s
-
7.Designing a Star Schema5m 16s
-
8.Implementing Incremental Data Loading11m 11s
-
9.Choosing an Analytical Data Store8m 7s
-
10.Metastore Design5m 4s
-
11.Course Summary53s
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.