DP-3021: Configure and Migrate to Azure Database for PostgreSQL

Overview Dive into the world of PostgreSQL in Azure with our comprehensive 8-hour course. You'll gain essential knowledge of PostgreSQL architecture and learn practical steps for configuring and managing PostgreSQL databases in the Azure environment. From exploring security features to mastering query tuning and migration strategies, this course covers it all. _ Through a combination of expert instruction and hands-on labs, you'll develop the skills to manage, configure, and migrate databases effectively. Whether you're looking to enhance your database administration skills or prepare for real-world migration scenarios, this course equips you with the tools and knowledge to excel in PostgreSQL management on Azure. Who Should Attend This course is designed for database administrators who want to expand their skills into Azure PostgreSQL management. If you're looking to transition your PostgreSQL databases to Azure or enhance your ability to manage and optimize Azure Database for PostgreSQL, this course is perfect for you. Prerequisites Demonstrate an understanding of relational databases and basic SQL. No prior experience with Azure or PostgreSQL is required, but familiarity with database concepts will be beneficial. Course Outline Explore PostgreSQL architecture Architecture of PostgreSQL Options for creating an Azure Database for PostgreSQL server PostgreSQL shared memory Understand client-server communication in PostgreSQL Connection handling PostgreSQL client tools Understand PostgreSQL query processing Query processing components EXPLAIN statement Secure Azure Database for PostgreSQL Security features of Azure Database for PostgreSQL Create database users and grant permissions Encryption in Azure Database for PostgreSQL Procedures and functions in PostgreSQL Create and call stored procedures Create and use functions Understand write-ahead logging Write-ahead logging concepts Replication and logical decoding Configure and manage Azure Database for PostgreSQL System catalogs and system views Metadata investigation Vacuum process and configuration Understand concurrency in PostgreSQL Multi-Version Content Control and snapshots Isolation levels Locking in Azure Database for PostgreSQL Tune queries in Azure Database for PostgreSQL Statistics in Azure Database for PostgreSQL Query performance assessment with Query Store Migrate to Azure Database for PostgreSQL flexible server Online and offline migration options Migration tools overview Selecting appropriate migration tools Offline and online PostgreSQL database migration