Azure Database for PostgreSQL
Fully managed, intelligent, and scalable PostgreSQL.
Learning
Learning Paths
Azure Database for PostgreSQL
Levels: Beginner
Roles: Administrator, Developer, Solution Architect, Student
Modules
Azure Cosmos DB for PostgreSQL provides a highly scalable distributed relational database solution, reliably and securely managed on Azure.
Levels: Beginner
Roles: Developer
Modules
Work with Azure Database for PostgreSQL
Levels: Intermediate
Roles: Database Administrator
Modules
- Explore PostgreSQL architecture
- Understand client-server communication in PostgreSQL
- Understand PostgreSQL query processing
- Secure Azure Database for PostgreSQL
- Procedures and functions in PostgreSQL
- Understand write-ahead logging
- Use system catalogs and system views in PostgreSQL
- Understand concurrency in PostgreSQL
- Optimize vacuum in Azure Database for PostgreSQL
- Tune queries in Azure Database for PostgreSQL
Learning Modules
Learn how to use Azure Database for PostgreSQL, a fully managed relational database solution. Create and develop a database, and query it from an ASP.NET app.
Azure Database for PostgreSQL is a multi-user relational database solution. The ability to support many concurrent users enables PostgreSQL databases to scale out and enable applications that support many users and locations at the same time. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place in Azure Database for...
PostgreSQL is an open-source relational database system that is now available as a service in Azure. In this module you will learn about the PostgreSQL architecture, and how to manage different aspects of PostgreSQL in Azure Database for PostgreSQL.
Learn how to deploy an application built with the Python framework Django.
Learn how to scale and rebalance data, create read replicas, and enable high availability on an Azure Cosmos DB for PostgreSQL cluster.
Create a Quarkus application, connect it to a PostgreSQL database, and then deploy to Azure Container Apps.
Azure Database for PostgreSQL includes comprehensive security features including encryption in transit and at rest, authentication, and granting permissions to database users. In this module you will learn about the security features of Azure Database for PostgreSQL, and how to configure them.
The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible. In this module you will learn about the different stages of processing a query, as well as the EXPLAIN statement.
Understand how data is distributed across Azure Cosmos DB for PostgreSQL to efficiently ingest and query data across the cluster.
PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module you will learn how PostgreSQL manages connections from clients, as well as looking at some common PostgreSQL client tools.
Build cloud-native apps with Azure Database for PostgreSQL for the most compatibility.
PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module you will learn how to create and run stored procedures and functions.