Real World Iterative Database Development
summary
Starts from an Excel/CSV import and shows a runnable pipeline using Flyway + Postgres in Docker with Java/Gradle, creating migrations under version control and applying three iterative schema changes to a ~1k-row dataset. It splits composite cells into CSV → normalized tables (members, boats, qualifications), uses surrogate primary keys and strong types, and validates migrations with SQL set-operations including EXCEPT/INTERSECT tests to prove no lost or duplicated rows. Demos succeed; warns against manual DB edits and opaque views.
AI-written summary · about
chapters (17)
- 0:00Introduction
- 0:27Agile vs Waterfall
- 1:42Conceptual Modelling
- 2:32First Exercise
- 4:38Migrating Data
- 11:11Database Migration
- 16:00Normal Forms
- 18:19Iterative Development
- 20:56Database Modelling Checklist
- 23:31Strong Data Types
- 25:38Database Normalisation
- 28:56Second Example
- 32:19How to make database development iterative
- 39:55One story
- 42:07Example
- 43:23Testdriven
- 45:37Demo
related talks
56mPersistence Workflows with IntelliJ IDEA
16mVersion Your Databases with Flyway
29mHow to build a data pipeline without data
52mManaging PostgreSQL changes for the Agile DBA
46mDatabase DevOps - It is Possible!
36mUnlocking the Benefits of Database DevOps and Automation
46mA Database DevOps Pipeline
54mA Database DevOps Pipeline