700 XP

Tune queries in Azure Database for PostgreSQL

Intermediate
Database Administrator
Azure Database for PostgreSQL

Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It's important to understand how performance tuning works and how you can assess performance metrics.

Learning objectives

After completing this module, you'll be able to:

  • Describe statistics in Azure Database for PostgreSQL.

  • Assess query performance with the Query Store.

Start

Prerequisites

  • Demonstrate an understanding of relational databases.

  • Demonstrate an understanding of basic SQL.

This module is part of these learning paths

Module assessment

Assess your understanding of this module. Sign in and answer all questions correctly to earn a pass designation on your profile.

Take the module assessment