Data Engineering on Microsoft Azure: Data Partitioning

Azure 2021    |    Intermediate
  • 11 Videos | 1h 2m 57s
  • 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
    FREE ACCESS
  • Locked
    4. 
    Transactional and Analytical Workloads
    6m 35s
    FREE ACCESS
  • Locked
    5. 
    File Partition Strategies
    6m 5s
    FREE ACCESS
  • Locked
    6. 
    Partitioning Strategies for Table Storage
    7m 12s
    FREE ACCESS
  • Locked
    7. 
    Designing for Efficiency and Performance
    8m 12s
    FREE ACCESS
  • Locked
    8. 
    Partitioning Azure Synapse Analytics Dedicated Pools
    4m 50s
    FREE ACCESS
  • Locked
    9. 
    Partitioning Data Lakes
    7m
    FREE ACCESS
  • Locked
    10. 
    Data Sharding for Scaling
    7m 1s
    FREE ACCESS
  • Locked
    11. 
    Course Summary
    54s
    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 Data Engineering on Microsoft Azure: Databrick Processing
COURSE Data Engineering on Microsoft Azure: Designing Data Storage Structures
COURSE Data Science Solution on Azure: Data Solution Optimization
Likes 1 Likes 1