Eccentrix IT trainings - Microsoft, CompTIA, PeopleCert, PECB
Eccentrix IT trainings - Microsoft, CompTIA, PeopleCert, PECB

Eccentrix - Trainings catalog - Microsoft - Azure - Configure and migrate to Azure Database for PostgreSQL (DP-3021)

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

Azure Database for PostgreSQL is a high-performance PaaS database service available in the Microsoft cloud. It builds on the open-source PostgreSQL relational database and integrates native high availability, automatic backup and restore, as well as advanced security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling.

In this comprehensive learning path, you will master the key features of PostgreSQL and their optimized implementation in Azure Database for PostgreSQL. You will explore the different implementation options for Azure Database for PostgreSQL and learn to configure a server tailored to your specific business needs.

  • Duration: 1 day / 7 hours
Details

Related trainings

Exclusives

  • Technical lab: Available for 180 days of online access
  • Class material: Complete and up to date with Microsoft Learn
  • Proof of attendance: Digital badge for completing the official Microsoft course
  • Fast and guaranteed schedule: Maximum wait of 4 to 6 weeks after participant registrations, guaranteed date
Eccentrix - Microsoft Learning Partner logo

Private class

Reserve this training exclusively for your organization with pricing adapted to the number of participants. Our pricing for private training is determined based on the size of your group, with a minimum number of participants required for the training to be held.

  • Volume-based pricing discount according to the number of participants
  • Training delivered in an environment dedicated to your team
  • Scheduling flexibility according to your availability
  • Enhanced interaction among colleagues from the same organization
  • Same exclusive benefits as our public training sessions

How to get a proposal?

Use the request form by specifying the number of participants. We will quickly send you a complete quote with the exact pricing, available dates, and details of all the benefits included in your private training.

Ask for a proposal

Configure and Migrate to Azure Database for PostgreSQL DP-3021 Training Plan: Detailed Modules

  • Describe Azure Database for PostgreSQL
  • Understand PostgreSQL architecture
  • Understand PostgreSQL shared memory
  • Exercise – Explore Azure Database for PostgreSQL
  • Understand connection handling
  • Understand the PostgreSQL client tools
  • Exercise – Explore PostgreSQL with client tools
  • Identify the query processing components
  • Understand the EXPLAIN statement
  • Exercise – Execute the EXPLAIN statement
  • Describe Azure Database for PostgreSQL security
  • Describe built-in Azure Database for PostgreSQL server roles
  • Grant permissions in Azure SQL Database for PostgreSQL
  • Understand encryption in Azure Database for PostgreSQL
  • Exercise: Configure permissions in Azure Database for 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 PostgreSQL
  • Exercise – Create a stored procedure in Azure Database for PostgreSQL
  • Describe write ahead logging
  • Describe replication and logical decoding
  • Exercise – List table changes with logical decoding
  • Understand the system catalogs and system views
  • Investigate metadata with system catalogs and system views
  • Explain the purpose of vacuum and autovacuum
  • Configure autovacuum server parameters
  • Exercise – Configure system parameters and explore metadata with system catalogs and views
  • Understand multi-version concurrency control (MVCC) and snapshots
  • Describe isolation levels
  • Understand locking
  • Exercise – Understand locking
  • Understand statistics
  • Assess query performance with the Query Store
  • Exercise – Assess query performance using Query Store
  • Compare online and offline migrations
  • Identify migration tool options
  • Analyze the decision criteria for tool selection and migration model
  • Exercise – Offline PostgreSQL database migration
  • Exercise – Online PostgreSQL database migration

Recommended prerequisite knowledge

  • Demonstrate an understanding of relational databases.
  • Demonstrate an understanding of basic SQL.

Credentials and certification

Features

  • Preparatory training for obtaining a Microsoft Applied Skills credential.
  • Performance is assessed through an interactive remote lab.
  • Duration: 120 minutes
  • Cost: $0

Assessment’s technical tasks

  • Migrate a database to Azure Database for PostgreSQL
  • Configure high availability, replication, and disaster recovery
  • Configure and optimize database performance
  • Configure identity and access

View all assessment details on Microsoft Learn >>

Azure Database PostgreSQL Configuration Training

The Azure Database PostgreSQL Configuration training is designed to empower IT professionals with the knowledge and skills needed to implement robust PostgreSQL database solutions in Microsoft Azure. This course provides an in-depth understanding of Azure Database for PostgreSQL capabilities, including setting up high availability, creating migration strategies, and analyzing performance to optimize the reliability and efficiency of database resources.

By mastering Azure Database for PostgreSQL, participants can ensure proactive management of their database environments, enabling efficient detection and resolution of issues.

Why Take This Training?

Effectively configuring PostgreSQL database resources is critical to maintaining performance and availability. Azure Database for PostgreSQL is a comprehensive solution for tracking, diagnosing, and optimizing PostgreSQL resources. This training provides the expertise to configure and utilize Azure Database for PostgreSQL for advanced insights and operational efficiency.

Participants will learn how to set up automated alerts, customize monitoring solutions, and leverage analytics to improve the resilience of their database infrastructure.

Skills Developed During Training

  1. Setting Up Azure Database for PostgreSQL
    Learn how to deploy Azure Database for PostgreSQL to oversee the performance and health of your database resources.

  2. Customizing High Availability and Notifications
    Master the creation of high availability configurations for key metrics and events to enable proactive issue management.

  3. Utilizing Replication and Disaster Recovery
    Explore how to analyze telemetry data and logs for actionable insights using Azure Database for PostgreSQL’s powerful tools.

  4. Building Custom Dashboards
    Design dashboards that consolidate critical information and provide real-time insights into database performance.

  5. Integrating with Azure Services
    Discover how to integrate Azure Database for PostgreSQL with other Azure services like Azure Monitor and Azure Backup.

  6. Implementing Best Practices in Database Management
    Gain expertise in optimizing configurations to ensure cost-effective and reliable PostgreSQL database management.

Interactive, Practice-Oriented Training

Led by certified Azure experts, this course combines theoretical knowledge with practical exercises. Participants will work on real-world scenarios to apply Azure Database for PostgreSQL features effectively, ensuring readiness for professional challenges.

Who Should Attend?

  • Database administrators managing PostgreSQL resources
  • IT professionals responsible for database performance monitoring and diagnostics
  • Systems architects designing scalable and reliable database solutions
  • Anyone interested in learning advanced PostgreSQL management techniques for Azure

Enhance Your Azure Management with PostgreSQL Expertise

The Configure and Migrate to Azure Database for PostgreSQL (DP-3021) training equips you with the skills needed to leverage Azure Database for PostgreSQL for optimizing your database operations. Enroll now to master advanced PostgreSQL management techniques and ensure the resilience and efficiency of your Azure environment.

Frequently Asked Questions - Azure Database PostgreSQL Training (FAQ)

It covers deployment, configuration, high availability, dashboards, database analytics, and integration with other Azure services.

Basic understanding of Azure and PostgreSQL database concepts is recommended but not mandatory.

Yes, the course features practical labs and real-world scenarios for applying Azure Database for PostgreSQL skills.

It enables proactive database management, continuous performance monitoring, and advanced protection of PostgreSQL resources.

Yes, it integrates seamlessly with Azure Monitor, Azure Backup, and other Azure database services.

Absolutely, the training covers optimization strategies and best practices for effective PostgreSQL management.

Request form for a private class training

Dear Customer,

We thank you for your interest in our services. Here is the important information that will be provided to us upon completion of this form:

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

Language: English

Duration: 1 day / 7 hours

Number of participants from your organization *

Minimum number of participants: 6

Organization name *
Your first and last name *
Telephone number *
Professional email *
Please provide a work or professional email address.
How did you hear about us? *
Comments or Remarks
The General Conditions are accessible on this page.

Eccentrix IT trainings - Microsoft, CompTIA, PeopleCert, PECB
Eccentrix IT trainings - Microsoft, CompTIA, PeopleCert, PECB

Our website uses cookies to personalize your browsing experience. By clicking ‘I accept,’ you consent to the use of cookies.

I accept
Details