Services
Internship
Courses
Learn
Work
About
Let’s Talk
→
🐘
PostgreSQL
The powerful open-source relational database we ship with.
Start learning
Practice & quiz
PostgreSQL Docs
1
Getting Started with PostgreSQL
1.1
Why PostgreSQL?
7m
1.2
Installing PostgreSQL & Connecting with psql
10m
1.3
Databases, Schemas & Tables
8m
2
Data Types & Table Design
2.1
PostgreSQL Data Types
11m
2.2
CREATE TABLE, Keys & Constraints
12m
2.3
JSONB & Arrays
13m
3
Indexing & Query Performance
3.1
Indexes: B-tree, Unique & Partial
11m
3.2
EXPLAIN ANALYZE & Query Performance
12m
3.3
Sequences, Views & Materialized Views
10m
4
Advanced SQL Features
4.1
Transactions & Isolation Levels
11m
4.2
CTEs & Window Functions
13m
4.3
UPSERT with ON CONFLICT
7m
4.4
Full-Text Search
9m
5
Node.js Integration & Operations
5.1
Connecting from Node.js with the pg Library
12m
5.2
Database Migrations
8m
5.3
PostgreSQL in Production: A Practical Checklist
10m
6
Deeper Dives
6.1
Window Functions in Depth
12m
6.2
Recursive CTEs for Hierarchical Data
11m
6.3
JSONB Operators & GIN Indexing
10m
6.4
Roles, GRANT & Row-Level Security
13m
6.5
Partial, Expression & Generated-Column Indexes
9m