SQL Antipatterns: Avoiding the Pitfalls of Database Programming
Category: eBooks
- views: 1 382
- date: 18 March 2013
- posted by: piplos

P..c B..f (6-2010) | PDF | 328 pages | 1934356557 | 1.5Mb
SQL Antipatterns: Avoiding the Pitfalls of Database Programming /by Bill Karwin. Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now hes sharing his collection of antipatterns the most common errors he is identified in those thousands of requests for help.
Most developers arent 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. Whats more, it shows you whats behind these fixes, so youll 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 anti?patterns in terms of logical database design, physical database design, queries, and application development.
The chances are good that your applications 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 is playbook. Now you can stamp out these common database errors once and for all.
Whatever platform or programming language you use, whether you are 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 will 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.
We need your support!
Make a donation to help us stay online
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem
Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u
USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm
Information |
|||
![]() |
Users of GUESTS are not allowed to comment this publication. | ||









