Databases & SQL · PostgreSQL

PostgreSQL Tutorial

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

Start tutorial

Sponsored

Lesson outline

  1. 25
    PostgreSQL Data Types

    Work with PostgreSQL data types: from numeric to JSON, choose storage wisely, and steer clear of common traps.

  2. 26
    PostgreSQL Tutorial — Part 013

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

  3. 27
    SQL NULLs and COALESCE

    Understand NULL values and COALESCE in PostgreSQL — what NULL really means, how it behaves in expressions, and when to use COALESCE for practical queries.

  4. 28
    PostgreSQL Tutorial — Part 014

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

  5. 29
    Update Existing Rows in Tables

    Learn how to update existing rows in PostgreSQL tables with practical examples, troubleshooting tips, and next steps in the tutorial track.

  6. 30
    PostgreSQL Tutorial — Part 015

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

  7. 31
    Delete Rows and TRUNCATE Tables

    Learn to delete rows and TRUNCATE tables in PostgreSQL — practical steps, troubleshooting, and what to study next.

  8. 32
    PostgreSQL Tutorial — Part 016

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

  9. 33
    ALTER TABLE Schema Changes

    Learn to modify PostgreSQL schemas with ALTER TABLE. This step-by-step tutorial covers adding, dropping, and altering columns, plus troubleshooting and best practices.

  10. 34
    PostgreSQL Tutorial — Part 017

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

  11. 35
    Drop Tables Safely

    Learn to drop tables and databases safely in PostgreSQL — includes DROP TABLE/DB best practices, IF EXISTS, CASCADE cautions, and hands-on steps.

  12. 36
    PostgreSQL Tutorial — Part 018

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

    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.