DP-3021: Configure and migrate to Azure Database for PostgreSQL

Course DP-3021 Configure and migrate to Azure Database for PostgreSQL

Azure Database for PostgreSQL is a platform-as-a-service cloud database service from Microsoft. It is based on the open-source PostgreSQL relational database and includes built-in high availability, automatic backup and restore, and comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this course, you will learn the core features of PostgreSQL and how they work in Azure Database for PostgreSQL . You will learn about the different Azure Database for PostgreSQL deployment options and how to configure a server for your needs.

Intermediate - Database Administrator - Azure Database for PostgreSQL

DP-3021 Training Objectives

• Configure and manage Azure Database for PostgreSQL, optimizing its performance and ensuring its scalability.
  
• Learn about available deployment options and data migration tools, such as Azure Database Migration Service.
  
• Acquire practical skills to manage PostgreSQL databases in Azure environments
• Develop advanced skills in cloud database security, monitoring, and optimization.

Course content DP-3021

Module 1 Exploring PostgreSQL Architecture

• Description of Azure Database for PostgreSQL.
• PostgreSQL Architecture Description
  
• Description of PostgreSQL shared memory
  
• Exercise: Exploring Azure Database for PostgreSQL

Module 2 Description of client-server communication in PostgreSQL

• Description of connection control
  
• Description of PostgreSQL client tools
  
• Exercise: Exploring PostgreSQL with Client Tools

Module 3: Understanding PostgreSQL Query Processing

• Identifying query processing components
  
• Description of the EXPLAIN instruction
  
• Exercise: Executing the EXPLAIN statement

Module 4 Securing Azure Database for PostgreSQL

• Azure Database for PostgreSQL Security Overview
  
• Description of the built-in Azure Database for PostgreSQL server roles
  
• Granting permissions in Azure SQL Database for PostgreSQL
  
• Understanding Encryption in Azure Database for PostgreSQL
  
• Exercise: Configuring Permissions in Azure Database for PostgreSQL

Module 5 Procedures and Functions in PostgreSQL

• Creating a stored procedure in Azure Database for PostgreSQL
  
• Calling a stored procedure in Azure Database for PostgreSQL
  
• Creating and using a function in Azure Database for PostgreSQL
  
• Exercise: Creating a stored procedure in Azure Database for PostgreSQL

Module 6 Description of the pre-write log

• Description of the pre-write log
  
• Description of replication and logical decoding
  
• Exercise: Enumerating table changes with logical decoding

Module 7 Configure and manage Azure Database for PostgreSQL

• Understand system catalogs and system views
  
• Investigating metadata with system catalogs and system views
  
• Explanation of the purpose of emptying and automatic emptying
  
• Configuring Auto-Drain Server Parameters
  
• Exercise: Configure system parameters and explore metadata with catalogs and system views

Module 8: Understanding Concurrency in PostgreSQL

• Understanding Multi-Version Concurrency Control (MVCC) and Snapshots
  
• Description of isolation levels
  
• Description of the blockade
  
• Exercise: Block Description

Module 9: Query Optimization in Azure Database for PostgreSQL

• Description of statistics
  
• Evaluating query performance with Query Store
  
• Exercise: Evaluating query performance using Query Store

Module 10: Migrating to Azure Database for PostgreSQL Flexible Server

• Comparison between online and offline migrations
  
• Identifying migration tool options
  
• Analysis of decision criteria for tool selection and migration model
  
• Exercise: Offline PostgreSQL Database Migration
  
• Exercise: Online PostgreSQL Database Migration

Prerequisites

Knowledge of relational databases and basic SQL is recommended.

Language

• Course: English / Spanish
  

Microsoft Applied Skills

This course is part of the Microsoft Applied Skills Credentials.

Earn this Microsoft Applied Skills credential. In this course, you'll learn how to configure and migrate to Azure Database for PostgreSQL.

Applied Skills: Explore all credentials in one guide