Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development. The chances are good that your application's database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future. SQL Antipatterns gives you a rare glimpse into an SQL expert's playbook. Now you can stamp out these common database errors once and for all. Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.
Cited By
- Ghosh A, Bansod D, Narechania A, Dintyala P, Timurturkan S and Arulraj J (2021). Interactive demonstration of SQLCheck, Proceedings of the VLDB Endowment, 14:12, (2779-2782), Online publication date: 1-Jul-2021.
- de Almeida Filho F, Martins A, Vinuto T, Monteiro J, de Sousa Í, de Castro Machado J and Rocha L Prevalence of bad smells in PL/SQL projects Proceedings of the 27th International Conference on Program Comprehension, (116-121)
- Sharma T, Fragkoulis M, Rizou S, Bruntink M and Spinellis D Smelly relations Proceedings of the 40th International Conference on Software Engineering: Software Engineering in Practice, (55-64)
- Nagy C and Cleve A SQLInspect Proceedings of the 40th International Conference on Software Engineering: Companion Proceeedings, (93-96)
- Wang X, Feng A, Golshan B, Halevy A, Mihaila G, Oiwa H and Tan W (2018). Scalable semantic querying of text, Proceedings of the VLDB Endowment, 11:9, (961-974), Online publication date: 1-May-2018.
- Reza J Coherent generational design Proceedings of the 19th Conference on Pattern Languages of Programs, (1-26)