Session
Back#2 - Solid Schemas and Advanced SQL (AM)
Date: 2017-09-06
Time: 16:00 - 19:00
Room: Lombard
Level: Beginner
Schema architecture is one of the most enjoyable aspects of working with databases. It’s even more rewarding when designs prove solid under load, scale easily, and return complex data with minimal grief. To hit those goals, you must start with a firm knowledge of what normal forms are, how to implement them and when to break them.
This tutorial will cover designing out a database from scratch using 1st-5th normal forms and examples of what goes wrong when denormalization goes bad. It will include common use scenarios such as high volume update/delete tables and optimizing jsonb data.
Once our database design is set, we will use that as a base for walking through SQL shortcuts and strategies to generate test data, pull reporting queries, and simplify your code.