Postgres From Zero

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.