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.
SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers
- Authors
- Bill Karwin
- ISBN
- 1934356557
- Published
- 15 Jun 2010
- Purchase online
- amazon.com
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.
- Editorial Reviews
- Customer Reviews
Editorial Reviews
You might also like...
Database books
-
SQL Architecture Basics Joes 2 Pros: Core Architecture concepts (Sql Exam Prep Series) (Volume 3)
As companies grow and do more business, the data they store in databases similarly grows. If you want to be a go-to person on the inner workings of SQL Server, then this book will be your partner in achieving that goal. If you have completed the SQL ...
Database jobs
-
Graduate Reports Developer
Jagex in Cambridge, United Kingdom
To £30k (DOE) + Excellent Benefits / Progression -
Data Architect
Integrative Nutrition in New York, United States
Competitive
Database podcasts
-
webdev radio: SQL Cookbook review, Aardvark, MySQL tuning, CSS question
Published 8 years ago, running time 0h20m
We have the first book giveaway and cover the Aardvark Firefox extension. I also explain some MySQL performance problems I’ve had recently, talk about some MySQL tools which helped me get over those problems, and ask for some help on a CSS layout question. *CSS Creator Layout Generator :: Ge.
Comments