Data Engineering on Microsoft Azure: Physical Data Storage Structures
Azure 2021
| Intermediate
- 11 Videos | 1h 4m 43s
- Includes Assessment
- Earns a Badge
An effective storage structure is critical to big data implementation success. In this course, you'll explore data compression in databases and file storage. Then, you'll discover how partitioning and sharding are implemented in the database. Next, you'll explore designing tables in an Azure Synapse Analytics dedicated SQL pool, and implement geo-replication for redundancy in both databases and Azure Blob storage. You'll also discover implementing distribution schemes in Azure Synapse Analytics. Finally, you'll discover data archiving and long-term retention policies for Azure Blob storage and Azure SQL Databases. 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 coursedefine considerations for implementing data compression technologies at the database and file levelcreate a data partition in a SQL databasedescribe how a shard map manager is used by an application to connect to the required Azure SQL Databasesdescribe the key concepts for designing tables in an Azure Synapse Analytics dedicated SQL pooldeploy Azure SQL Database geo-replication
-
describe the options for redundancy in Azure Blob storagedetermine the appropriate distribution scheme for an Azure Synapse Analytics database and build it into the table on creationarchive data in Azure storage and rehydrate it when necessaryconfigure a long-term retention policy for an Azure SQL Databasesummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 25sUP NEXT
-
2.Data Compression4m 46s
-
3.Partitioning Data13m 18s
-
4.Sharding Data3m 48s
-
5.Designing Tables7m 38s
-
6.Ensuring Database Data Redundancy8m 40s
-
7.File and Blob Data Redundancy6m 52s
-
8.Implementing Distribution Schemes6m 56s
-
9.Implementing Data Archiving5m 43s
-
10.Configuring Database Long-term Retention4m 38s
-
11.Course Summary59s
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.