| Introduction & Basics |
Overview, Features, Editions, Comparison with other RDBMS |
✅ |
|
|
|
| Installation & Configuration |
System Requirements, Installation (Linux/Windows), Configuration Files |
✅ |
✅ |
|
|
| Databases & Schemas |
Creating Databases, Schemas, Default Settings, Search Paths |
✅ |
✅ |
|
|
| Tables & Data Types |
Creating Tables, Column Types, Constraints, Serial/UUID, JSON/JSONB |
✅ |
✅ |
|
|
| Primary & Foreign Keys |
PK, FK, Referential Integrity, Cascading Rules |
✅ |
✅ |
|
|
| Indexes |
B-Tree, Hash, GIN, GiST, BRIN, Partial, Expression Indexes |
|
✅ |
✅ |
|
| Views |
Simple Views, Materialized Views, Security, Refresh Strategies |
✅ |
✅ |
✅ |
|
| Stored Procedures & Functions |
PL/pgSQL, Language Functions, Parameters, RETURNS |
✅ |
✅ |
✅ |
|
| Triggers |
BEFORE/AFTER, INSTEAD OF, Row-Level, Statement-Level |
|
✅ |
✅ |
|
| Transactions |
BEGIN/COMMIT/ROLLBACK, ACID, Isolation Levels, Savepoints |
✅ |
✅ |
✅ |
|
| Locks & Concurrency |
Row-Level Locks, Table Locks, Deadlocks, Advisory Locks |
|
✅ |
✅ |
|
| Constraints |
NOT NULL, UNIQUE, CHECK, EXCLUSION, DEFAULT |
✅ |
✅ |
|
|
| Normalization & Design |
1NF, 2NF, 3NF, Denormalization, ERD |
✅ |
✅ |
|
|
| Querying |
SELECT, JOINs, WHERE, GROUP BY, HAVING, ORDER BY, DISTINCT |
✅ |
✅ |
✅ |
|
| Advanced Queries |
CTEs, Window Functions, Ranking, Aggregates, JSON Queries |
|
✅ |
✅ |
|
| Performance Tuning |
EXPLAIN/EXPLAIN ANALYZE, Index Tuning, Query Optimization |
|
✅ |
✅ |
|
| Partitioning |
Table Partitioning, Inheritance, Declarative Partitioning |
|
✅ |
✅ |
|
| Backup & Restore |
pg_dump, pg_restore, Base Backups, PITR (Point-in-Time Recovery) |
✅ |
✅ |
✅ |
|
| Replication & High Availability |
Streaming Replication, Logical Replication, Hot Standby, Failover |
|
✅ |
✅ |
✅ |
| Security |
Roles, Users, Permissions, Row-Level Security, Authentication |
✅ |
✅ |
✅ |
✅ |
| Monitoring & Maintenance |
pg_stat views, Logs, AutoVacuum, Maintenance Tasks |
|
✅ |
✅ |
|
| Extensions & Plugins |
PostGIS, pg_partman, citext, Custom Extensions |
|
✅ |
✅ |
✅ |
| Foreign Data Wrappers (FDW) |
postgres_fdw, oracle_fdw, MongoDB FDW, Configuration |
|
✅ |
✅ |
✅ |
| Advanced Features |
JSONB Indexing, Full-Text Search, Materialized Views, GIN Index |
|
✅ |
✅ |
✅ |
| Cloud & Scaling |
Amazon RDS, Aurora, GCP Cloud SQL, Citus, Sharding Strategies |
|
|
✅ |
✅ |