Work with Azure Database for PostgreSQL
Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It's based on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as -you-go pricing model provides predictable performance and near-instant scaling. In this learning path you'll be introduced to the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You'll learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Achievement Code
Would you like to request an achievement code?
Modules in this learning path
PostgreSQL is an open-source relational database system that is available as an Azure service. In this module you will learn about the PostgreSQL architecture, and how to manage different aspects of Azure Database for PostgreSQL.
PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module, you will learn how PostgreSQL manages connections from clients, and look at some common 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.
Azure Database for PostgreSQL includes comprehensive security features including encryption, authentication, and granting permissions to database users. In this module you will learn about the security features of Azure Database for PostgreSQL.
PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module, you'll learn how to create and run stored procedures and functions.
Azure Database for PostgreSQL is an ACID compliant database service. Write-ahead logging ensures changes are both atomic and durable. In this module, you learn how Azure Database for PostgreSQL implements write-ahead logging.
System information is known as metadata and is stored in system catalogs in Azure Database for PostgreSQL. In addition to directly accessing system catalogs, you can access system views.
Azure Database for PostgreSQL is a multi-user relational database solution. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place.
Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.
Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It is important to understand how performance tuning works and how you can assess performance metrics.