NewTechReview: Home | CoolTechShop | Articles | Downloads (Free Software) | Videos | Newsletter (FREE) | Issues | News | Reviews | Recommend | Contest | RSS Feed

Free Gadget and Consumer Technology Newsletter - Click here!

Find great deals on SQL at Shopzilla.com!
Scott R. Garrigus'  NewTechReview - Free new technology news, reviews, tips and techniques! Free technology news, articles, reviews, tips and tutorials
for consumers and small business users!
 
 
SRG Sites > NewTechReview > News > Pragmatic Bookshelf Publishes SQL Antipatterns - Avoiding the Pitfalls of Database Programming

Pragmatic Bookshelf Publishes SQL Antipatterns - Avoiding the Pitfalls of Database Programming

Applications that store data often end up using SQL, either directly or through a mapping layer. Well, here's a sad secret—most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong.

Author 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 in his new book.

SQL Antipatterns: Avoiding the Pitfalls of Database Programming shows you all the common mistakes and 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.

For more information: SQL Antipatterns - Avoiding the Pitfalls of Database Programming
Find great deals on SQL at Shopzilla.com!
[Back to the News Index]
 
Free consumer technology newsletter (E-mail):   [About Your Privacy]

NewTechReview: Home | RSS Feed | CoolTechShop | Articles | Downloads (Free Software) | Videos | Newsletter (FREE) | Issues | News | Reviews | Recommend | Contest

SRG Sites: DigiFreq | Power Books | NewTechReview

Copyright © 2010 by Scott R. Garrigus. All Rights Reserved. --- Privacy Policy  

NewTechReview is for informational purposes only. - Disclosure Statement