Azure Database for PostgreSQL Tutorials

  • Learning Path
  • 5 Modules

At a glance

Learn key PostgreSQL concepts through our Azure Database for PostgreSQL Tutorials. Explore our tutorials to focus on a specific topic, or discover a subject that interest you and delve deeper.

Prerequisites

  • None

Modules in this learning path

Getting started: An introduction to SQL and reading data

This module provides an introduction to the SQL SELECT statement. You learn how to select specific columns, remove duplicates with DISTINCT, create calculated columns and use concatenation.

Filtering data: The WHERE clause and subqueries

This module introduces the WHERE clause and subqueries in SQL. You learn how to filter data, combine conditions and use functions like EXTRACT, NOW() and CAST.

Organizing data: Using LIMIT, OFFSET, and ORDER BY clauses

Explore how to use the LIMIT and OFFSET clauses in SQL to control the number of rows returned by a query. Learn how to implement pagination and maintain consistent results with ORDER BY.

Combining data from multiple tables: SQL Joins Explained

This module introduces SQL joins, which are essential for combining data from multiple tables. You learn about INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, and NATURAL JOIN.

Summarizing data: Aggregate functions and grouping

This module introduces aggregate functions in SQL, which are essential for analyzing data. You learn how to use functions like COUNT, SUM, AVG, MIN and MAX, group data using the GROUP BY clause and filter grouped results with the HAVING clause.

Start