Configure and migrate to Azure Database for PostgreSQL (DP-3021)

Duration : 1 Day

© AFI Expertise inc.

Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.

Audience

PostgreSQL developers and administrators

Prerequisites

• Demonstrate an understanding of relational databases.
• Demonstrate an understanding of basic SQL.

Contents

• Exploring PostgreSQL architecture
• Understanding client-server communication in PostgreSQL
• Understanding PostgreSQL query processing
• Securing Azure Database for PostgreSQL
• Procedures and functions in PostgreSQL
• Understanding WAL logging
• Configuring and managing Azure Database for PostgreSQL
• Understanding concurrent access in PostgreSQL
• Tuning queries in Azure Database for PostgreSQL
• Migrating to Azure Database for PostgreSQL flexible server