// the take
A personal collection of SQL and PySpark exercises worked through while taking a dozen different Udemy/Lynda/Skillshare courses, covering MySQL, PostgreSQL, SQLite, and some Spark/Tableau. Useful as a grab-bag of practice schemas and queries for someone learning SQL, not as a reference implementation or tool.
Pulls in several realistic, join-heavy schemas (Sakila, Chinook, Parch & Posey, an Instagram clone, an ecommerce store) rather than toy single-table examples, so the queries actually require thinking about relationships. Covers the same kind of analytical questions across MySQL, Postgres, and SQLite, which is a decent way to see where dialect differences actually bite. Goes beyond basic SELECTs into window functions, CTEs, partitioning, and query tuning/execution plans in the 'Advanced SQL' folders. Datasets ship in the repo itself, so most notebooks run without having to go find external data first.
This is one person's course notes stitched together, not a maintained project — each folder follows whatever convention that particular course used, so there's no consistent style or difficulty progression across the repo. Untouched since mid-2022, so anything Spark/PySpark-related is several versions stale and won't reflect current APIs. The SQL here is a learner's solutions to course exercises, not vetted reference queries, so correctness isn't guaranteed and there's no verification against expected output. Several SQLite .db files and a zipped dataset are committed as binary blobs directly in git history, which is exactly the kind of repo bloat you don't want to clone repeatedly.
We read the README, the directory tree and a key source file in October 2026. Nobody pays to be listed. How we judge →