SQL & PostgreSQL
From SELECT to query planning and pgvector — a self-paced SQL track, beginner to advanced, with PostgreSQL as the primary engine.
TopNotchNote
Notes that matter
foundations
Start here: portable SQL, then PostgreSQL specifically.
querying
Getting data out of more than one table, and computing per-row results without collapsing them.
schema & data modeling
Deciding what tables and constraints should exist in the first place.
performance & internals
What actually happens when a query runs, and how to keep it fast under real concurrency.
postgresql power features
The features that go beyond standard SQL — including pgvector, for AI/RAG embedding search.
operations & application integration
Running PostgreSQL for real: access control, disaster recovery, and connecting from code.
related topics
Python — application code that talks to the database (see also SQL from Python above).
GPU Programming & Performance Engineering — the compute side of the embeddings pgvector searches over.
ML Foundations — where embeddings and retrieval fit into a larger ML pipeline.
GPU Programming & Performance Engineering — the compute side of the embeddings pgvector searches over.
ML Foundations — where embeddings and retrieval fit into a larger ML pipeline.