Bill Karwin has helped thousands of people write better SQL and build
stronger relational databases. Now he's sharing his collection of
antipatterns--the most common errors he's identified in those thousands
of requests for help.
Most developers aren't SQL experts, and most of the SQL that gets used
is inefficient, hard to maintain, and sometimes just plain wrong. This
book shows you all the common mistakes, and then leads you through the
best fixes. What's more, it shows you what's behind these fixes, so
you'll learn a lot about relational databases along the way.
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.