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 courserecognize data partitioning conceptsdescribe data partitioning strategies for different servicescompare transactional and analytical workloads to determine which data store and partitioning strategy to implementrecognize criteria for determining how to partition files for efficient distribution and queryingdescribe 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 queriesdescribe table partitions used by Azure Synapse Analytics and how to size them, and recognize the differences from SQL Serverdescribe when to implement partitioning at the storage layerdescribe how data sharding distributes load over multiple datastoressummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 33sUP NEXT
-
2.Partitioning Data6m 53s
-
3.Data Partitioning Strategies6m 40s
-
4.Transactional and Analytical Workloads6m 35s
-
5.File Partition Strategies6m 5s
-
6.Partitioning Strategies for Table Storage7m 12s
-
7.Designing for Efficiency and Performance8m 12s
-
8.Partitioning Azure Synapse Analytics Dedicated Pools4m 50s
-
9.Partitioning Data Lakes7m
-
10.Data Sharding for Scaling7m 1s
-
11.Course Summary54s
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.