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.
Table of Contents hide

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
Articles
- When to use NULLable columns in relational databases
- Articles in category: Query optimisation
Courses