Master the world's most advanced open-source database. Every concept explained like you're five, then we build real stuff. No experience needed — just curiosity!
Curated by Fakhruddin Khambaty
Meet
PostgreSQL
Install
& Setup
SQL
Basics
Data
Types
Querying
Data
Aggreg-
ations
JOINs
Sub-
queries
Indexes
Func-
tions
Trans-
actions
JSON &
Arrays
Prod-
uction
What even is a database? Why does PostgreSQL exist? Who uses it and why should you care? We answer every beginner question with fun analogies.
Install PostgreSQL and DBeaver step-by-step with screenshots so clear your grandma could follow. Connect, create your first database, and run your very first query!
The bread and butter of databases! CREATE tables, INSERT data, SELECT what you need, UPDATE records, and DELETE what you don't. The four magic words of SQL.
Numbers, text, dates, booleans, JSON — PostgreSQL has a type for everything. Plus constraints that act as bouncers, keeping bad data out of your tables.
WHERE, ORDER BY, LIMIT, LIKE, BETWEEN, IN, NULL handling — everything you need to find exactly the data you want, fast. Think of it as becoming a data detective!
COUNT how many, SUM the totals, AVG the average, find the MIN and MAX. Then GROUP BY to summarise and HAVING to filter groups. Data analytics starts here!
JOINs are like matchmaking for tables! INNER JOIN = mutual matches, LEFT JOIN = you like them even if they don't like you back. The heart of relational databases.
Queries inside queries! Like Russian nesting dolls, but for data. Then CTEs — the "sticky notes" that make complex queries readable. Plus recursive CTEs for hierarchies!
Make your queries FAST! Indexes are like the index in a book — instead of reading every page, you jump straight to what you need. Plus EXPLAIN ANALYZE to diagnose slow queries.
PostgreSQL's built-in Swiss Army knife of functions, plus how to create your own. String functions, math functions, date functions, and user-defined powerhouses.
ACID properties, BEGIN/COMMIT/ROLLBACK, isolation levels, MVCC — the secret sauce that keeps your data safe even when 1000 users hit the database at the same time.
PostgreSQL is also a document database! Store JSON, query it, index it. Plus arrays for when one column needs to hold multiple values. Best of both worlds.
Take PostgreSQL to production! VACUUM, WAL, backup & restore, replication, security & roles, monitoring, and configuration tuning. The real DBA skills.
This course starts from absolute zero. Here's what helps but isn't required:
Windows, Mac, or Linux — all work perfectly. We guide you through installation on every platform.
If you can download an app and type into a text box, you're ready. Seriously. No programming experience needed.
The desire to learn how the world stores and retrieves data. From Instagram's photos to your bank's transactions — it's all databases!
Create tables with proper types, keys, and relationships
JOINs, subqueries, CTEs, window functions, aggregations
Use indexes, EXPLAIN, and know when to tune
Store and query JSON/JSONB — use Postgres as a document DB
Backup, restore, replicate, secure, and monitor like a real DBA
Every concept companies test: JOINs, window functions, CTEs, transactions
Module 2 walks you through this in extreme detail, but here's the cheat sheet: