Description:
An exploration of the top 10 most common relational database mistakes. We'll go into the mistakes in some depth - and use lots of examples as we go - so that you can get an appreciation of why they’re mistakes, see what their real-world consequences are, and start to see how to do things better.
????????Download the FREE PDF (Decomplexify Quick Reference Guide on Normal Forms and Entity Relationship Diagrams):
https://decomplexify.myflodesk.com/wm7ixaj2x6
Learn about de-normalization:
https://www.youtube.com/watch?v=4bTq0GdSeQs
Timeline:
0:00 Introduction
0:25 Free PDF resource (normal forms & ERDs)
1:13 # 10: Misunderstanding what "relational" means
6:33 # 9: Forgetting about Null when doing comparisons
9:47 # 8: Thinking procedurally
11:23 # 7: Making every primary key a simple sequential value
13:44 # 6: The myth of "over-normalization"
19:07 # 5: Writing "hope and pray" SQL queries
21:44 # 4: Trying to minimize the number of tables
24:22 # 3: Confusing logical design with physical design
27:36 # 2: Burying complexity inside a single column
29:25 # 1: Not thinking about data integrity
31:16 Conclusion
Share this link via
Or copy link