PostgreSQL Features
PostgreSQL-specific features beyond standard SQL — JSONB, full-text search, advanced index types, lateral joins, partitioning, and performance monitoring.
Query Optimization
How PostgreSQL plans and executes queries — reading EXPLAIN ANALYZE output, choosing indexes, and avoiding common performance traps.
SQL for AI Engineering
SQL patterns for AI engineering — vector similarity queries with pgvector, feature extraction for ML, logging LLM calls, and building lightweight feature stores.
SQL Fundamentals
SQL fundamentals for software engineers — querying, joining, aggregating, indexing, transactions, and how ORMs map on top. PostgreSQL-focused.
SQLAlchemy Patterns
SQLAlchemy patterns for production Python — async engine, session management, relationships, bulk operations, Alembic migrations, and common pitfalls.
Window Functions
Window functions run calculations across a set of rows related to the current row without collapsing them into a group — essential for rankings, running totals, and time-series comparisons.