Skip to content
Learn Netverks

Track

postgresql

PostgreSQL

36 lessons: JSONB, psql, EXPLAIN, ops—practice in local Postgres or DB Fiddle.

Mode
sql_sandbox
Practice
SQL sandbox
Lessons
36 units
Start lesson 1 → Introduction to PostgreSQL

Before you start

PostgreSQL features: advanced types, JSONB, window functions, and extension ecosystem.

Preferred OSS database for new SaaS products needing reliability and rich SQL.

Modern startups, geospatial apps, and analytics-friendly OLTP systems.

SQL sandbox track with Postgres-flavored examples and performance notes.

After core SQL—when you deploy on Postgres or need features beyond basic MySQL.

Lesson order

Sequential — follow top to bottom

36 lessons are live in this track. Start from step 01 for the smoothest path.

  1. 01 intro Introduction to PostgreSQL

    beginner

    Open →
  2. 02 what-is-postgresql What is PostgreSQL?

    beginner

    Open →
  3. 03 postgresql-vs-mysql-preview PostgreSQL vs MySQL preview

    beginner

    Open →
  4. 04 postgresql-ecosystem-preview PostgreSQL ecosystem preview

    beginner

    Open →
  5. 05 postgresql-workflow PostgreSQL workflow

    beginner

    Open →
  6. 06 psql-basics psql basics

    beginner

    Open →
  7. 07 data-types-postgresql PostgreSQL data types

    beginner

    Open →
  8. 08 serial-uuid-keys SERIAL and UUID keys

    beginner

    Open →
  9. 09 returning-clause RETURNING clause

    beginner

    Open →
  10. 10 arrays-postgresql Arrays in PostgreSQL

    intermediate

    Open →
  11. 11 jsonb-intro JSONB introduction

    intermediate

    Open →
  12. 12 create-table-postgresql CREATE TABLE in PostgreSQL

    beginner

    Open →
  13. 13 constraints-postgresql Constraints in PostgreSQL

    beginner

    Open →
  14. 14 indexes-postgresql Indexes in PostgreSQL

    intermediate

    Open →
  15. 15 partial-indexes Partial indexes

    intermediate

    Open →
  16. 16 schemas-postgresql Schemas and namespaces

    intermediate

    Open →
  17. 17 extensions-intro Extensions introduction

    intermediate

    Open →
  18. 18 select-postgresql SELECT in PostgreSQL

    beginner

    Open →
  19. 19 joins-postgresql JOINs in PostgreSQL

    beginner

    Open →
  20. 20 aggregates-postgresql Aggregates and GROUP BY

    intermediate

    Open →
  21. 21 window-functions-postgresql Window functions

    intermediate

    Open →
  22. 22 ctes-postgresql Common Table Expressions (CTEs)

    intermediate

    Open →
  23. 23 full-text-search-intro Full-text search introduction

    intermediate

    Open →
  24. 24 transactions-postgresql Transactions in PostgreSQL

    intermediate

    Open →
  25. 25 isolation-levels Isolation levels

    intermediate

    Open →
  26. 26 vacuum-analyze VACUUM and ANALYZE

    intermediate

    Open →
  27. 27 explain-analyze-postgresql EXPLAIN ANALYZE

    intermediate

    Open →
  28. 28 replication-preview Replication preview

    intermediate

    Open →
  29. 29 roles-security-postgresql Roles and security

    intermediate

    Open →
  30. 30 backup-restore-postgresql Backup and restore

    intermediate

    Open →
  31. 31 connection-pooling Connection pooling

    intermediate

    Open →
  32. 32 postgresql-with-django PostgreSQL with Django

    intermediate

    Open →
  33. 33 postgresql-with-python PostgreSQL with Python

    intermediate

    Open →
  34. 34 postgis-teaser PostGIS teaser

    intermediate

    Open →
  35. 35 interview-essentials-postgresql PostgreSQL interview essentials

    intermediate

    Open →
  36. 36 production-checklist-postgresql PostgreSQL production checklist

    intermediate

    Open →