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

Ref. DP-3021

Download PDF

Duration:

1

day

Exam:

Not certifying

Level:

Intermediate

Funding:

Eligible

Home > Trainings > IT Pro > Cloud Computing > Configure and migrate to Azure Database for PostgreSQL (DP-3021)

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

Learn to configure and migrate databases with Azure Database for PostgreSQL

Managing cloud databases is essential to ensure the performance of information systems. The DP-3021 training course teaches you how to leverage Azure Database for PostgreSQL to manage your data efficiently and securely. This PaaS service combines the flexibility of the cloud with the robustness of PostgreSQL, offering advanced features to optimize data storage, processing, and security.

A professional training course for database administrators

This hands-on course guides you through configuring a PostgreSQL server, managing client-server connections, and processing SQL queries. You will learn how to improve query performance using analysis and logging tools while ensuring data security through encryption and permissions management. The program also includes creating stored procedures and functions to automate recurring operations.

Participant Profiles

Database administrators
Cloud engineers
Back-end developers
Cloud solutions architects

Objectives

Configure Azure Database for PostgreSQL
Manage client-server communication
Optimize SQL query processing
Ensure database security
Create and use stored procedures
Understand WAL logging
Manage concurrent access
Migrate to the Azure flexible server

Prerequisites

Master relational databases
Have basic SQL knowledge
Understand cloud computing principles

Course Content

Module 1: Explore PostgreSQL architecture

Describe Azure Database for PostgreSQL
Understand PostgreSQL architecture
Understand PostgreSQL shared memory
Explore Azure Database for PostgreSQL

Module 2: Understand client-server communication in PostgreSQL

Understand connection handling
Use PostgreSQL client tools
Explore PostgreSQL with client tools

Module 3: Understand PostgreSQL query processing

Identify query processing components
Use the EXPLAIN statement
Execute the EXPLAIN statement

Module 4: Secure Azure Database for PostgreSQL

Describe Azure Database for PostgreSQL security
Describe built-in server roles
Grant permissions to database users
Understand data encryption
Configure permissions in Azure Database for PostgreSQL

Module 5: Procedures and functions in PostgreSQL

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

Module 6: Understand write-ahead logging

Describe write-ahead logging
Understand replication
Understand logical decoding
List table changes with logical decoding

Module 7: Configure and manage Azure Database for PostgreSQL

Understand system catalogs and views
Investigate metadata using system catalogs and views
Explain the purpose of vacuum and autovacuum
Configure autovacuum server parameters
Configure system parameters and explore metadata

Module 8: Understand concurrency in PostgreSQL

Understand multi-version concurrency control (MVCC)
Describe snapshots
Describe isolation levels
Understand locking
Explore locking in PostgreSQL

Module 9: Tune queries in Azure Database for PostgreSQL

Understand statistics
Assess query performance using Query Store

Module 10: Migrate to Azure Database for PostgreSQL flexible server

Compare online and offline migrations
Identify migration tool options
Analyze decision criteria for tool selection
Select the appropriate migration model
Perform offline PostgreSQL database migration
Perform online PostgreSQL database migration

Documentation

Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Develop your database management skills with DP-3021

Mastering relational databases is essential to ensure the performance and security of information systems. The DP-3021 training offers practical learning to configure, optimize, and migrate databases using Azure Database for PostgreSQL. This cloud service combines the robustness of PostgreSQL with the flexibility of Azure, enabling businesses to manage their data efficiently while ensuring high availability.

Understand the architecture and optimize performance

To ensure optimal performance, it is crucial to understand PostgreSQL architecture. This training teaches you how to configure a server, manage shared memory, and optimize SQL query processing. You will learn to analyze queries using the EXPLAIN statement to identify bottlenecks and improve execution speed. Using system catalogs and system views also allows you to monitor and adjust server settings to maintain consistent performance.

Ensure security and manage concurrent access

Data security is a priority for all businesses. Azure Database for PostgreSQL offers advanced features to protect data from unauthorized access. This course shows you how to configure built-in roles, grant permissions to users, and encrypt data to ensure confidentiality. Concurrent access management relies on multi-version concurrency control (MVCC), which allows multiple users to access the same data without conflicts. You will also learn to use locking to prevent simultaneous modifications that could compromise data integrity.

Automate tasks and ensure data durability

To improve operational efficiency, it is essential to automate recurring tasks. Creating stored procedures and functions allows you to reuse code blocks, simplifying query processing. WAL logging plays a key role in data durability by recording all changes before they are applied, ensuring data recovery in case of failure. This feature is crucial for maintaining service continuity and minimizing interruptions.

Migrate your databases to the cloud with Azure

Migrating to the Azure flexible server for PostgreSQL offers numerous benefits, including rapid scaling and a pay-as-you-go model that reduces infrastructure costs. This training covers different migration methods, both online and offline, and helps you choose the best approach based on your needs. You will learn to use Azure migration tools to transfer your data securely and seamlessly, ensuring a smooth transition to the cloud.

FAQ

What are the prerequisites for taking the DP-3021 course?

To follow this course, it is recommended to master relational databases, have basic SQL knowledge, and understand cloud computing principles.

Who is this course intended for?

This course is primarily designed for database administrators, cloud engineers, back-end developers, and cloud solutions architects.

What are the main benefits of Azure Database for PostgreSQL?

This service offers high availability, advanced security, and near-instant scalability. Its pay-as-you-go model reduces costs while ensuring optimal performance.

What tools are used for database migration?

The course introduces several Azure migration tools, suitable for both online and offline transfers, allowing you to select the most appropriate solution based on the size and complexity of the data.

Does this course include practical exercises?

Yes, the course includes practical exercises and case studies to help you apply your knowledge in real-world scenarios and enhance your database management skills.