Training plan
Module 1: Explore PostgreSQL architecture
- Describe Azure Database for PostgreSQL
- Understand PostgreSQL architecture
- Understand PostgreSQL shared memory
- Exercise – Explore Azure Database for PostgreSQL
Module 2: Understand client-server communication in PostgreSQL
- Understand connection handling
- Understand the PostgreSQL client tools
- Exercise – Explore PostgreSQL with client tools
Module 3: Understand PostgreSQL query processing
- Identify the query processing components
- Understand the EXPLAIN statement
- Exercise – Execute the EXPLAIN statement
Module 4: Secure Azure Database for PostgreSQL
- 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
Module 5: Procedures and functions in 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
Module 6: Understand write-ahead logging
- Describe write ahead logging
- Describe replication and logical decoding
- Exercise – List table changes with logical decoding
Module 7: Configure and manage Azure Database for PostgreSQL
- 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
Module 8: Understand concurrency in PostgreSQL
- Understand multi-version concurrency control (MVCC) and snapshots
- Describe isolation levels
- Understand locking
- Exercise – Understand locking
Module 9: Tune queries in Azure Database for PostgreSQL
- Understand statistics
- Assess query performance with the Query Store
- Exercise – Assess query performance using Query Store
Module 10: Migrate to Azure Database for PostgreSQL flexible server
- 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
Eccentrix Corner Articles: Configure and Migrate to Azure Database for PostgreSQL DP-3021 Resources
Explore our technical articles on Configure and Migrate to Azure Database for PostgreSQL DP-3021 published on Eccentrix Corner. These resources dive deeper into key concepts, share best practices, and provide practical guides to maximize your learning and success. Our experts share real-world insights to help you master configuring and migrating to Azure Database for PostgreSQL.
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 the Training
Setting Up Azure Database for PostgreSQL
Learn how to deploy Azure Database for PostgreSQL to oversee the performance and health of your database resources.Customizing High Availability and Notifications
Master the creation of high availability configurations for key metrics and events to enable proactive issue management.Utilizing Replication and Disaster Recovery
Explore how to analyze telemetry data and logs for actionable insights using Azure Database for PostgreSQL’s powerful tools.Building Custom Dashboards
Design dashboards that consolidate critical information and provide real-time insights into database performance.Integrating with Azure Services
Discover how to integrate Azure Database for PostgreSQL with other Azure services like Azure Monitor and Azure Backup.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.
Laboratory environment (overview)
You will practice in a structured lab environment with guided steps to validate your progress throughout the exercises. Depending on the lab, it is usually possible to save your progress and resume the steps later, making it easier to practice between sessions.
To ensure a complete experience, a Microsoft 365/Azure tenant environment may be provided to access the features required for the course scenarios (depending on the module requirements and lab conditions).
After the training, access to the lab remains available for a defined period. Tenant access may be time-limited, while access to the virtual machines and guided steps remains available for up to 180 days.
The screenshots above are provided as examples and may vary depending on the lab version and updates.
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
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.
