Course Overview

This course is designed for database administrators, PostgreSQL developers, and cloud architects who are either new or already familiar with PostgreSQL and want to enhance their skills in managing and optimizing PostgreSQL databases in Azure. It is ideal for those looking to migrate workloads to the cloud, improve database performance and implement security best practices.

After completing this course, students will be able to:

  • Understand the architecture and components of Azure Database for PostgreSQL.
  • Perform efficient database migrations from on-premises or other platforms to Azure Database for PostgreSQL.
  • Monitor and optimize query performance using tools like the Query Store and pg_stat_statements.
  • Secure your PostgreSQL instance using encryption, firewall rules, and role-based access.
  • Understand PostgreSQL’s query processing.
  • Understand write-ahead logging.
  • Understand PostgreSQL’s system catalog and views and the vacuum process.
  • Understand concurrency in PostgreSQL.

Upcoming Batches

Loading Dates...

Key Features:

  • PostgreSQL Architecture:Detailed understanding of PostgreSQL architecture and its operation within Azure.

  • Client-Server Communication:Insights into how PostgreSQL manages client connections and exploration of common client tools.

  • Query Processing:In-depth knowledge of SQL query processing and optimization techniques.

  • Security Features:Implementation of security features such as encryption, authentication, and permissions.

  • Stored Procedures and Functions:Creation and management of stored procedures and functions for reusable SQL queries.

  • Write-Ahead Logging:Understanding write-ahead logging mechanisms to ensure data integrity.

  • Configuration and Management:Configuration and management of Azure Database for PostgreSQL using system catalogs and views.

  • Concurrency:Exploration of concurrency systems and how PostgreSQL handles multiple users.

  • Query Tuning:Techniques for optimizing query performance.

  • Migration:Steps and best practices for migrating databases to Azure Database for PostgreSQL flexible server.

Who should Attend?

  • This course is designed for database administrators, PostgreSQL developers, and cloud architects who are either new or already familiar with PostgreSQL and want to enhance their skills in managing and optimizing PostgreSQL databases in Azure. It is ideal for those looking to migrate workloads to the cloud, improve database performance and implement security best practices.

Prerequisites:

  • Experience with relational databases.
  • Basic knowledge of SQL

    • Why Choose CloudThat as Your Training Partner?

    • Expert Instructors: CloudThat’s instructors are highly experienced and certified professionals with in-depth knowledge of Databricks and data engineering principles. They provide top-notch training and guidance throughout the preparation process.
    • Comprehensive Course Content: CloudThat offers a well-structured and comprehensive course curriculum that covers all the essential topics needed to excel.
    • Hands-on Labs: CloudThat emphasizes hands-on learning through practical exercises and real-world scenarios, allowing candidates to gain practical experience.
    • Flexibility: CloudThat offers flexible training options, including online and in-person classes, allowing candidates to choose the mode of learning that suits their schedule and preferences.
    • Track Record: CloudThat has a proven track record of success in training and preparing candidates for various cloud and data certifications.

    Learning objectives of the course

    • Explore PostgreSQL Architecture: Understand the architecture of PostgreSQL and its operation within Azure.
    • Client-Server Communication: Learn how PostgreSQL manages client connections and explore common client tools.
    • Query Processing: Gain insights into SQL query processing and optimization techniques
    • Security Features: Implement security features such as encryption, authentication, and permissions
    • Stored Procedures and Functions: Create and manage stored procedures and functions for reusable SQL queries
    • Write-Ahead Logging: Understand write-ahead logging mechanisms to ensure data integrity
    • Configuration and Management: Configure and manage Azure Database for PostgreSQL using system catalogs and views.
    • Concurrency: Explore concurrency systems and how PostgreSQL handles multiple users
    • Query Tuning: Learn techniques for optimizing query performance
    • Migration: Understand steps and best practices for migrating databases to Azure Database for PostgreSQL flexible server

    Course Outline Download Course Outline

    • Lab: Explore Azure Database for PostgreSQL

    • Lab: Explore PostgreSQL with client tools

    • Lab: Execute the EXPLAIN statement

    • Lab: Configure permissions in Azure Database for PostgreSQL

    • Lab: Create a stored procedure in Azure Database for PostgreSQL

    • Lab: List table changes with logical decoding

    • Lab: Configure system parameters and explore metadata with system catalogs and views

    • Lab: Understand locking

    Certification details:

        Candidates who successfully complete the "Configure and Migrate to Azure Database for PostgreSQL" training are awarded a certificate of course completion. Earning the Microsoft Azure PostgreSQL Applied Skill Credential validates your ability to configure, manage, and migrate PostgreSQL databases to Azure.
        In this 1-day course, you will learn how to set up and manage Azure Database for PostgreSQL, configure performance settings, and implement secure and efficient database operations. You will also gain hands-on experience in migration strategies and concurrency management using built-in Azure tools.
        This applied skills credential can be a stepping stone toward more advanced or role-based Azure certifications focused on data and infrastructure management.
        Candidates also receive an official Microsoft credential upon successfully passing the Azure Database for PostgreSQL Applied Skills assessment.

    Click to Zoom

    Select Course date

    Loading Dates...
    Add to Wishlist

    Course ID: 25167

    Course Price at

    Loading price info...
    Enroll Now

    FAQs :

    The DP-3021 certification is titled "Configure and Migrate to Azure Database for PostgreSQL." It focuses on configuring and migrating databases to Azure's PostgreSQL service.

    Basic understanding of relational databases and SQL is recommended

    The course is a 1-day program available in multiple languages including English, Chinese, French, German, Japanese, Portuguese, and Spanish

    Topics include PostgreSQL architecture, client-server communication, query processing, security features, stored procedures and functions, write-ahead logging, configuration and management, and concurrency management.

    Skills include configuring and managing Azure Database for PostgreSQL, migrating databases to Azure, implementing security measures, optimizing query performance, and managing database concurrency and transactions.

    The cost is approximately $1,495 USD.

    Salaries can vary widely based on location and experience, but professionals with this certification can expect to earn between $80,000 to $120,000 USD annually.

    Yes, it is recognized globally and is highly valued in the IT industry.

    Yes, the course is available in virtual instructor-led formats.

    Benefits include enhanced career opportunities, improved technical skills, and recognition as a certified expert in Azure Database for PostgreSQL.

    Enquire Now