Skip to content
UZ Telegram

SQL and Seaborn

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

25 chapters 481 code blocks 129138 words

Contents

25 chapters
01SQL Foundations9 code02SELECT, WHERE, ORDER BY13 code03Filtering deep (IN, LIKE, NULL)13 code04Aggregation, GROUP BY, HAVING16 code05JOINs12 code06Subqueries & CTE13 code07Window functions10 code08String, date & CASE WHEN16 code09UNION, INTERSECT, EXCEPT11 code10CREATE, INSERT, UPDATE, DELETE19 code11Indexes & performance4 code12SQL + Python (pandas)13 code13SQL gotchas & interview11 code14Seaborn foundations12 code15Relational plots29 code16Distribution plots23 code17Categorical plots39 code18Heatmap & correlation48 code19Regression plots31 code20FacetGrid, pairplot, jointplot37 code21Styling, palettes, saving34 code22EDA workflow19 code23Seaborn gotchas & interview4 code24Projects41 code25Quick-reference cheat sheet4 code
Data filesthe code in this book uses them — download and run it yourself
school.dbdownload