Work with Azure Database for PostgreSQL
- Offered byMicrosoft
Work with Azure Database for PostgreSQL at Microsoft Overview
Duration | 5 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Work with Azure Database for PostgreSQL at Microsoft Course details
- Explore PostgreSQL architecture
- Understand client-server communication in PostgreSQL
- Understand PostgreSQL query processing
- Secure Azure Database for PostgreSQL
- Procedures and functions in PostgreSQL
- Understand write-ahead logging
- Use system catalogs and system views in PostgreSQL
- Understand concurrency in PostgreSQL
- Optimize vacuum in Azure Database for PostgreSQL
- Tune queries in Azure Database for PostgreSQL
- 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
- In this course you will learn about the PostgreSQL architecture, and how to manage different aspects of Azure Database for PostgreSQL
- In this course, you will learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools
Work with Azure Database for PostgreSQL at Microsoft Curriculum
Explore PostgreSQL architecture
Introduction
Describe Azure Database for PostgreSQL
Understand PostgreSQL architecture
Understand PostgreSQL shared memory
Exercise - Explore Azure Database for PostgreSQL
Knowledge check
Summary
Understand client-server communication in PostgreSQL
Introduction
Understand connection handling
Understand the PostgreSQL client tools
Exercise: Explore pgAdmin
Knowledge check
Summary
Understand PostgreSQL query processing
Introduction
Identify the query processing components
Understand EXPLAIN
Exercise: Practice EXPLAIN
Knowledge check
Summary
Secure Azure Database for PostgreSQL
Introduction
Describe Azure Database for PostgreSQL security
Describe built-in Azure Database for PostgreSQL server roles
Grant permissions in Azure SQL Database for PostgreSQL
Understand encryption in Azure Database for PostgreSQL
Configure Azure Active Directory authentication
Exercise: Configure Azure AD authentication with Azure Database for PostgreSQL
Knowledge check
Summary
Procedures and functions in PostgreSQL
Introduction
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 PostgreSQL
Exercise: Create a stored procedure in Azure Database for PostgreSQL
Knowledge check
Summary
Understand write-ahead logging
Introduction
Describe write ahead logging
Describe replication and logical decoding
Exercise: List table changes with logical decoding
Knowledge check
Summary
Use system catalogs and system views in PostgreSQL
Introduction
An overview of system catalogs and system views
Investigate metadata with system catalogs and system views
Exercise: Investigate metadata with system catalogs and system views
Knowledge check
Summary
Understand concurrency in PostgreSQL
Introduction
Understand multi-version concurrency control (MVCC) and snapshots
Describe isolation levels
Understand locking
Exercise: Understand locking
Knowledge check
Summary
Optimize vacuum in Azure Database for PostgreSQL
Introduction
Explain the purpose of vacuum and autovacuum
Configure autovacuum server parameters
Exercise: Configure autovacuum server parameters
Knowledge check
Summary
Tune queries in Azure Database for PostgreSQL
Introduction
Understand statistics
Assess query performance with the Query Store
Visualize performance with Query Performance Insight
Exercise: Visualize performance with Query Performance Insight
Knowledge check
Summary
Work with Azure Database for PostgreSQL at Microsoft Entry Requirements
- Demonstrate an understanding of relational databases.Demonstrate an understanding of basic SQL.
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?