Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Azure Database for PostgreSQL

Microsoft via Microsoft Learn

Overview

  • Module 1: This module is a no-code introduction to PostgreSQL on Azure, including an explanation of particular problems that using Azure Database for PostgreSQL can solve. At a high level, we show how the components fit together and identify situations where you should use Azure Database for PostgreSQL.
  • In this module, you will:

    • Describe the components of Azure Database for PostgreSQL.
    • Identify situations when to use Azure Database for PostgreSQL.
  • Module 2: Azure Database for PostgreSQL is a fully managed relational database solution. Learn how - and when - to use it. You’ll review different configurations and features, create and develop a database, and query it from an ASP.NET app.
  • In this module, you will:

    • Create an Azure Database for PostgreSQL instance using the Azure portal
    • Develop and query the database in the Azure Cloud Shell using pgsql
    • Query the PostgreSQL database from an ASP.NET app
  • Module 3: When your database is small, it’s easy to throw more hardware at the problem and scale up. As these tables grow, you need to think about other ways to scale your database. Azure Database for PostgreSQL Hyperscale (Citus) transforms open-source PostgreSQL into a distributed database solution, reliably and securely managed on Azure.
  • In this module, you will:

    • Create a Hyperscale instance of Azure Database for PostgreSQL
    • Automatically shard and distribute tables in Hyperscale
    • Scale and rebalance a Hyperscale database without downtime

Syllabus

  • Module 1: Introduction to Azure Database for PostgreSQL
    • Introduction
    • What is Azure Database for PostgreSQL?
    • What is Hyperscale?
    • How Azure Database for PostgreSQL works
    • When to use Azure Database for PostgreSQL
    • Knowledge check
    • Summary
  • Module 2: Create and connect to an Azure Database for PostgreSQL
    • Introduction
    • Creating a database with Azure Database for PostgreSQL
    • Exercise - Create a database with Azure Database for PostgreSQL
    • Connect to your database
    • Exercise - Create a basic database schema
    • Connect to a database from your app
    • Exercise - Use a database in your app
    • Knowledge check
    • Summary
  • Module 3: Introduction to Hyperscale (Citus) on Azure Database for PostgreSQL
    • Introduction
    • Creating a database with Azure Database for PostgreSQL
    • Exercise - Create a Hyperscale database with Azure Database for PostgreSQL
    • How to design a distributed database
    • Exercise - Create distributed tables
    • Scale up and scale out
    • Exercise - Scale and rebalance your database
    • Knowledge check
    • Summary

Reviews

Start your review of Azure Database for PostgreSQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.