SQL and Database Management Through Pop Culture

SQL and Database Management Through Pop Culture#

Welcome to this interactive, openly licensed textbook for database design, SQL querying, security, performance, and PostgreSQL. Designed as a modern, hands-on introduction to data management, this book is built from the ground up for both active student engagement and seamless classroom adoption.

12+ Chapters

Zero-Setup Web + Colab

CC BY-NC 4.0 Open License

DataSys+ Aligned

For Students#

Each chapter is structured as a self-contained, story-driven learning experience set in familiar pop-culture universes (including Star Trek, Mario Bros, Gotham City, Pokémon, and Emerald City Clinic). You can read each chapter in your browser or launch it directly in Google Colab with a single click.

There are no complex software installations, version mismatches, or setup hurdles—you can start writing and running SQL immediately. Interactive, auto-graded quizzes are built directly into the notebooks, giving you instant feedback on your SQL query writing and schema design skills as you read and practice.

For Instructors#

This curriculum is closely aligned with the CompTIA DataSys+ (DS0-002) certification exam, covering core database foundations, design, deployment, security, and integration. It provides a complete, zero-setup, active-learning framework featuring built-in, autograded quizzes and game-based review sets. Every single chapter features a unique pop-culture case study that helps make abstract database and SQL concepts approachable and memorable. As an Open Educational Resource (OER), it is freely shareable, adaptable, and optimized for digital publishing.

Development of this textbook was made possible by generous grant funding from the Minnesota State (MinnState) system and Rochester Community and Technical College (RCTC), as part of their ongoing commitment to high-quality, zero-cost learning resources for students.

Textbook Table of Contents#

Each chapter is Google Colab-ready. Launch a notebook to execute code dynamically, or read the web version for clean offline study.

Chapter	Title & Theme	Core Learning Concepts	Interactive Formats
Ch 00	Chapter 0: Introduction to Databases and SQL (Pop Culture Overview)	Book pedagogy, author, DataSys+ alignment	Read Online
Ch 01	Chapter 1: Database Foundations (Star Trek and Starfleet Command)	Data models (Relational, JSON, Graph), databases vs. flat files	Read Online \| Launch Colab
Ch 02	Chapter 2: Basic Retrieval with SELECT (The Sci-Fi Classics Catalog)	Basic queries, SELECT, FROM, WHERE, ORDER BY, DISTINCT	Read Online \| Launch Colab
Ch 03	Chapter 3: Joins and Set Operations (The IMDb Cinema Database)	INNER/OUTER JOINs, UNIONS, EXCEPT, INTERSECT	Read Online \| Launch Colab
Ch 04	Chapter 4: Advanced SQL & Business Continuity (Mario Brothers Plumbing)	GROUP BY, HAVING, subqueries, complex filtering	Read Online \| Launch Colab
Ch 05	Chapter 5: Relational Schema Design (The Covert Spy Academy)	ERDs, normalization, primary & foreign keys, constraint rules	Read Online \| Launch Colab
Ch 06	Chapter 6: Data Modification with DML (Rolling Stone’s Greatest Albums)	INSERT, UPDATE, DELETE, triggers, application connections	Read Online \| Launch Colab
Ch 07	Chapter 7: Schema Abstraction with Views (The Pop Culture Music Archive)	Reusable query blocks, reporting structures, access controls	Read Online \| Launch Colab
Ch 08	Chapter 8: Indexes, Performance & Transactions (Gotham National Bank)	Indexing types, execution plans, ACID transactions	Read Online \| Launch Colab
Ch 09	Chapter 9: Enterprise Databases with PostgreSQL (The Pokémon Pokédex)	SQLite-to-PostgreSQL, schemas, advanced types, procedural code	Read Online \| Launch Colab
Ch 10	Chapter 10: Database Security & Defense (Toad Town Medical Center)	CIA Triad, access control (RBAC), SQL injection, encryption	Read Online \| Launch Colab
Ch 11	Chapter 11: Architecture Patterns & Testing (The Springfield Power Plant)	Systems lifecycle, physical architecture, verification	Read Online \| Launch Colab
Ch 12	Chapter 12: Data Integration and ETL Pipelines (The Emerald City Clinic)	CSV, JSON, XML, APIs, ETL pipelines, AI tools	Read Online \| Launch Colab
Ch 13	Chapter 13: Relational Design Capstone (Your Pop Culture Sandbox)	End-to-end database design, build, optimization, and docs	Read Online \| Launch Colab

Chapter Review Games (Loop of the Recursive Dragon)#

Each chapter is supported by an RPG-style adaptive review set in the Loop of the Recursive Dragon review game. Select a chapter and play:

⚔️ Ch 1 — Foundations (Data, models, structures)
⚔️ Ch 2 — SELECT basics (Filtering, sorting, aggregates)
⚔️ Ch 3 — JOINs and sets (Inner, outer, unions)
⚔️ Ch 4 — Advanced retrieval (GROUP BY, HAVING, subqueries)
⚔️ Ch 5 — Database design (ER modeling, normalization, keys)
⚔️ Ch 6 — Writing data (INSERT, UPDATE, DELETE, triggers)
⚔️ Ch 7 — Views & governance (CTEs, data governance, GDPR)
⚔️ Ch 8 — Performance & ACID (Indexes, plans, transactions)
⚔️ Ch 9 — PostgreSQL (Postgres types, procedures, roles)
⚔️ Ch 10 — Database security (CIA triad, roles, SQL injection, encryption)
⚔️ Ch 11 — Architecture & testing (Design patterns, deployment models)
⚔️ Ch 12 — Data integration (ETL, formats, AI tooling)
⚔️ Ch 13 — Capstone review (Comprehensive final project prep)

Coming Soon#

Scenario-based case studies on stewardship, policy, compliance, quality controls, governance risk, and data lifecycle management.