Databases & SQL · PostgreSQL

PostgreSQL Tutorial

SQL ergonomics through EXPLAIN intuition, transactional behaviour, pragmatic schema design.

Start tutorial

Sponsored

Lesson outline

  1. 37
    Master Primary and Foreign Keys

    Master primary and foreign keys in PostgreSQL. This lesson explains the core concepts, provides a hands-on exercise, and connects to the next step in the tutorial.

  2. 38
    PostgreSQL Tutorial — Part 019

    Placeholder slot — edit in console (postgresql-stub-019).

  3. 39
    Create Indexes for Faster Queries

    Learn to create PostgreSQL indexes for faster queries. Understand how B-tree indexes speed up lookups, when to use them, and how to avoid common pitfalls. Includes a hands-on exercise.

  4. 40
    PostgreSQL Tutorial — Part 020

    Placeholder slot — edit in console (postgresql-stub-020).

  5. 41
    Basic Joins in PostgreSQL

    Learn to combine rows from two or more tables with basic SQL joins in PostgreSQL. This tutorial covers inner and left joins, step-by-step examples, and common pitfalls—plus what to study next.

  6. 42
    PostgreSQL Tutorial — Part 021

    Placeholder slot — edit in console (postgresql-stub-021).

  7. 43
    LEFT and RIGHT Joins in PostgreSQL

    Master LEFT and RIGHT joins in PostgreSQL with clear examples, troubleshooting tips, and next steps in the tutorial.

  8. 44
    PostgreSQL Tutorial — Part 022

    Placeholder slot — edit in console (postgresql-stub-022).

  9. 45
    Aggregate Rows with GROUP BY

    Learn to aggregate rows with GROUP BY in PostgreSQL—understand the mental model, see step-by-step examples, and troubleshoot common issues.

  10. 46
    PostgreSQL Tutorial — Part 023

    Placeholder slot — edit in console (postgresql-stub-023).

  11. 47
    Filter Groups Using HAVING

    Learn to filter groups using HAVING in PostgreSQL. This tutorial explains when to use HAVING versus WHERE, provides hands-on examples, and covers common pitfalls.

  12. 48
    PostgreSQL Tutorial — Part 024

    Placeholder slot — edit in console (postgresql-stub-024).

    PostgreSQL Tutorial — step-by-step tutorials

    What you will find here

    This track walks through postgresql tutorial in order — each lesson is server-rendered HTML you can read without JavaScript. Follow the outline, then practice in the browser IDE when a lesson links to runnable code.

    Tutorials vs quizzes and code samples

    Tutorials teach in sequence. For quick checks use quizzes. For copy-paste snippets see code samples. For deeper reading browse articles.