Opleiding: Configure and migrate to Azure Database for PostgreSQL (DP-3021) [M-DP3021]

OVERVIEW

OBJECTIVES

Students will learn to,

• 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
• Configure and manage Azure Database for PostgreSQL
• Understand concurrency in PostgreSQL
• Tune queries in Azure Database for PostgreSQL
• Migrate to Azure Database for PostgreSQL flexible server

CONTENT

Explore PostgreSQL architecture

• Describe the architecture of PostgreSQL.
• Describe the options for creating an Azure Database for PostgreSQL server.
• Understand PostgreSQL shared memory.

Understand client-server communication in PostgreSQL

• Understand connection handling.
• Understand the PostgreSQL client tools.

Understand PostgreSQL query processing

• Identify the query processing components.
• Understand EXPLAIN.

Secure Azure Database for PostgreSQL

• Describe the security features of Azure Database for PostgreSQL.
• Create database users and grant permissions.
• Understand encryption in Azure Database for PostgreSQL.

Procedures and functions in PostgreSQL

• Create a stored procedure in Azure Database for PostgreSQL.
• Call a stored procedure in Azure Database for PostgreSQL.
• Create and use a function in Azure Database for PostrgreSQL.

Understand write-ahead logging

• Describe write-ahead logging.
• Describe replication and logical decoding.

Configure and manage Azure Database for PostgreSQL

• Describe system catalogs and system views in Azure Database for PostgreSQL.
• Investigate metadata in Azure Database for PostgreSQL.
• Explain the purpose of the vacuum process.
• Configure vacuum server parameters.

Understand concurrency in PostgreSQL

• Describe Multi-Version Content Control and snapshots in Azure Database for PostgreSQL.
• Describe isolation levels in Azure Database for PostgreSQL.
• Describe locking in Azure Database for PostgreSQL.

Tune queries in Azure Database for PostgreSQL

• Describe statistics in Azure Database for PostgreSQL.
• Assess query performance with the Query Store.

Migrate to Azure Database for PostgreSQL flexible server

• Understand the different online and offline migration options.
• Identify the different migration tools available.
• Select the appropriate migration tool for your specific scenario.