Every module at a glance. Click any lesson to jump right in!
What is a database? Why PostgreSQL? History, comparisons, and who uses it.
Install PostgreSQL + DBeaver, connect, and run your first query.
CREATE, INSERT, SELECT, UPDATE, DELETE — the foundation of everything.
Numbers, text, dates, booleans, JSON, and the constraint bouncers.
WHERE, ORDER BY, LIMIT, LIKE, BETWEEN, IN, NULL handling.
COUNT, SUM, AVG, GROUP BY, HAVING — data analytics starts here.
Built-in functions, custom functions, triggers, views.
JSONB, JSON operators, arrays — PostgreSQL as a document DB.
Physical streaming and logical publications, including slots and version limits.