Data Engineering on Microsoft Azure: Logical Data Structures

Azure 2021    |    Intermediate
  • 11 Videos | 1h 36m 7s
  • 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 course
    define key concepts for maturing data lake storage structures
    describe how system-versioned temporal tables in are used for point-in-time analysis
    create and manage system-versioned temporal tables in an Azure SQL Database
    describe the different types of slowly changing dimensions
    build a slowly changing dimension type 1 deployment
  • build a slowly changing dimension type 2 deployment
    define an effective logical file and folder structure for efficient data ingestion and manipulation
    use PolyBase to build an external table
    describe best practices for accelerating queries against data in Azure Data Lake Storage Gen2
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 27s
    UP NEXT
  • Playable
    2. 
    Data Lake Maturity
    7m 51s
  • Locked
    3. 
    Temporal Database Tables
    7m 10s
  • Locked
    4. 
    Managing Temporal Tables
    10m 59s
  • Locked
    5. 
    Slowly Changing Dimensions
    8m 16s
  • Locked
    6. 
    Building a Slowly Changing Dimension Type 1
    15m 17s
  • Locked
    7. 
    Building a Slowly Changing Dimension Type 2
    15m 49s
  • Locked
    8. 
    Folder Structures
    7m 8s
  • Locked
    9. 
    Using External Tables
    11m 43s
  • Locked
    10. 
    Accelerating Queries
    5m 1s
  • Locked
    11. 
    Course Summary
    58s

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.