Postgres From Zero

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 50% Off

One plan covers every Professional Certificate on Coursera. 50% off Coursera Plus Annual for 10 days only — price increases June 17.

Unlock All Certificates

e.g. This is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with high school students and professionals with an interest in programming.Postgres From Zero takes you from never having opened a PostgreSQL prompt to shipping a typed Rust binary that emits production-grade JSON reports against a real schema. You will operate Postgres through psql using backslash commands, information_schema, and safe SELECT ... LIMIT queries, then execute INSERT, UPDATE, and DELETE inside BEGIN/ROLLBACK/COMMIT transactions so a wrong move ends with a rollback rather than a restore from backup. You will read the 16-table Pagila Sakila schema as a relational map, walk the customer to rental to inventory to film spine with multi-table JOINs, distinguish INNER from LEFT JOIN row-by-row, and read EXPLAIN ANALYZE plans to compare query plans and spot Seq Scan versus Index Scan trade-offs. Finally, you will build a typed Rust client with sqlx::PgPool and the FromRow derive, map Postgres column types to Rust struct fields, and ship the postgres-reports binary with three Top-N analytical reports, each enforcing named runtime contracts. Every lesson uses the Pagila open dataset and the public paiml/postgres-from-zero GitHub repository, so you can reproduce everything on a fresh laptop with Docker Compose and a single make target.

Syllabus

Postgres Fundamentals

Build the foundations of working with PostgreSQL from psql. Cover backslash commands, DATABASE_URL connection strings, transactional INSERT / UPDATE / DELETE, and safe operating habits inside a session.

Sakila Schema, JOINs, and EXPLAIN

Read the Pagila/Sakila schema like a relational map: spine tables, bridge tables, foreign keys, and audit columns. Use INNER and LEFT JOIN deliberately and read EXPLAIN ANALYZE to compare query plans.

Typed Rust Client with sqlx

Connect to PostgreSQL from a typed Rust client using sqlx. Configure PgPoolOptions, map rows into FromRow structs with sqlx::query_as!, and propagate errors with anyhow::Result for production-grade integrations.

End-to-End Demo

Tie everything together: bring up Pagila locally with Docker Compose, run the SQL demos through psql, and execute the typed Rust report binary to emit production-grade JSON. One repo, one make target, one command line.