Relational Database Essentials (with a deck of cards)
Friday, 10:45 AM
Relational databases are the foundation to countless systems but are often abstracted away and ignored until queries start timing out. Learn the essentials of indexing, query tuning and database design; all explained with a deck of playing cards.
We start with the fundamentals: Normalization, the 7 types of joins (that’s right, 7!) and internal data structures.
From there we dive deep into how indexes work, performance considerations of indexes and even why the database sometimes ignores your indexes.
Digging even deeper, learn the three ways the database will implement a join. Finally learn some miscellaneous tips to improve your SQL and security.
About Michael Carducci
Michael Carducci is a retired software engineer and solutions architect who now makes obfuscation a way of life.
When he’s not in pursuit of pure astonishment, he’s likely to be falling from great heights, exploring East Texas on two wheels, or diving headfirst into his next great adventure. You can find Michael on the web as well as on Twitter.