iwantcoding.com
🔥 Daily 👥 Rooms 🏆 Top Log in Sign up
« Previous

Postgres HOME

By · Reviewed & last updated · Part of PostgreSQL Tutorial

Welcome to the iwantcoding.com PostgreSQL Tutorial. PostgreSQL is the world’s most advanced open-source relational database. Strong types, rich SQL, JSONB, full-text search, and a deep extension ecosystem make it a default pick for new projects.

What this tutorial covers

ChapterYou will learn
Postgres BasicsInstall, psql, data types, CREATE TABLE, SELECT / INSERT / UPDATE / DELETE, JOINs, GROUP BY, subqueries, CTEs, window functions.
Postgres SpecialJSONB, arrays, ENUMs, UUID, full-text search, GIN / GiST, extensions (postgis, pgvector), partitioning.
Schema & PerformanceConstraints, indexes, EXPLAIN ANALYZE, transactions, MVCC, roles, backups, replication.
Server-side CodeFunctions, PL/pgSQL, triggers, views, LISTEN / NOTIFY, logical decoding.
ExamplesCheatsheet, runnable snippets, quiz, exercises, bootcamp, certificate.

Who this is for

  • App devs starting a new product.
  • Anyone with JSON data who would still like real SQL.
  • Data folks: pgvector, partitioning, and CTEs are first-class.
How to use this tutorial: read the chapter, run the example with Try it Yourself », do the exercise, then take the quiz at the bottom. Hit Mark complete when you're done — the sidebar will track your progress.

Example

Example
SELECT 'Hello, Postgres' AS greeting;
Try it Yourself »

Discussion

Loading…

« Previous