DP-3021 Configure and migrate to Azure Database for PostgreSQL

Price
Net: €
VAT: €

Price
Price on Request

Duration
1 day

For companies and job seekers:
this course is 100% fundable!

Location

Course Language
English

Training Solutions
Online Live

Request a consultation Add to favorites Print as PDF

The move to the cloud places new demands on databases and their operation. Azure Database for PostgreSQL combines flexibility, security, and scalability, enabling modern data strategies on a stable technical foundation.

Key topics

Setting up and managing PostgreSQL services in Azure.
Migration planning and technical implementation
Security and compliance aspects
Monitoring, maintenance, and performance optimization
Concepts for high availability and data backup

Prerequisites
Knowledge of SQL, experience with PostgreSQL or similar systems, and basic knowledge of cloud technologies.

Target audience
Database administrators, cloud engineers, and technical specialists responsible for planning and operating databases.

The content taught promotes the secure use of PostgreSQL in Azure and supports the development of robust, modern database solutions for dynamic IT landscapes.

Print as PDF

Course content

PostgreSQL Architecture

Description of Azure Database for PostgreSQL:
Understanding PostgreSQL architecture
Learn about PostgreSQL shared storage

Client-server communication

Understanding connection handling
Exploring the PostgreSQL client tools

PostgreSQL query processing

Understanding query processing components
Understanding the EXPLAIN statement

Secure Azure databases

Security in Azure Database for PostgreSQL
Role description for Azure Database for PostgreSQL servers
Assigning access rights in Azure SQL Database for PostgreSQL
Understanding encryption in Azure Database for PostgreSQL

Processes and functions

Storing a procedure in Azure Database for PostgreSQL
Calling a procedure in Azure Database for PostgreSQL
Creating and using a function in Azure Database for PostgreSQL

Write-ahead logging

Explanation of proactive write logging
Describe replication and logical decoding

Azure Database for PostgreSQL

Understanding system catalogs and views
Analyzing metadata through system catalogs and views
Explaining the purpose of vacuum and autovacuum
Configuring autovacuum parameters

Concurrency in PostgreSQL

Understanding MVCC and Snapshots
Explaining isolation levels
Understanding locks

Queries in Azure Database

Analysis of statistics
Evaluation of query performance based on memory

Migration to Azure Database

Comparison of online and offline migrations
Options for migration tools
Analysis of criteria for tool and migration model selection

Your training will be 100% funded

Our funding schemes are available exclusively to participants who live or work in Germany. Funding is not available outside Germany.

For career starters, job seekers, career changers, startups, experienced professionals, those looking to advance their careers, specialists, etc.

The QCG program for everyone in the company

Further information

The education voucher for all job seekers

Further information

Frequently Asked Questions

Why is PostgreSQL becoming increasingly important in the cloud?

PostgreSQL is one of the most popular open-source databases and is increasingly being used for modern cloud applications. This training course shows how to operate PostgreSQL securely and efficiently as Azure Database for PostgreSQL.

What are the main areas of focus for the continuing education program?

The focus is on configuring Azure Database for PostgreSQL, security features, performance optimization, high availability, and planning and executing database migrations to the Azure cloud.

Why is migrating to the cloud more than just a data transfer?

A successful migration takes into account availability, performance, security, and downtime. This training course teaches participants how to select appropriate migration strategies and use Azure tools efficiently.

Which immigration procedures are covered?

This training course compares online and offline migrations, as well as various tools for migrating existing PostgreSQL databases to Azure. This enables participants to select the appropriate migration path for different scenarios.

Why Are Performance and Monitoring Part of Continuing Education?

After a migration, databases must operate reliably and efficiently over the long term. That is why this training course covers query optimization, system catalogs, monitoring, and performance analysis in Azure Database for PostgreSQL.

What safety features are covered?

A key focus is on authentication, permissions, encryption, and other security features of Azure Database for PostgreSQL. This allows you to reliably protect databases and better meet compliance requirements.

Why is high availability important for PostgreSQL?

Business-critical applications require databases with high reliability. This training course teaches participants how to implement backup, recovery, and high-availability strategies in Azure Database for PostgreSQL.

What professional responsibilities does this continuing education program support?

The course content is designed to help you plan, migrate, administer, and optimize PostgreSQL databases in Microsoft Azure, and prepares you for typical tasks in modern cloud projects.

Do you have any further questions? Please contact us.

Select your nearest center: *

0800 258 258 055

website@newhorizons.de

First Name *

Surname *

Telephone Number *

Postcode *

E-Mail *

I would like to receive funding for further training – I am currently: *

Company Name

Your message

I hereby confirm that I have taken note of the privacy notice. *