- PostgreSQL is an open-source relational database system that is now available as a service in Azure. In this module, you learn about the PostgreSQL architecture, and how to manage different aspects of PostgreSQL in Azure Database for PostgreSQL.
After completing this module, you'll be able to:
Describe the architecture of PostgreSQL.
Describe the options for creating an Azure Database for PostgreSQL server.
Understand PostgreSQL shared memory.
- PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module you learn how PostgreSQL manages connections from clients, and looking at some common PostgreSQL client tools.
After completing this module, you'll be able to:
Understand connection handling.
Understand the PostgreSQL client tools.
- The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible. In this module, you learn about the different stages of processing a query, and the EXPLAIN statement.
After completing this module, you'll be able to:
Identify the query processing components.
Understand EXPLAIN.
- Azure Database for PostgreSQL includes comprehensive security features including encryption in transit and at rest, authentication, and granting permissions to database users. In this module you learn about the security features of Azure Database for PostgreSQL, and how to configure them.
After completing this module, you'll be able to:
Describe the security features of Azure Database for PostgreSQL.
Create database users and grant permissions.
Understand encryption in Azure Database for PostgreSQL.
- PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module, you learn how to create and run stored procedures and functions.
After completing this module, you'll be able to:
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 PostrgreSQL.
- Azure Database for PostgreSQL is an ACID compliant database service. Write-ahead logging ensures changes are both atomic and durable (the A and D in ACID). Changes are first written to the log before they're committed to the database. In this module, you learn how Azure Database for PostgreSQL implements write-ahead logging, and how the log can be used for replication and logical decoding.
After completing this module, you'll be able to:
Describe write-ahead logging.
Describe replication and logical decoding.
- Azure Database for PostgreSQL efficiently manages vast quantities of data and their structures through system catalogs and views. This module explores how to optimize database performance by accessing and configuring metadata, understanding the role of the vacuum process in maintaining database health, and managing server settings. We introduce practical techniques to enhance your PostgreSQL database administration, useful in environments requiring robust data handling and security features.
After completing this module, you'll be able to:
Describe system catalogs and system views in Azure Database for PostgreSQL.
Investigate metadata in Azure Database for PostgreSQL.
Explain the purpose of the vacuum process.
Configure vacuum server parameters.
- Azure Database for PostgreSQL is a multi-user relational database solution. The ability to support many concurrent users enables PostgreSQL databases to scale out and enable applications that support many users and locations at the same time. The increase in users brings a risk of conflicts. For this reason, it's important to understand the concurrency systems that are in place in Azure Database for PostgreSQL to manage concurrency and conflicts. In this module, we look at both isolation levels and locking in Azure Database for PostgreSQL.
After completing this module, you'll be able to:
Describe Multi-Version Content Control and snapshots in Azure Database for PostgreSQL.
Describe isolation levels in Azure Database for PostgreSQL.
Describe locking in Azure Database for PostgreSQL.
- Relational databases store many different types of data for many different types of applications. Some databases have thousands of users and some have just one user. Some tables have tens of rows while others have millions of rows. Some data is unique while other data is duplicated. All of these variables mean that database management systems (DBMSs) need systems to understand the data and the queries that are running against this data to ensure optimum performance. When you perform tune a database, it's important to understand how performance tuning works and how you can assess performance metrics.
After completing this module, you'll be able to:
Describe statistics in Azure Database for PostgreSQL.
Assess query performance with the Query Store.
- Azure Database for PostgreSQL Flexible Server supports effective data migration from PostgreSQL servers. This module covers both online and offline migration methods and tools, helping you choose the right approach for your scenario. Learn practical techniques for managing migrations efficiently, ideal for minimizing downtime and maintaining productivity.
After completing this module, you'll be able to:
Understand the different online and offline migration options.
Identify the different migration tools available.
Select the appropriate migration tool for your specific scenario.
