Often times the gap in trying/learning something in Postgres is having a good tangible example. The playground makes that easier by loading a datasets then guiding you step by step through an exercise leveraging that dataset in a practical way. Whether it's just the basics of interacting in the Postgres CLI with psql , improving your querying skills with SQL, or digging into performance analysis we want something for everyone to be able to level up your skills. Our guided tutorials focus on practical uses and examples as opposed to purely academic definitions.
Never seen Postgres from the command line before? Start here! We’ve loaded a sample database in for you and you’re a superuser.
Joins in Postgres
Learn about inner and outer joins in this tutorial
Learn why and how to use transactions.
Indexing (B-Tree Indexes)
Learn how to create a b-tree index in Postgres. No yardwork required!
CTEs and Window Functions
Learn how to query data with US Birth data.
High level performance analysis
A quick introduction to some of the most important Postgres performance metrics. Including cache hit ratio, index hit, and bloat.
Basics of PostGIS
Test some sample spatial queries and functions with PostGIS!
Learn how to create partitions with native Postgres and pg_partman with an IoT sample dataset.