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
    FREE ACCESS
  • Locked
    4. 
    Sharding Data
    3m 48s
    FREE ACCESS
  • Locked
    5. 
    Designing Tables
    7m 38s
    FREE ACCESS
  • Locked
    6. 
    Ensuring Database Data Redundancy
    8m 40s
    FREE ACCESS
  • Locked
    7. 
    File and Blob Data Redundancy
    6m 52s
    FREE ACCESS
  • Locked
    8. 
    Implementing Distribution Schemes
    6m 56s
    FREE ACCESS
  • Locked
    9. 
    Implementing Data Archiving
    5m 43s
    FREE ACCESS
  • Locked
    10. 
    Configuring Database Long-term Retention
    4m 38s
    FREE ACCESS
  • Locked
    11. 
    Course Summary
    59s
    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: Storage Accounts
Likes 1 Likes 1  
COURSE Microsoft Azure Fundamentals: Azure Storage
COURSE Data Engineering on Microsoft Azure: Designing Data Storage Structures