Back to learning
PostgreSQL

PostgreSQL: modelling and migrations

Design a relational schema you can change safely once other people depend on it.

  • Intermediate
  • About 2 weeks
  • 1 milestone
  • 2 steps
  • 1 reviewed
PostgreSQLPrisma
Start this journey
What you will have builtA schema with deliberate constraints and a migration history you can deploy without fear.Start this journey

What this asks of you

Every figure below is read from the journey itself, not written about it.

IntermediateSome engineering experience assumed
About 2 weeksAn estimate, not a deadline
1 milestoneEach one claims a capability
2 stepsShort, and every one is built
1 reviewedAn engineer reads these, when mentor guided

What you will be able to do

Every milestone claims one engineering capability. You reach it by building something, not by finishing a chapter.

RelationshipsExpress a domain rule as a constraint the database enforcesA rule enforced only in code is a rule that will eventually be broken.
2 steps
Show the 2 steps
  • Decide nullability per column

    Justify every nullable column, and remove the ones that were only convenient.

  • Choose delete behaviour on purposeReviewed

    Decide, per relationship, what should happen to children when a parent is deleted.

How the work is verified

  1. ReadThe context you need for this step, and why it matters. Never more than that.
  2. BuildYou produce something real. The work is yours, in your own repository.
  3. SubmitYou send it, with a note on what you chose and what you were unsure about.
  4. ReviewA senior engineer reads it and responds. They may ask for changes — that is the normal path through engineering review, not a failure.
  5. VerifiedThe capability is confirmed, it goes on your record, and the next step opens.

How you want to work

You choose when you start. Both cover the same journey and the same definition of done.

Mentor guidedReviewed by a person

A senior engineer is assigned to you. They read every submission, respond in writing, and decide when a capability is verified. Expect to be asked for changes.

Self pacedVerified by you

You work through the same journey and verify your own work against the same definition of done. Nothing is submitted to anyone, and nothing waits on anyone.

What you end up with

Counted from this journey, not described in general.

A schema with deliberate constraints and a migration history you can deploy without fear.Built by you, in your own repository.
1 pieces of work, each read by an engineerEvery round and every comment stays on the record, including what changed between them.
1 verified capabilitiesEach one confirmed against its definition of done, with the name of whoever confirmed it. There is no certificate. The work is the credential.

Ready to start PostgreSQL: modelling and migrations?

You will choose how you want to work on the next screen. Nothing starts until you confirm it. You can run several journeys at once, and each one is mentor-guided or self-paced on its own.

Start this journey