Part 10: Databases & SQL for Data Science
Relational modeling and SQL from fundamentals through window functions, analytical warehousing patterns, and modern NoSQL stores.
Chapters in This Part
Chapter 41: Relational Databases & SQL Fundamentals
Data lives in tables. From the earliest days of computing through today's cloud-scale analytical warehouses, the relational model has proven to be the...
Chapter 42: Intermediate SQL: Joins & Aggregation
SQL's power as an analytical tool becomes fully apparent once you move beyond single-table queries. Real data lives across many related tables — order...
Chapter 43: Advanced SQL: Window Functions & CTEs
SQL began as a language for retrieving and filtering rows, but modern analytical workloads demand far more: ranking items within groups, computing run...
Chapter 44: Analytical SQL & Data Warehousing
Operational databases are optimized for one thing: writing and retrieving individual records quickly. But the questions data scientists and analysts a...
Chapter 45: NoSQL & Modern Data Stores
Relational databases dominated data infrastructure for decades, and for good reason: SQL is expressive, ACID transactions provide strong correctness g...