Category: Learning resources

Curated lists of books to buy to learn PostgreSQL, from beginner SQL intros to advanced internals and performance books.

Roundups of courses, YouTube playlists, and workshop recordings, with guidance on what to use at each experience level.

Learning resources

PostgreSQL Window Functions: Step-by-Step Tutorial

Need a running total, a ranking, or a month-over-month comparison in SQL? The usual instinct is a self-join, a correlated subquery, or a stack of CTEs. PostgreSQL window functions make those patterns shorter, faster, and far easier to read — without collapsing your rows the way GROUP BY does. This step-by-step tutorial walks through window […]

admin