Data Engineering on Microsoft Azure: Logical Data Structures
Azure 2021
| Intermediate
- 11 Videos | 1h 31m 37s
- Includes Assessment
- Earns a Badge
Logical data structures, also called entity-relationship models, are models used to define a high-level model of data and the relationships contained within. In this course, you'll learn about the stages of data lake maturity. You'll explore temporal database tables and how to manage them. You'll also learn how to define slowly changing dimensions and how to implement them. You'll then move on to explore logical file and folder structures for data ingestion. You'll discover how PolyBase can be used to connect to external tables. Finally, you'll explore the best practices for accelerating queries. This course is one in a collection that prepares learners for the Data Engineering on Microsoft Azure (DP-203) exam.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this coursedefine key concepts for maturing data lake storage structuresdescribe how system-versioned temporal tables in are used for point-in-time analysiscreate and manage system-versioned temporal tables in an Azure SQL Databasedescribe the different types of slowly changing dimensionsbuild a slowly changing dimension type 1 deployment
-
build a slowly changing dimension type 2 deploymentdefine an effective logical file and folder structure for efficient data ingestion and manipulationuse PolyBase to build an external tabledescribe best practices for accelerating queries against data in Azure Data Lake Storage Gen2summarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 27sUP NEXT
-
2.Data Lake Maturity7m 51s
-
3.Temporal Database Tables7m 10s
-
4.Managing Temporal Tables10m 59s
-
5.Slowly Changing Dimensions8m 16s
-
6.Building a Slowly Changing Dimension Type 115m 17s
-
7.Building a Slowly Changing Dimension Type 215m 49s
-
8.Folder Structures7m 8s
-
9.Using External Tables11m 43s
-
10.Accelerating Queries5m 1s
-
11.Course Summary58s
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.