{"product_id":"configure-and-migrate-to-azure-database-for-postgresql-dp-3021","title":"Configure and migrate to Azure Database for PostgreSQL (DP-3021)","description":"\u003cdiv\u003e\u003cp\u003eAzure Database for PostgreSQL is a robust Platform as a Service (PaaS) offering from Microsoft, built on the open-source PostgreSQL database. This course equips you to explore PostgreSQL architecture, configure and secure your database, optimize performance, and migrate data effectively to Azure Database for PostgreSQL Flexible Server. Learn essential skills like query tuning, concurrency management, and leveraging PostgreSQL's built-in features to enhance your database management experience.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eConfigure and migrate to Azure Database for PostgreSQL (DP-3021) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGain practical skills to configure and manage Azure Database for PostgreSQL.\u003c\/li\u003e\n\u003cli\u003eUnderstand PostgreSQL architecture and advanced features like multi-version concurrency control (MVCC).\u003c\/li\u003e\n\u003cli\u003eLearn to optimize query performance and implement security best practices.\u003c\/li\u003e\n\u003cli\u003eExplore hands-on data migration techniques, including online and offline methods.\u003c\/li\u003e\n\u003cli\u003eMaster advanced features like write-ahead logging, stored procedures, and tuning tools for efficient database operations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFamiliarity with relational databases\u003c\/li\u003e\n\u003cli\u003eBasic understanding of SQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eConfigure and Migrate to Azure Database for PostgreSQL Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eExplore PostgreSQL Architecture\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOverview of Azure Database for PostgreSQL.\u003c\/li\u003e\n\u003cli\u003eUnderstand architecture and shared memory.\u003c\/li\u003e\n\u003cli\u003eHands-on: Explore PostgreSQL on Azure.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eClient-Server Communication\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConnection handling and PostgreSQL client tools.\u003c\/li\u003e\n\u003cli\u003eExercise: Utilize PostgreSQL client tools.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eQuery Processing\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eComponents of query processing and the EXPLAIN statement.\u003c\/li\u003e\n\u003cli\u003eExercise: Analyze queries with EXPLAIN.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eSecure Azure Database for PostgreSQL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEncryption, authentication, and role-based permissions.\u003c\/li\u003e\n\u003cli\u003eExercise: Configure database permissions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eStored Procedures and Functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreate reusable stored procedures and functions.\u003c\/li\u003e\n\u003cli\u003eExercise: Implement stored procedures in PostgreSQL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eWrite-Ahead Logging\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand ACID compliance and logical decoding.\u003c\/li\u003e\n\u003cli\u003eExercise: List table changes using logical decoding.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eConfigure and Manage PostgreSQL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSystem catalogs, metadata, and autovacuum configuration.\u003c\/li\u003e\n\u003cli\u003eExercise: Optimize database configurations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eConcurrency Management\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMulti-version concurrency control (MVCC), isolation levels, and locking.\u003c\/li\u003e\n\u003cli\u003eExercise: Explore locking mechanisms.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eQuery Tuning\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eQuery performance metrics and the Query Store.\u003c\/li\u003e\n\u003cli\u003eExercise: Assess and optimize queries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-weight: bold;\"\u003e\u003cstrong\u003eMigrate to Azure Database for PostgreSQL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCompare online vs. offline migration methods.\u003c\/li\u003e\n\u003cli\u003eExercises: Perform online and offline migrations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267B38US \/ 2026-07-20T09:00:00 \/ Online","offer_id":47534203076827,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AC01US \/ 2026-10-19T09:00:00 \/ Online","offer_id":48216578621659,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271C46US \/ 2027-01-22T09:00:00 \/ Online","offer_id":48216578654427,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274B95US \/ 2027-04-21T09:00:00 \/ Online","offer_id":48619713003739,"sku":"US-8734-IL","price":716.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021","provider":"Learning Tree International","version":"1.0","type":"link"}