Schema Studio

SQLAdvancedabout 7 hours16 lessons

Lantern Yard is a community workshop that has run for two years on a shared spreadsheet and a badge reader. You are hired to give it a real database. Starting from a one-page brief you sketch the model, create the tables, and teach them to refuse bad rows with keys, checks and foreign keys. Then you untangle the spreadsheet into clean tables, speed up lookups with indexes you can read in the query plan, hide joins behind views, keep an audit trail with triggers, change several tables atomically, roll out a schema change without downtime, and finish with a booking schema that cannot be double-booked.

Start the first lesson

Not started0/2280 XP

Blueprint · Schema Studio

Pass lesson 1 to power it up

warming up the scene…

Design sketchER diagramConstraint firewallKeys & uniquenessBusiness rulesForeign keysNormal formsMany-to-manyQuery plansSmart indexesViewsTriggers & auditTransaction consoleUpserts & RETURNINGJSON & generated columnsMigration timelineCollision-proof bookings

Learning path

Each lesson adds one working part to your build.

Chapter 1

Sketch to schema

Turn a one-page brief into a model, then into tables that already refuse the obvious mistakes.

0/4 done

Chapter 2

Relationships and speed

Link tables with foreign keys, split a messy spreadsheet into clean tables, and make lookups fast.

0/4 done

Chapter 3

Guard rails and atomic changes

Smarter indexes, views as an interface, triggers that keep rules and records, and transactions that change many things at once.

0/4 done

Chapter 4

Change without breaking

Write-or-update in one statement, flexible JSON, schema changes that never stop the app, and a booking schema that cannot collide.

0/4 done

Loading project…