7h ago · 11 min read · If you have ever watched a dashboard query get slower as the customer table grew, or seen a percentile_cont call suddenly spill 12 MB of temp files to disk, this article is for you. Aggregates and window functions are two of the highest-leverage area...
Join discussion2d ago · 13 min read · If you've ever watched a query go from 30 ms to 30 seconds after a data load — without a single line of SQL changing — you've been on the wrong side of a join-strategy flip. Joins are the part of PostgreSQL that's most sensitive to statistics. A 10× ...
Join discussion3d ago · 4 min read · If you've worked with BigQuery external tables before, you know the basic idea: a thin wrapper around data that resides somewhere else, but queryable from BigQuery. Sources include Cloud Storage, Goog
Join discussion
4d ago · 4 min read · If you’re searching for a sql course for analysts, you probably don’t want a computer-science detour—you want to answer business questions fast, with clean queries you can defend. The good news: you can get analyst-level SQL in a few weeks if you foc...
Join discussion4d ago · 4 min read · If you’re hunting for a sql course for analysts, you’re probably not trying to become a database engineer—you’re trying to answer business questions faster, with fewer dashboards, and without begging someone on the data team for “one more extract.” T...
Join discussion
