Weekly Roundup: Great SQL Posts
March 02, 2015 | Brant Gidwitz

We’re always on the lookout for great articles about SQL, analytics, and visualization. Here’s a roundup of the team’s favorite recent posts. Enjoy!

1. Embracing SQL In Postgres

Rob Conery dives into Postgres' rich features including regex, full text search, series generation, date math, and window functions.

2. Modern SQL in PostgreSQL [and other databases]

Markus Winand presented a talk about lateral joins, common table expressions, with recursive, filters, and fetch first. Do you know about fetch first?!

3. Tree structure query with PostgreSQL

Learn how to use WITH RECURSIVE to query hierarchical data from Trường TX.

4. Tinkering with Marcel (Pt. 1)

Awesome adaptation of Tom Tango's Marcel Projection system for baseball projections implemented in PostgreSQL. Hats off to @mattdennewitz!

These posts showcase SQL’s power and versatility. While the basics may be simple, it’s hard to master the language. We love seeing people carefully explain the complex topics. What are your favorite articles and blogs for learning SQL and exploring data?