Relational Database Foundations with PostgreSQL

Write basic SELECT queries using WHERE clauses and operators to filter data from a single table.

Design a normalized schema for storing narrative text (books, chapters, chunks) using appropriate data types, primary keys, and foreign keys.

Write complex SELECT queries using JOINs and GROUP BY with aggregate functions to combine and summarize data from multiple tables.

Connect to PostgreSQL from Python using psycopg, executing parameterized queries to prevent SQL injection.

Explain the internal workings of a B-tree index and predict when PostgreSQL will choose an index scan versus a sequential scan.

Use EXPLAIN ANALYZE to inspect and interpret query execution plans, identifying potential performance bottlenecks.

Start an implementation journal to track learnings, assumptions, and questions after each study session.

Write an Architecture Decision Record (ADR) defending the choice of PostgreSQL over a NoSQL database like MongoDB for this project's requirements.