Data Engineering on Microsoft Azure: Designing the Serving Layer
Azure
| Intermediate
- 11 videos | 1h 11m 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 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
-
1m 31s
-
10mFind out how to recognize the concepts of dimensional data modeling. FREE ACCESS
-
3. Dimensional Hierarchies5m 57sUpon reviewing of this video, you will be able to describe multidimensional data modeling dimensional hierarchies. FREE ACCESS
-
4. Slowly Changing Dimensions6m 59sAfter completing this video, you will be able to describe slowly changing dimensions used to capture changing data over time, as well as the various types and their applications. FREE ACCESS
-
5. Temporal Design5m 54sAfter reviewing this video, you will be able to describe temporal databases and steps for designing a database for temporalness. FREE ACCESS
-
6. Star and Snowflake Schemas11m 9sUpon completion of this video, you will be able to describe the differences between the star and snowflake schemes for data modeling. FREE ACCESS
-
7. Designing a Star Schema5m 16sIn this video, learn how to recognize the rules and best practices to follow when designing a star schema. FREE ACCESS
-
8. Implementing Incremental Data Loading10m 11sIn this video, discover how to implement incremental data loading using Azure Data Factory. FREE ACCESS
-
9. Choosing an Analytical Data Store8m 7sDuring this video, you will learn how to select the appropriate technology for analytical data storage. FREE ACCESS
-
10. Metastore Design5m 4sAfter completing this video, you will be able to describe the options for storing metadata external to Azure Synapse Analytics and Azure Databricks. FREE ACCESS
-
11. Course Summary53sIn 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.
