SQL

Topics: Relational Thinking, Tables, Rows, Columns, Domains, and Data Types

Topics: Schemas, CREATE TABLE, ALTER TABLE, DROP, and DDL Safety

Topics: Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL, and Referential Actions

Topics: INSERT, UPDATE, DELETE, UPSERT, RETURNING, and Safe Writes

Topics: SELECT, Projection, Filtering, Expressions, Ordering, LIMIT, and Pagination

Topics: NULL and Three-Valued Logic: IS NULL, COALESCE, CASE, and Correct Predicates

Topics: Aggregation: COUNT, SUM, AVG, MIN/MAX, GROUP BY, HAVING, and Conditional Aggregates

Topics: Joins: INNER, LEFT/RIGHT/FULL, CROSS, SELF, and Join Cardinality

Topics: Subqueries, EXISTS, IN, Correlated Queries, and LATERAL

Topics: CTEs, Recursive Queries, UNION/INTERSECT/EXCEPT, and Query Composition

Topics: Window Functions: PARTITION BY, ORDER BY, Frames, Ranking, and Running Analytics

Topics: Data Modeling, Functional Dependencies, and Normalization

Topics: Transactions and ACID: Atomicity, Consistency, Isolation, and Durability

Topics: Isolation Levels, MVCC, Locks, Lost Updates, Write Skew, and Deadlocks

Topics: Indexes: B-Tree, Hash, GIN, GiST, BRIN, Composite, Partial, and Expression Indexes

Topics: EXPLAIN, ANALYZE, Buffers, Cardinality Estimates, and Query Optimization

Topics: Views and Materialized Views: Stable Read Models and Precomputation

Topics: Functions, Procedures, Triggers, Generated Logic, and When to Keep Logic in SQL

Topics: Database Security: Roles, GRANT/REVOKE, Row-Level Security, Injection, and Secrets

Topics: PostgreSQL JSON/JSONB, Arrays, Range Types, Full-Text Search, and Specialized Data

Topics: Partitioning, Replication Concepts, Backup, Restore, Vacuum, and Operational SQL

Topics: SQL from Node.js: Pools, Parameters, Prepared Statements, Transactions, and Repository Boundaries

Topics: SQL Capstone: Schema Design, Transactions, Analytics, Security, and Query Tuning