It’s easy to see antipatterns in production databases. Our schemas should be simple but extensible, and allow fast SQL queries. In this webinar I discuss what most common antipatterns are, and how to correct them.

Webinar Recording

• Welcome
• Agenda
• Criteria for Database Design
• Relational Model, pro’s and con’s
• Keys and Indexes
• Data Types
• Abusing NULL
• Hierachies
• Lists
• Inheritance & Polymorphism
• Misc Antipatterns
• Thank you

Slides

See also

See future and past Webinars.

Articles

• When to use NULLable columns in relational databases
• Articles in category: Query optimisation

Courses

• MySQL Query Optimisation