Demystifying databases by building one

"Demystifying databases by building one" with Duncan Mole

Ever wondered exactly what an index is?
What does clustered and non-clustered mean?
How do constraints work?
Why is bulk insert so fast?
How do joins work?
Whats the difference between a view and materialized view?
What is a covered index?
What is index fragmentation?
What is an inverted index?

We will touch on all these topics plus more as we take a tour through the mysterious land of the RDBMS.

About speaker

This talk will be given by Duncan Mole aka dunkymole. A programmer who doesnt know how to write bios: https://www.linkedin.com/in/duncanmole/

This meetup is organized with the help of "Qim info", our group's sponsor: https://www.qiminfo.ch/