Who is this training for?
PostgreSQL Developers and Administrators
Training objectives
- Understand the basic concepts of PostgreSQL in Azure
- Identify the different deployment options
- Configure and manage a PostgreSQL database in Azure
- Provide security and access control Monitor and optimize performance, understand the principles of migrating to Azure
Summary
Azure Database for PostgreSQL is a PaaS database service available in the Microsoft cloud. It is based on the open-source relational database PostgreSQL and includes built-in high availability, automatic backup and recovery, and comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you learn about the key features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different implementation options for Azure Database for PostgreSQL and how to configure a server for your needs.
Course outline
- Explore the PostgreSQL architecture
- Understand client-server communication in PostgreSQL
- Understand PostgreSQL query processing
- Secure Azure Database for PostgreSQL
- Procedures and functions in PostgreSQL
- Understand WAL logging
- Configure and manage Azure Database for PostgreSQL
- Understand concurrency in PostgreSQL
- Tune queries in Azure Database for PostgreSQL
- Migrate to Azure Database for PostgreSQL flexible server
Approach and methodology
Practical and structured approach combining focused theory and guided workshops. Participants gradually set up and migrate databases to Azure Database for PostgreSQL through real-world exercises inspired by business scenarios, promoting immediate application of learning. They learn how to plan, execute, and optimize migrations, as well as how to configure, secure, and administer PostgreSQL environments in Azure. Led by a Microsoft certified trainer, the training focuses on interactivity and the development of directly transferable technical skills to effectively manage data solutions in a professional context.
Prerequisites
- Knowledge of relational databases.
- Basic knowledge of SQL.
Recommendations
- Have a first experience with PostgreSQL or an equivalent database
- Knowledge of Azure basics (portal, resources)
- Be comfortable with data manipulation
- Notions of database security (asset)
- Experience in database development or administration (asset)
