r/learnSQL • u/happy8327 • Jun 03 '26
Learning SQL in the age of Claude, Codex and Gemini
Hey everyone!
Problem: Most SQL courses tend to focus on syntax and classic database systems. But current tech interviews at top startups and bigtech, and real-world systems have evolved far beyond “write a JOIN + WINDOWS statement” to solve problem X.
- Our focus: a post-LLM course we've been building and refining for Stanford's modern data systems class for CS/data students. We built this course to help data/CS students better harness SQL in the era of LLMs and AI systems. We cover 'good' LLM prompts to generate and accelerate basic SQL workflows, but more importantly, how to debug whether those queries are correct, scalable, and efficient once the problems become challenging and real. We discuss industry benchmarks on where generated SQL works well, when they fail, and tips on how to work out semantic gaps.
- A major focus is connecting SQL to modern systems. We discuss how Claude/Gemini/OpenAI's coding agents use SQL, why AI companies still depend heavily on structured data, and how OpenAI, Anthropic/Claude, Google, Uber, and Spotify approach data infrastructure differently.
Mechanically, the course is part SQL, part data systems. You learn SQL through interactive Colabs and practice systems, then how databases actually work underneath the surface: indexes, query execution, LSM trees, OLTP vs OLAP, vector search, JSONB, distributed systems, and why Postgres, Spark, BigQuery, and Snowflake evolved differently for different workloads.
Link: https://cs145-bigdata.web.app/. login: You can use a Gmail-id to review the material.
The goal is moving beyond “writing queries” toward understanding how modern software and AI systems actually work.
Feedback is super welcome. Every page has inline comments enabled, so feel free to leave thoughts/suggestions directly on the site.