Data Engineering on Microsoft Azure: Data Partitioning

Azure 2021
  • 11 Videos | 1h 7m 27s
  • Includes Assessment
  • Earns a Badge
Partitioning data is key to ensuring efficient processing. In this course, you'll explore what data partitioning is and the strategies for implementation. You'll learn about transactional and analytical workloads and how to determine the best strategy for your files and table storage. Then, you'll examine design patterns for efficiency and performance. You'll learn about partitioning dedicated SQL pools in Azure Synapse Analytics and partitioning data lakes. Finally, you'll learn how data sharding across multiple data stores can be used for improving transaction performance. 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 data partitioning concepts
    describe data partitioning strategies for different services
    compare transactional and analytical workloads to determine which data store and partitioning strategy to implement
    recognize criteria for determining how to partition files for efficient distribution and querying
    describe how to partition a table to ensure efficient scalability for analytical workloads
  • describe how the index table and materialized view design patterns can increase efficiency and performance of queries
    describe table partitions used by Azure Synapse Analytics and how to size them, and recognize the differences from SQL Server
    describe when to implement partitioning at the storage layer
    describe how data sharding distributes load over multiple datastores
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 33s
    UP NEXT
  • Playable
    2. 
    Partitioning Data
    6m 53s
  • Locked
    3. 
    Data Partitioning Strategies
    6m 40s
  • Locked
    4. 
    Transactional and Analytical Workloads
    6m 35s
  • Locked
    5. 
    File Partition Strategies
    6m 5s
  • Locked
    6. 
    Partitioning Strategies for Table Storage
    7m 12s
  • Locked
    7. 
    Designing for Efficiency and Performance
    8m 12s
  • Locked
    8. 
    Partitioning Azure Synapse Analytics Dedicated Pools
    4m 50s
  • Locked
    9. 
    Partitioning Data Lakes
    7m
  • Locked
    10. 
    Data Sharding for Scaling
    7m 1s
  • Locked
    11. 
    Course Summary
    54s

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.