Nalla Labs Academy

Academy / Week 7

Phase 2 · Data and persistence

Week 7: PostgreSQL

Friday deliverable: Project 3

Day 1Install PostgreSQL; psql; roles and least privilegeOutline only
Day 2Transactions, isolation levels, the lost updateOutline only
Day 3Indexes and EXPLAINOutline only
Day 4Migrations; sqlc; build Project 3Outline only
Day 5Break: concurrent writes corrupt a balance; pg_dump backup and restoreOutline only

Threads this phase

Security. SQL injection, parameterised queries, least-privilege DB roles, backups

AI. Explain query plans and schema trade-offs; learner writes all SQL

System trace. Query → parser → planner → index → disk

Project 3

Database-backed ledger

Same app on SQLite, then migrated to PostgreSQL with a proper schema and reports

Runs on: Laptop plus local PostgreSQL

Phase 2 exit criteria

understand: Relations, joins, indexes, isolation levels
explain: Why a transaction is needed for a transfer
build: A normalised schema with migrations
debug: A slow query with EXPLAIN; a lost update
test: Tests against a real test database
secure: Parameterised queries; least-privilege DB user
deploy: Apply migrations safely
operate: Back up and restore a database

← Week 6 Week 8 →

Nalla Labs Academyhello@nallalabs.xyz