{"id":25166,"date":"2025-06-11T07:21:46","date_gmt":"2025-06-11T07:21:46","guid":{"rendered":"https:\/\/stage.cloudthat.com\/training\/?post_type=stm-courses&p=25166"},"modified":"2025-06-16T13:51:11","modified_gmt":"2025-06-16T13:51:11","slug":"dp-3021-configure-and-migrate-to-azure-database-for-postgresql","status":"publish","type":"stm-courses","link":"https:\/\/stage.cloudthat.com\/training\/azure\/dp-3021-configure-and-migrate-to-azure-database-for-postgresql","title":{"rendered":"DP-3021: Configure and migrate to Azure Database for PostgreSQL"},"content":{"rendered":"

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.<\/p>\n","protected":false},"excerpt":{"rendered":"

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.<\/p>\n","protected":false},"author":5091,"featured_media":0,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[62],"metadata":{"stm_lms_product_id":["25167"],"_edit_lock":["1755097854:4526"],"_edit_last":["1508"],"permalink_customizer":["azure\/dp-3021-configure-and-migrate-to-azure-database-for-postgresql"],"permalink_customizer_regenerate_status":["1"],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"banner_image":[""],"_banner_image":["field_621873548f922"],"banner_description":["Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs."],"_banner_description":["field_612c733ed3564"],"overview_section_heading":["Course Overview"],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["After completing this course, students will be able to: "],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course_0_desciption":["Understand the architecture and components of Azure Database for PostgreSQL. "],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Perform efficient database migrations from on-premises or other platforms to Azure Database for PostgreSQL."],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Monitor and optimize query performance using tools like the Query Store and pg_stat_statements. \r\n"],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Secure your PostgreSQL instance using encryption, firewall rules, and role-based access.\r\n"],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course_4_desciption":["Understand PostgreSQL\u2019s query processing. \r\n"],"_after_completing_course_4_desciption":["field_6103ad2f9f5b2"],"after_completing_course":["8"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Key Features: "],"_key_features_heading":["field_645388ceffdd1"],"key_features_0_lists":["PostgreSQL Architecture:Detailed understanding of PostgreSQL architecture and its operation within Azure."],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["Client-Server Communication:Insights into how PostgreSQL manages client connections and exploration of common client tools."],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["Query Processing:In-depth knowledge of SQL query processing and optimization techniques."],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["Security Features:Implementation of security features such as encryption, authentication, and permissions."],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features":["10"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who should Attend?"],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend_0_attend_lists":["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. "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"who_should_attend":["1"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["Prerequisites:"],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["

  • Experience with relational databases.<\/li>\r\n
  • Basic knowledge of SQL<\/li>\r\n"],"_prerequisites_text":["field_612c7498c4b84"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["Why Choose CloudThat as Your Training Partner?"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list_0_list":["Expert Instructors: CloudThat\u2019s 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. "],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["Comprehensive Course Content: CloudThat offers a well-structured and comprehensive course curriculum that covers all the essential topics needed to excel."],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["Hands-on Labs: CloudThat emphasizes hands-on learning through practical exercises and real-world scenarios, allowing candidates to gain practical experience."],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list_3_list":["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. "],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_0_features_list_4_list":["Track Record: CloudThat has a proven track record of success in training and preparing candidates for various cloud and data certifications.\r\n \r\n"],"_course_features_0_features_list_4_list":["field_644a0fc80e680"],"course_features_0_features_list":["5"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features_1_heading":["Learning objectives of the course "],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list_0_list":["Explore PostgreSQL Architecture: Understand the architecture of PostgreSQL and its operation within Azure."],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["Client-Server Communication: Learn how PostgreSQL manages client connections and explore common client tools."],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Query Processing: Gain insights into SQL query processing and optimization techniques"],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Security Features: Implement security features such as encryption, authentication, and permissions "],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list_4_list":["Stored Procedures and Functions: Create and manage stored procedures and functions for reusable SQL queries"],"_course_features_1_features_list_4_list":["field_644a0fc80e680"],"course_features_1_features_list":["10"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"certification_heading":["Certification details: "],"_certification_heading":["field_64538bffffdd5"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":[""],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"course_outline_heading":["Course Outline "],"_course_outline_heading":["field_64538a8effdd4"],"course_section_0_module_title":["Explore PostgreSQL architecture"],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section_0_title":[""],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["Lab: Explore Azure Database for PostgreSQL"],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["1"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section":["1"],"_course_section_0_section":["field_612f51e6b0277"],"course_section_1_module_title":["Understand client-server communication in PostgreSQL"],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":[""],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Lab: Explore PostgreSQL with client tools"],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["1"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["1"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Understand PostgreSQL query processing"],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":[""],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Lab: Execute the EXPLAIN statement"],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["1"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["1"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Secure Azure Database for PostgreSQL"],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":[""],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["Lab: Configure permissions in Azure Database for PostgreSQL"],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["1"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["1"],"_course_section_3_section":["field_612f51e6b0277"],"course_section_4_module_title":["Procedures and functions in PostgreSQL"],"_course_section_4_module_title":["field_612f5535940c3"],"course_section_4_module_description":[""],"_course_section_4_module_description":["field_612f564c921af"],"course_section_4_section_0_title":[""],"_course_section_4_section_0_title":["field_612f5233b0278"],"course_section_4_section_0_lesson_list_0_lession_title":["Lab: Create a stored procedure in Azure Database for PostgreSQL"],"_course_section_4_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list":["1"],"_course_section_4_section_0_lesson_list":["field_612f530a0ac40"],"course_section_4_section":["1"],"_course_section_4_section":["field_612f51e6b0277"],"course_section_5_module_title":["Understand write-ahead logging"],"_course_section_5_module_title":["field_612f5535940c3"],"course_section_5_module_description":[""],"_course_section_5_module_description":["field_612f564c921af"],"course_section_5_section_0_title":[""],"_course_section_5_section_0_title":["field_612f5233b0278"],"course_section_5_section_0_lesson_list_0_lession_title":["Lab: List table changes with logical decoding"],"_course_section_5_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list":["1"],"_course_section_5_section_0_lesson_list":["field_612f530a0ac40"],"course_section_5_section":["1"],"_course_section_5_section":["field_612f51e6b0277"],"course_section":["8"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":["a:6:{i:0;s:5:\"25160\";i:1;s:5:\"25074\";i:2;s:5:\"25163\";i:3;s:5:\"21261\";i:4;s:5:\"20270\";i:5;s:5:\"20118\";}"],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":[""],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":[""],"_average_review_count":["field_62b00367d2de6"],"faq_heading":["FAQs : "],"_faq_heading":["field_64538c59ffdd8"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"curriculum":[""],"featured":[""],"views":["1262"],"level":["intermediate"],"current_students":["0"],"duration_info":["1 Day"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["19900"],"sale_price":["0"],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"What is the DP-3021 certification?\",\"answer\":\"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.\"},{\"question\":\"What are the prerequisites for the DP-3021 certification?\",\"answer\":\"Basic understanding of relational databases and SQL is recommended \"},{\"question\":\"What is the duration of the DP-3021 course?\",\"answer\":\"The course is a 1-day program available in multiple languages including English, Chinese, French, German, Japanese, Portuguese, and Spanish \"},{\"question\":\"What topics are covered in the DP-3021 course?\",\"answer\":\"Topics include PostgreSQL architecture, client-server communication, query processing, security features, stored procedures and functions, write-ahead logging, configuration and management, and concurrency management.\"},{\"question\":\"What skills will I earn from the DP-3021 certification?\",\"answer\":\"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.\"},{\"question\":\"What is the cost of the DP-3021 certification?\",\"answer\":\"The cost is approximately $1,495 USD.\"},{\"question\":\"What is the average salary for professionals with the DP-3021 certification?\",\"answer\":\"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.\"},{\"question\":\"Is the DP-3021 certification recognized globally?\",\"answer\":\"Yes, it is recognized globally and is highly valued in the IT industry.\"},{\"question\":\"Can I take the DP-3021 course online?\",\"answer\":\"Yes, the course is available in virtual instructor-led formats.\"},{\"question\":\"What are the benefits of obtaining the DP-3021 certification?\",\"answer\":\"Benefits include enhanced career opportunities, improved technical skills, and recognition as a certified expert in Azure Database for PostgreSQL.\"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video":[""],"lesson_video_poster":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"duration":[""],"preview":[""],"lesson_excerpt":[""],"lesson_files_pack":[""],"questions":[""],"quiz_style":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"question_view_type":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_password":[""],"stm_waiting_room":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"wpdocs-meta-bdt":["25900"],"wpdocs-meta-gbp":["649"],"wpdocs-meta-usd":["749"],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["62"],"_yoast_wpseo_content_score":["60"],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"_wp_old_date":["2025-06-09"],"after_completing_course_5_desciption":["Understand write-ahead logging. \r\n"],"_after_completing_course_5_desciption":["field_6103ad2f9f5b2"],"after_completing_course_6_desciption":["Understand PostgreSQL\u2019s system catalog and views and the vacuum process.\r\n"],"_after_completing_course_6_desciption":["field_6103ad2f9f5b2"],"after_completing_course_7_desciption":["Understand concurrency in PostgreSQL.\r\n"],"_after_completing_course_7_desciption":["field_6103ad2f9f5b2"],"key_features_4_lists":["Stored Procedures and Functions:Creation and management of stored procedures and functions for reusable SQL queries."],"_key_features_4_lists":["field_6103ad559f5b3"],"key_features_5_lists":["Write-Ahead Logging:Understanding write-ahead logging mechanisms to ensure data integrity."],"_key_features_5_lists":["field_6103ad559f5b3"],"key_features_6_lists":["Configuration and Management:Configuration and management of Azure Database for PostgreSQL using system catalogs and views."],"_key_features_6_lists":["field_6103ad559f5b3"],"key_features_7_lists":["Concurrency:Exploration of concurrency systems and how PostgreSQL handles multiple users."],"_key_features_7_lists":["field_6103ad559f5b3"],"key_features_8_lists":["Query Tuning:Techniques for optimizing query performance."],"_key_features_8_lists":["field_6103ad559f5b3"],"key_features_9_lists":["Migration:Steps and best practices for migrating databases to Azure Database for PostgreSQL flexible server."],"_key_features_9_lists":["field_6103ad559f5b3"],"course_features_1_features_list_5_list":["Write-Ahead Logging: Understand write-ahead logging mechanisms to ensure data integrity "],"_course_features_1_features_list_5_list":["field_644a0fc80e680"],"course_features_1_features_list_6_list":["Configuration and Management: Configure and manage Azure Database for PostgreSQL using system catalogs and views."],"_course_features_1_features_list_6_list":["field_644a0fc80e680"],"course_features_1_features_list_7_list":["Concurrency: Explore concurrency systems and how PostgreSQL handles multiple users "],"_course_features_1_features_list_7_list":["field_644a0fc80e680"],"course_features_1_features_list_8_list":["Query Tuning: Learn techniques for optimizing query performance"],"_course_features_1_features_list_8_list":["field_644a0fc80e680"],"course_features_1_features_list_9_list":["Migration: Understand steps and best practices for migrating databases to Azure Database for PostgreSQL flexible server"],"_course_features_1_features_list_9_list":["field_644a0fc80e680"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":["