DP-3021 Configure and migrate to Azure Database for PostgreSQL
Price Net € VAT €
Price Price on Request
Duration
1 day
Location
Course Language English
Training Solutions Online Live
The move to the cloud places new demands on databases and their operation. Azure Database for PostgreSQL combines flexibility, security, and scalability, enabling modern data strategies on a stable technical foundation.
Key topics
- Setting up and managing PostgreSQL services in Azure.
- Migration planning and technical implementation
- Security and compliance aspects
- Monitoring, maintenance, and performance optimization
- Concepts for high availability and data backup
Prerequisites
Knowledge of SQL, experience with PostgreSQL or similar systems, and basic knowledge of cloud technologies.
Target audience
Database administrators, cloud engineers, and technical specialists responsible for planning and operating databases.
The content taught promotes the secure use of PostgreSQL in Azure and supports the development of robust, modern database solutions for dynamic IT landscapes.
- Description of Azure Database for PostgreSQL:
- Understanding PostgreSQL architecture
- Learn about PostgreSQL shared storage
- Understanding connection handling
- Exploring the PostgreSQL client tools
- Understanding query processing components
- Understanding the EXPLAIN statement
- Security in Azure Database for PostgreSQL
- Role description for Azure Database for PostgreSQL servers
- Assigning access rights in Azure SQL Database for PostgreSQL
- Understanding encryption in Azure Database for PostgreSQL
- Storing a procedure in Azure Database for PostgreSQL
- Calling a procedure in Azure Database for PostgreSQL
- Creating and using a function in Azure Database for PostgreSQL
- Explanation of proactive write logging
- Describe replication and logical decoding
- Understanding system catalogs and views
- Analyzing metadata through system catalogs and views
- Explaining the purpose of vacuum and autovacuum
- Configuring autovacuum parameters
- Understanding MVCC and Snapshots
- Explaining isolation levels
- Understanding locks
- Analysis of statistics
- Evaluation of query performance based on memory
- Comparison of online and offline migrations
- Options for migration tools
- Analysis of criteria for tool and migration model selection
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
09:00 - 17:00
