Model data for Azure Cosmos DB for PostgreSQL

Module
11 Units

Beginner

Developer

Azure

Azure Cosmos DB

Azure Cosmos DB for PostgreSQL provides a highly scalable distributed relational database solution, reliably and securely managed on Azure. To effectively model data for distributed tables in Azure Cosmos DB for PostgreSQL, data usage and distribution must be taken into consideration.

Learning objectives

In this module, you will:

Identify key considerations for modeling data for Azure Cosmos DB for PostgreSQL.
Classify tables in Azure Cosmos DB for PostgreSQL.
Create tables within an Azure Cosmos DB for PostgreSQL cluster.
Alter tables within an Azure Cosmos DB for PostgreSQL cluster.

Prerequisites

Basic familiarity with relational databases
An active Azure subscription

Introduction min
Classify tables based on processing min
Exercise - Create tables in Azure Cosmos DB for PostgreSQL min
Scaffold data for distribution min
Exercise - Create scaffolding in Azure Cosmos DB for PostgreSQL min
Partition time series data min
Exercise - Create time series partitions min
Alter scaffolding in a distributed environment min
Exercise - Alter scaffolding in Azure Cosmos DB for PostgreSQL min
Knowledge check min
Summary min