PostgreSQL Course
Master production PostgreSQL — SQL, indexes, MVCC, JSONB, replication, backups, security, administration and performance tuning.
Architecture
SQL Query Lifecycle
From an application request through the parser, optimizer and executor — back to a typed result set.
Enterprise learning path
Foundations
- 1PostgreSQL HomeNext up
postgresql home postgresql home is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 2What is PostgreSQL?
what is postgresql? what is postgresql? is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 3PostgreSQL Architecture
postgresql architecture postgresql architecture is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 4Installing PostgreSQL
installing postgresql installing postgresql is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 5psql Basics
psql basics psql basics is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 6PostgreSQL Data Types
postgresql data types postgresql data types is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 7Creating Databases
creating databases creating databases is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 8Creating Tables
creating tables creating tables is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 9CRUD Operations
crud operations crud operations is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 10Constraints
constraints constraints is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
SQL Fundamentals
- 11SELECT Queries
select queries select queries is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 12WHERE Clause
where clause where clause is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 13ORDER BY
order by order by is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 14LIMIT & OFFSET
limit & offset limit & offset is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 15DISTINCT
distinct distinct is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 16Aliases
aliases aliases is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 17CASE Statements
case statements case statements is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 18NULL Handling
null handling null handling is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 19Aggregate Functions
aggregate functions aggregate functions is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 20GROUP BY
group by group by is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 21HAVING
having having is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
Joins
- 22INNER JOIN
inner join inner join is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 23LEFT JOIN
left join left join is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 24RIGHT JOIN
right join right join is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 25FULL OUTER JOIN
full outer join full outer join is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 26SELF JOIN
self join self join is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 27CROSS JOIN
cross join cross join is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 28Join Optimization
join optimization join optimization is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 29Real-World Join Patterns
real-world join patterns real-world join patterns is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
Advanced SQL
- 30Subqueries
subqueries subqueries is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 31Common Table Expressions (CTE)
common table expressions (cte) common table expressions (cte) is a core postgresql skill for application developers, data engineers, dbas, and architects. this
- 32Recursive CTEs
recursive ctes recursive ctes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 33Window Functions
window functions window functions is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 34Ranking Functions
ranking functions ranking functions is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 35LEAD & LAG
lead & lag lead & lag is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 36Pivot Techniques
pivot techniques pivot techniques is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 37Set Operations
set operations set operations is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Indexing
- 38Index Fundamentals
index fundamentals index fundamentals is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 39B-Tree Indexes
b-tree indexes b-tree indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 40Hash Indexes
hash indexes hash indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 41GIN Indexes
gin indexes gin indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 42GiST Indexes
gist indexes gist indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 43BRIN Indexes
brin indexes brin indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 44Partial Indexes
partial indexes partial indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 45Composite Indexes
composite indexes composite indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 46Covering Indexes
covering indexes covering indexes is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 47Index Maintenance
index maintenance index maintenance is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Performance
- 48EXPLAIN
explain explain is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 49EXPLAIN ANALYZE
explain analyze explain analyze is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 50Query Planning
query planning query planning is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 51Sequential Scans
sequential scans sequential scans is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 52Index Scans
index scans index scans is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 53Query Optimization
query optimization query optimization is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 54VACUUM
vacuum vacuum is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 55ANALYZE
analyze analyze is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 56Performance Monitoring
performance monitoring performance monitoring is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 57Connection Pooling
connection pooling connection pooling is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Transactions
- 58ACID Principles
acid principles acid principles is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 59Transactions
transactions transactions is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 60COMMIT
commit commit is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 61ROLLBACK
rollback rollback is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 62SAVEPOINT
savepoint savepoint is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 63Isolation Levels
isolation levels isolation levels is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 64MVCC
mvcc mvcc is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 65Deadlocks
deadlocks deadlocks is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 66Locking Strategies
locking strategies locking strategies is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Programming
- 67Functions
functions functions is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 68Stored Procedures
stored procedures stored procedures is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 69Triggers
triggers triggers is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 70Views
views views is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 71Materialized Views
materialized views materialized views is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 72Sequences
sequences sequences is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 73Generated Columns
generated columns generated columns is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 74Extensions
extensions extensions is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
JSON & Modern Features
- 75JSON
json json is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 76JSONB
jsonb jsonb is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 77JSON Queries
json queries json queries is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 78JSON Indexing
json indexing json indexing is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 79Arrays
arrays arrays is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 80Composite Types
composite types composite types is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 81UUID
uuid uuid is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 82Full-Text Search
full-text search full-text search is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Security
- 83Authentication
authentication authentication is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 84Authorization
authorization authorization is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 85Roles
roles roles is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 86Privileges
privileges privileges is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 87Row-Level Security
row-level security row-level security is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 88SSL Connections
ssl connections ssl connections is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 89Auditing
auditing auditing is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 90Security Best Practices
security best practices security best practices is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
Administration
- 91User Management
user management user management is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 92Backup & Restore
backup & restore backup & restore is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 93pg_dump
pg_dump pg_dump is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 94pg_restore
pg_restore pg_restore is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 95Replication
replication replication is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 96Streaming Replication
streaming replication streaming replication is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 97Failover
failover failover is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 98High Availability
high availability high availability is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 99Partitioning
partitioning partitioning is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 100Maintenance Tasks
maintenance tasks maintenance tasks is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Cloud
- 101PostgreSQL on AWS RDS
postgresql on aws rds postgresql on aws rds is a core postgresql skill for application developers, data engineers, dbas, and architects. this
- 102Azure Database for PostgreSQL
azure database for postgresql azure database for postgresql is a core postgresql skill for application developers, data engineers, dbas, and architects. this
- 103Google Cloud SQL
google cloud sql google cloud sql is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 104Managed PostgreSQL
managed postgresql managed postgresql is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 105Scaling Strategies
scaling strategies scaling strategies is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 106Monitoring Cloud Databases
monitoring cloud databases monitoring cloud databases is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
Advanced
- 107Logical Replication
logical replication logical replication is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 108Physical Replication
physical replication physical replication is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 109Foreign Data Wrappers
foreign data wrappers foreign data wrappers is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 110Sharding Concepts
sharding concepts sharding concepts is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 111TimescaleDB
timescaledb timescaledb is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 112PostGIS
postgis postgis is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 113pgBouncer
pgbouncer pgbouncer is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 114Pgpool-II
pgpool-ii pgpool-ii is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
Troubleshooting
- 115Slow Queries
slow queries slow queries is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 116Deadlocks
deadlocks deadlocks is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax, execution behavior,
- 117Connection Problems
connection problems connection problems is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 118Replication Issues
replication issues replication issues is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 119Disk Space Problems
disk space problems disk space problems is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 120Recovery Strategies
recovery strategies recovery strategies is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 121Troubleshooting Checklist
troubleshooting checklist troubleshooting checklist is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Use Cases
- 122E-Commerce Databases
e-commerce databases e-commerce databases is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 123Banking Systems
banking systems banking systems is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 124Analytics Platforms
analytics platforms analytics platforms is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 125SaaS Applications
saas applications saas applications is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 126Multi-Tenant Systems
multi-tenant systems multi-tenant systems is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 127Event Logging
event logging event logging is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
- 128Inventory Systems
inventory systems inventory systems is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects sql syntax,
Projects
- 129E-Commerce Database
e-commerce database e-commerce database is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational trade-offs.
- 130Banking Management System
banking management system banking management system is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational
- 131Blogging Platform
blogging platform blogging platform is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational trade-offs.
- 132Inventory Management System
inventory management system inventory management system is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational
- 133Analytics Dashboard Backend
analytics dashboard backend analytics dashboard backend is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational
- 134Multi-Tenant SaaS Database
multi-tenant saas database multi-tenant saas database is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational
- 135PostgreSQL Monitoring Dashboard
postgresql monitoring dashboard postgresql monitoring dashboard is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational
- 136High Availability Setup
high availability setup high availability setup is a production postgresql project that combines schema design, relational modeling, indexes, backups, monitoring, and operational
Interview
- 137PostgreSQL Master Interview Bank
postgresql interview bank sql joins indexing transactions performance jsonb administration replication troubleshooting dba architect explain analyze vacuum mvcc backup restore high availability
- 138SQL Fundamentals Interview
sql fundamentals interview sql fundamentals interview is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 139PostgreSQL Interview (0-2 Years)
postgresql interview (0-2 years) postgresql interview (0-2 years) is a core postgresql skill for application developers, data engineers, dbas, and architects. this
- 140PostgreSQL Interview (3-5 Years)
postgresql interview (3-5 years) postgresql interview (3-5 years) is a core postgresql skill for application developers, data engineers, dbas, and architects. this
- 141PostgreSQL Performance Interview
postgresql performance interview postgresql performance interview is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 142PostgreSQL DBA Interview
postgresql dba interview postgresql dba interview is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects
- 143PostgreSQL Architect Interview
postgresql architect interview postgresql architect interview is a core postgresql skill for application developers, data engineers, dbas, and architects. this lesson connects