Practical SQL and Database Design

Self enrolment

In this course we will cover to identify and avoid common mistakes. The process of designing databases using normalization will also be covered briefly.

Table of Contents:-

  1. Introduction
  2. Jaywalking
  3. Naive Trees
  4. ID Required
  5. Keyless Entry
  6. Entity-Attribute-Value
  7. Polymorphic Associations
  8. Multicolumn Attributes
  9. Metadata Tribbles
  10. Rounding Errors
  11. 31 Flavors
  12. Phantom Files
  13. Index Shotgun
  14. Fear of the Unknown
  15. Ambiguous Groups
  16. Random Selection
  17. Poor Man’s Search Engine
  18. Spaghetti Query
  19. Implicit Columns
  20. Readable Passwords
  21. SQL Injection
  22. Pseudokey Neat-Freak
  23. See No Evil
  24. Diplomatic Immunity
  25. Magic Beans