Reviews 4,2
Reviews 4,5
DP-3021 Configure and migrate to Azure Database for PostgreSQL
Azure Database for PostgreSQL brings relational data to the cloud – with flexible scaling, strong security, and the convenience of a fully managed service.
Key topics
- Deploy and administer PostgreSQL services in Azure
- Plan and execute database migration projects
- Implement security requirements and compliance guidelines
- Monitor databases, perform maintenance, and optimize performance
- Design high availability and backup strategies
Prerequisite
Participants with SQL knowledge and hands-on experience with PostgreSQL or comparable systems can get started right away. A basic understanding of cloud technologies is helpful.
Target group
Technical professionals responsible for databases in cloud environments – including database administrators, cloud engineers, and IT architects.
This training builds a solid foundation for operating PostgreSQL confidently in Azure and supports the development of resilient database architectures for modern cloud environments.
Course content
Azure Database for PostgreSQL at a Glance
- Explore the purpose and scope of Azure Database for PostgreSQL
- Understand the structure and components of the PostgreSQL architecture
- Learn how shared storage works in PostgreSQL
Connections and Client Tools
- Explore how connection handling works in PostgreSQL
- Discover the available PostgreSQL client tools
Query Processing in PostgreSQL
- Identify and understand the components of query processing
- Use the EXPLAIN statement to analyze query plans
Security Configuration in Azure
- Set up security mechanisms in Azure Database for PostgreSQL
- Define server roles and assign permissions
- Control and manage access rights effectively
- Learn about encryption options for data at rest and in transit
Procedures and Functions in PostgreSQL
- Create and maintain stored procedures
- Call procedures and integrate them into workflows
- Build custom functions and apply them in database contexts
Write-Ahead Logging and Replication
- Understand the principle and purpose of write-ahead logging
- Classify replication mechanisms and logical decoding
System Catalogs and Vacuum Management
- Learn the structure and use of system catalogs and views
- Query and analyze metadata using system catalogs
- Explain the role and function of vacuum and autovacuum
- Optimize and adjust autovacuum settings
Concurrency and Transaction Control
- Understand the MVCC concept and snapshot isolation
- Know the transaction isolation levels and their implications
- Understand locking mechanisms and apply them effectively
Query Optimization and Performance
- Evaluate statistics and use them for optimization
- Assess and improve query performance based on memory usage
Migration Strategy and Tools
- Compare and evaluate online and offline migration approaches
- Select and apply appropriate migration tools
- Analyze decision criteria for choosing migration tools and models
