Postgres Playground: Helps enhance Postgres skills by loading datasets and guiding through exercises. Focuses on practical uses rather than academic definitions.

• psql basics: Start with command line access to a sample database.
• Learn SQL: Basics of SQL.
• Joins in Postgres: Inner and outer joins.
• Indexing (B-Tree Indexes): Create b-tree indexes.
• Transactions: Why and how to use transactions.
• Basics of PostGIS: Test spatial queries and functions.
• Creating Tables: Basics of table creation with keys and data types.
• Row Level Security: Manage key-based partitioning.
• Partitioning: Create partitions with an IoT dataset.
• Window Functions for Data Analysis: Various window functions.
• Basics of JSON: JSON interactions.
• High level performance analysis: Important performance metrics.
• Postgres Contraints: Create foreign keys and other constraints.
• Query performance analytics: Find least performant queries.
• Casting Data Types: Cast data types with examples.
• CTEs and Window Functions: Query data with US Birth data.
• Materialized Views: Create basic materialized views.
• Percentage Calculations: Do percentage calculations.
• Working with Time in Postgres: Work with time in Postgres.
• Strings to Arrays: Unnest array function.
• Custom data types: DOMAINS: User-defined datatypes and constraints.
• Custom data types : user defined types: Hands-on examples of composite and other types.
• Summaries with Aggregate Filters and Windows: Aggregate filtering with window functions.
• Using FILTER vs CTEs and CASE WHEN: Use FILTER for aggregation.
• SQL Tricks for More Effective CRUD: Simple and not-so-simple CRUD.
• LATERAL JOIN: An introduction to lateral join.
• PostgreSQL - Just for Kids: Intro to SQL for kids.
• Advent of Code - various days: SQL solutions for different days' challenges with various functions.
• Postgres Functions for Rolling Up Data by Date: Sample code for rolling up data by date.
• Postgres Users and Roles: Create user roles and manage login details.
• psql Echo Commands: Learn about psql echo commands.
• Working with Money in Postgres: Work with money in Postgres.
• Advent of Code - Day 18: SQL for the Boiling Boulders puzzle.
• Tags and Postgres Arrays, a Purrrfect Combination: Store tags in a database with different methods.