Azure Database for PostgreSQL
Fully managed, intelligent, and scalable PostgreSQL.
Learning
Learning Paths
Build AI Apps with Azure Database for PostgreSQL.
Levels: Intermediate
Roles: Developer
Modules
- Get started with generative AI in Azure Database for PostgreSQL
- Enable semantic search in Azure Database for PostgreSQL
- Summarize data with Azure AI Services and Azure database for PostgreSQL
- Perform sentiment analysis and opinion mining with Azure Database for PostgreSQL
- Extract insights using Azure AI Language and Azure Database for PostgreSQL
- Translate Text with Azure AI Translator and Azure Database for PostgreSQL
- Use Azure Machine Learning for inferencing from Azure Database for PostgreSQL
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
Azure Database for PostgreSQL Flexible Server supports effective data migration from PostgreSQL servers. This module covers both online and offline migration methods and tools, helping you choose the right approach for your scenario. Learn practical techniques for managing migrations efficiently, ideal for minimizing downtime and maintaining productivity.
Azure Database for PostgreSQL efficiently manages vast quantities of data and their structures through system catalogs and views. This module explores how to optimize database performance by accessing and configuring metadata, understanding the role of the vacuum process in maintaining database health, and managing server settings. We introduce practical techniques to enhance your PostgreSQL...
Learn to extract insights using Azure AI Language and Azure Database for PostgreSQL.
Learn to summarize data with Azure AI Services and Azure database for PostgreSQL.
Learn to enable semantic search in Azure Database for PostgreSQL.
Use generative AI in Azure Database for PostgreSQL.
Learn how to perform sentiment analysis and opinion mining with Azure Database for PostgreSQL.
Learn how to use Azure Machine Learning for inferencing from Azure Database for PostgreSQL.
Learn how to translate Text with Azure AI Translator and Azure Database for PostgreSQL.
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.
Relational databases can store vast quantities of data, but they also need to hold information about the structure of that data. For an operational database management system (DBMS) information about the structure of tables, and all other objects, security, and concurrency, amongst many other settings and metrics, is required. This information is know as metadata and is stored in system...