SQL Antipatterns Volume 1 Avoiding the Pitfalls of Database Programming

View Demo

  • Available Version
  • EPUB Formate - Volume 1

Table of Contents:

- 1. What's an Antipattern?

- Part I. Logical Database Design Antipatterns

- 2. Jaywalking

- 3. Naive Trees

- 4. ID Required

- 5. Keyless Entry

- 6. Entity-Attribute-Value

- 7. Polymorphic Associations

- 8. Multicolumn Attributes

- 9. Metadata Tribbles

- Part II. Physical Database Design Antipatterns

- 10. Rounding Errors

- 11. 31 Flavors

- 12. Phantom Files

- 13. Index Shotgun

- Part III. Query Antipatterns

- 14. Fear of the Unknown

- 15. Ambiguous Groups

- 16. Random Selection

- 17. Poor Man's Search Engine

- 18. Spaghetti Query

- 19. Implicit Columns

- Part IV. Application Development Antipatterns

- 20. Readable Passwords

- 21. SQL Injection

- 22. Pseudokey Neat-Freak

- 23. See No Evil

- 24. Diplomatic Immunity

- 25. Standard Operating Procedures

- Part V. Bonus: More Foreign Key Mini-Antipatterns

- 26. Foreign Key Mistakes in Standard SQL

- 27. Foreign Key Mistakes in MySQL

- A1. Rules of Normalization

  • Price$2.00
  • Lowest Price Guaranteed

    IT Maila guarantees the best prices, refunding the difference if you find a lower price elsewhere. Our commitment to competitive pricing and customer satisfaction ensures exceptional value and exceeds expectations.

  • Regular Updates

    IT Maila is committed to delivering timely updates and improving our product range to ensure customer satisfaction, positioning us as the leading and rapidly growing site for GPL products.

;