PostgreSQL

1. Data Types

   Built-in column types such as numeric, text, timestamps, arrays, enums, UUID and range types, and how type choice affects storage and correctness.

2. Data Definition and Constraints

   Creating tables and schemas, primary and foreign keys, unique, check and not-null constraints, defaults, generated columns, ALTER TABLE and schema design.

3. Queries, Joins and CTEs

   SELECT semantics, join types, subqueries, GROUP BY, window functions, WITH common table expressions, recursive queries and set operations.

4. MVCC and Concurrency Control

   Multiversion concurrency control, row versions and snapshots, readers not blocking writers, and the concurrency model overview.

5. Transaction Isolation

   Read committed, repeatable read and serializable isolation levels, serialization failures, retry logic, and anomalies like phantom and non-repeatable reads.

6. Explicit Locking

   Table-level and row-level locks, SELECT FOR UPDATE and SKIP LOCKED, advisory locks, deadlocks and lock modes.

7. Indexes and Index Types

   B-tree, hash, GiST, GIN, BRIN and SP-GiST indexes, multicolumn, partial, expression and covering indexes, and index-only scans.

8. Query Planning and EXPLAIN

   Using EXPLAIN and EXPLAIN ANALYZE, scan and join node types, cost estimates, planner statistics, ANALYZE and populating a database efficiently.

9. Planner Statistics

   Table and column statistics, extended statistics, selectivity estimation and how stale or missing statistics cause bad plans.

10. JSON and JSONB

    json versus jsonb types, containment and existence operators, jsonpath, GIN indexing of documents and when to use semi-structured data.

11. Full Text Search

    tsvector and tsquery, dictionaries and text search configurations, ranking results and GIN indexes for text search.

12. VACUUM and Routine Maintenance

    Dead tuples and table bloat, VACUUM and autovacuum, transaction ID wraparound, visibility map, REINDEX and statistics updates.

13. Table Partitioning

    Declarative range, list and hash partitioning, partition pruning, attaching and detaching partitions and partition-wise operations.

14. WAL and Reliability

    Write-ahead logging, checkpoints, fsync and durability, asynchronous commit and crash recovery.

15. Replication and High Availability

    Streaming physical replication, standbys, failover, synchronous replication, hot standby and load balancing.

16. Logical Replication

    Publications and subscriptions, logical decoding, replication slots, conflicts and selective table replication.

17. Parallel Query

    Parallel sequential scans, joins and aggregates, worker processes and when the planner chooses parallel plans.

18. Roles, Authentication and Row Security

    Database roles and privileges, pg_hba.conf authentication methods and row-level security policies.

19. Backup and Restore

    pg_dump logical backups, continuous archiving, base backups and point-in-time recovery.

Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.

Source: endoflife.date

• Oracle Database
• Parquet
• Pinecone
• PlanetScale
• PocketBase
• Polars
• Prefect
• Presto
• Prisma
• Pub/Sub
• Pulsar
• Qdrant