Duration: 5

Whether you're writing your first SELECT statement or you've been running Postgres in production for years, there's something here for you. This page pulls together the best tutorials, guides, and community resources so you can find what you need and keep building your skills.

If you're brand new to Postgres, start here. These resources will get you connected, writing queries, and understanding how Postgres works — no prior database experience required.

Learn the command-line tool that ships with Postgres. Connect to a database, run queries, explore schemas, and understand output formatting. psql Basics guide

A friendly introduction to what Postgres is, why it matters, and where it fits in the data landscape. What is Postgres?

Duration: 10

The Crunchy Data Playground gives you a fully functional Postgres instance right in your browser — no installation, no setup, no credit card. Each tutorial comes with a preloaded sample database so you can start writing queries immediately.

These are some of my favorites to recommend, but there are dozens more on the platform.

Duration: 5

If you want to go deep in a single sitting, this open-source workshop covers six hours of material from beginner through advanced topics. Originally presented at SCaLE 23x (2026), it's designed for both instructor-led sessions and self-study.

What's covered:

Setup: Docker-based environment with the Bluebox sample database (real TMDB movie data) — spin it up in minutes and start working through exercises at your own pace.

Postgres Full-Day Training on GitHub

Duration: 10

These guides walk you through real-world workflows on Snowflake Postgres — from creating your first table to building production data pipelines with pg_lake and monitoring with your observability stack of choice.

Create tables, load data, and run queries on your Snowflake Postgres instance. Getting Started with Tables

Set up logical replication to migrate an existing Postgres database to Snowflake Postgres with minimal downtime. Migrate Using Logical Replication

Build IoT-style pipelines that flow data between Postgres and Snowflake using pg_lake's Iceberg integration. Bidirectional Data Pipelines with pg_lake

Use pg_lake to sync Postgres tables to Snowflake as Iceberg tables for analytics workloads. Sync Data with Iceberg and pg_lake

Combine Postgres as your transactional layer with Snowflake's analytics engine for a complete lakehouse architecture. Build a Lakehouse with Snowflake Postgres

Connect your Postgres data to Snowflake Cortex AI functions and build interactive Streamlit applications. Build AI Apps with Streamlit and Cortex

Ship Snowflake Postgres logs and metrics to Datadog for centralized observability. Monitor with Datadog

Integrate Snowflake Postgres monitoring into Observe's unified observability platform. Monitor with Observe

Set up Grafana dashboards for Snowflake Postgres performance monitoring and alerting. Monitor with Grafana

Duration: 5

The Postgres community is one of the most welcoming and knowledgeable in open source. These resources will keep you learning long after you've finished the tutorials above.

The gold standard for database documentation. Thorough, accurate, and well-organized — worth bookmarking and reading cover to cover over time. PostgreSQL Docs

Practical, production-focused writing on Postgres topics including performance, analytics, spatial data, and AI integration. Crunchy Data Blog

Community-maintained knowledge base with tips, how-tos, feature comparisons, and configuration guidance. PostgreSQL Wiki

A blog aggregator that collects posts from Postgres contributors and community members worldwide — great for staying current. Planet PostgreSQL

Weekly conversations about Postgres topics — architecture decisions, new features, war stories, and community news. Postgres.FM

Find Postgres conferences, meetups, and events happening around the world. PostgreSQL Events

Duration: 1

Learning Postgres is an ongoing journey — the ecosystem is deep, the community is active, and there's always something new to explore. Whether you're just getting started or refining advanced skills, come back to these resources whenever you need a next step.

All Postgres Hub Topics

Crunchy Data Playground

Full-Day Training Workshop