Skip to content
UZ Telegram

SQL and Seaborn

From SELECT to window functions. Every query runs against school.db.

25 chapters 410 code blocks 127840 words

Contents

25 chapters
01SQL Foundations8 code02SELECT, WHERE, ORDER BY13 code03Filtering deep (IN, LIKE, NULL)12 code04Aggregation, GROUP BY, HAVING13 code05JOINs12 code06Subqueries & CTE11 code07Window functions10 code08String, date & CASE WHEN15 code09UNION, INTERSECT, EXCEPT10 code10CREATE, INSERT, UPDATE, DELETE15 code11Indexes & performance4 code12SQL + Python (pandas)12 code13SQL gotchas & interview11 code14Seaborn foundations8 code15Relational plots26 code16Distribution plots23 code17Categorical plots37 code18Heatmap & correlation34 code19Regression plots24 code20FacetGrid, pairplot, jointplot28 code21Styling, palettes, saving33 code22EDA workflow11 code23Seaborn gotchas & interview4 code24Projects32 code25Quick-reference cheat sheet4 code
Data filesthe code in this book uses them — download and run it yourself
school.dbdownload