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

Azure Database for PostgreSQL is a cloud platform-as-a-service 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 deployment options for Azure Database for PostgreSQL and how to configure a server for your needs.

Intermediate - Database Administrator - Azure Database for PostgreSQL

Training Route

• Exploring PostgreSQL Architecture: PostgreSQL is an open-source relational database system that is available as an Azure service. In this module, you will learn about the architecture of PostgreSQL and how to manage different aspects of Azure Database for PostgreSQL.
• Understanding Client-Server Communication in PostgreSQL: PostgreSQL is a client-server system that allows many clients to connect to a central server. In this module, you will learn how PostgreSQL manages client connections and examine some common PostgreSQL client tools.
• PostgreSQL query processing description: Azure Database for PostgreSQL server receives SQL queries and returns relevant results. Each SQL query goes through several stages to return the correct results as quickly as possible.
• Securing Azure Database for PostgreSQL - Azure Database for PostgreSQL includes comprehensive security features such as encryption, authentication, and granting permissions to database users. In this module, you will learn about the security features of Azure Database for PostgreSQL.
• Procedures and Functions in PostgreSQL: PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module, you will learn how to create and execute stored procedures and functions.
• Write-ahead logging description: Azure Database for PostgreSQL is an ACID-compliant database service. Write-ahead logging ensures that changes are atomic and durable. In this module, you will learn how Azure Database for PostgreSQL implements write-ahead logging.
• Configure and manage Azure Database for PostgreSQL: Azure Database for PostgreSQL uses catalogs and system views to effectively manage metadata. Understanding them can significantly improve database performance and simplify the administration of PostgreSQL systems.
• Understanding Concurrency in PostgreSQL: Azure Database for PostgreSQL is a fully managed relational database solution. With increasing user numbers comes a risk of contention, so it's important to understand the concurrency systems in place.
• Query Tuning in Azure Database for PostgreSQL: Database management systems (DBMS) need systems to understand the data and the queries that are run on this data. It is important to understand how performance tuning works and how you can evaluate performance metrics.
• Migrating to Azure Database for PostgreSQL Flexible Server: Azure Database for PostgreSQL Flexible Server supports data migration from PostgreSQL servers. This module covers online and offline migration methods and tools, helping you choose the right approach for your scenario.

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 will learn how to Configure and migrate to Azure Database for PostgreSQL

Applied Skills: Explore all credentials in one guide