Databases & SQL · PostgreSQL

PostgreSQL Tutorial

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

Start tutorial

Sponsored

Lesson outline

  1. 1
    What is PostgreSQL?

    Discover what PostgreSQL is, why it's a top choice for developers, and how it fits into your data stack. This lesson from the PostgreSQL Tutorial track gives you a solid foundation, with a hands-on exercise and next steps.

  2. 2
    PostgreSQL Tutorial — Part 001

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

  3. 3
    Install PostgreSQL on Linux

    Install PostgreSQL locally on Linux with hands-on steps, troubleshooting, and guidance on what to explore next in the PostgreSQL Tutorial.

  4. 4
    PostgreSQL Tutorial — Part 002

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

  5. 5
    Install PostgreSQL on macOS and Windows

    Learn to install PostgreSQL on macOS and Windows step by step. This lesson covers setup, configuration, and troubleshooting for both platforms.

  6. 6
    PostgreSQL Tutorial — Part 003

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

  7. 7
    Connect with psql

    Connect with psql and run first queries — PostgreSQL Tutorial. This lesson is step 4 in the learning path, covering practical hands-on steps, troubleshooting, and what to study next.

  8. 8
    PostgreSQL Tutorial — Part 004

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

  9. 9
    PostgreSQL Databases & Schemas

    Understand PostgreSQL databases and schemas in this hands-on tutorial. Learn how to organize objects, manage namespaces, and apply best practices.

  10. 10
    PostgreSQL Tutorial — Part 005

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

  11. 11
    Create Your First Database

    Create your first database and table — PostgreSQL Tutorial.

  12. 12
    PostgreSQL Tutorial — Part 006

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

    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.