Data Engineering on Microsoft Azure: Physical Data Storage Structures

Azure 2021    |    Intermediate
  • 11 Videos | 1h 9m 13s
  • 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 course
    define considerations for implementing data compression technologies at the database and file level
    create a data partition in a SQL database
    describe how a shard map manager is used by an application to connect to the required Azure SQL Databases
    describe the key concepts for designing tables in an Azure Synapse Analytics dedicated SQL pool
    deploy Azure SQL Database geo-replication
  • describe the options for redundancy in Azure Blob storage
    determine the appropriate distribution scheme for an Azure Synapse Analytics database and build it into the table on creation
    archive data in Azure storage and rehydrate it when necessary
    configure a long-term retention policy for an Azure SQL Database
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 25s
    UP NEXT
  • Playable
    2. 
    Data Compression
    4m 46s
  • Locked
    3. 
    Partitioning Data
    13m 18s
  • Locked
    4. 
    Sharding Data
    3m 48s
  • Locked
    5. 
    Designing Tables
    7m 38s
  • Locked
    6. 
    Ensuring Database Data Redundancy
    8m 40s
  • Locked
    7. 
    File and Blob Data Redundancy
    6m 52s
  • Locked
    8. 
    Implementing Distribution Schemes
    6m 56s
  • Locked
    9. 
    Implementing Data Archiving
    5m 43s
  • Locked
    10. 
    Configuring Database Long-term Retention
    4m 38s
  • Locked
    11. 
    Course Summary
    59s

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.