I’m realising my colleagues have essentially not been trained in databases and yet are expected to use them. That’s obviously a good opportunity for me to step in with some training.

The way i enjoy teaching things is by implementing them from scratch (see basically all my talks and articles), but i realise - i don’t know how to write a db from scratch! Nothing fancy, simple storage that can be extremely slow (but with indexes, even if just in memory), and a basic query language that shows the most common bits of sql so that joins, etc… are explained.

Does anyone know of a resource that explains this in a way i would understand and be able to explain in up to 10 or 15 one hour live cosing sessions?

@NicolasRinaudo This book is well-regarded. https://www.databass.dev/