PostgreSQL in Depth Tutorial
Master PostgreSQL schema design, querying, indexes, transactions, security, backup, replication, and evidence-based performance tuning.
Start learning PostgreSQL in Depth →
Course Contents
PostgreSQL Foundations
- PostgreSQL Architecture and Processes
- Install PostgreSQL and Use psql
- Databases, Schemas, Search Paths, and Ownership
Relational Design
- Data Types and Domain Modeling
- Primary Keys, Foreign Keys, and Constraints
- Normalization, Denormalization, and Schema Evolution
Querying Data
- SELECT, Filtering, Expressions, and NULL
- Joins, Subqueries, and Common Table Expressions
- Grouping, Aggregates, and Window Functions
Indexes and Planning
- B-Tree and Multicolumn Indexes
- Partial, Expression, GIN, GiST, and BRIN Indexes
- EXPLAIN, Statistics, and Query Planner Decisions
Transactions and Concurrency
- ACID Transactions and Isolation Levels
- MVCC, Vacuum, and Row Visibility
- Locks, Deadlocks, and Safe Concurrent Updates
Advanced Data Features
- JSONB Modeling and Indexing
- Arrays, Ranges, Enums, Domains, and Composite Types
- Full-Text Search and Generated Columns
Server-Side Design
- Views, Materialized Views, and Refresh Strategies
- Functions, Procedures, and PL/pgSQL
- Triggers, Audit Trails, and Event-Driven Patterns
Security
- Roles, Privileges, and Default Permissions
- Row-Level Security and Tenant Isolation
- TLS, Authentication, Secrets, and SQL Injection Defense
Operations
- Backup, Restore, and Point-in-Time Recovery
- Streaming Replication and High Availability
- Monitoring, Connection Pooling, and Routine Maintenance
