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
    FREE ACCESS
  • Locked
    4. 
    Managing Temporal Tables
    10m 59s
    FREE ACCESS
  • Locked
    5. 
    Slowly Changing Dimensions
    8m 16s
    FREE ACCESS
  • Locked
    6. 
    Building a Slowly Changing Dimension Type 1
    15m 17s
    FREE ACCESS
  • Locked
    7. 
    Building a Slowly Changing Dimension Type 2
    15m 49s
    FREE ACCESS
  • Locked
    8. 
    Folder Structures
    7m 8s
    FREE ACCESS
  • Locked
    9. 
    Using External Tables
    11m 43s
    FREE ACCESS
  • Locked
    10. 
    Accelerating Queries
    5m 1s
    FREE ACCESS
  • Locked
    11. 
    Course Summary
    58s
    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 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: Non-relational Data Management
COURSE Azure Data Fundamentals: Azure Data Ingestion & Processing
COURSE Azure Data Scientist Associate: Non-relational Data Stores