SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Paperback)

Bill Karwin (author)

£27.99

Paperback 300 Pages / Published: 13/07/2010

We can order this

Usually despatched within 1 week

Synopsis

Your database is the foundation of your application. Many programmers assume it's also the bottleneck of productive software development, but with the right techniques, this doesn't have to be true. SQL Antipatterns illustrates some of the most common misconceptions and pitfalls software developers face using relational databases. This book helps you to use a database to produce the most efficient results, and turn sluggish, inflexible code and thankless late-night hours into high-quality, reliable solutions and a job well done. The SQL database programming language is the core of most software in the world, but if you're like most software developers, you're self-taught in SQL, and you know just enough to get by. As a result, you might design fragile databases that cannot scale as the business grows, write queries that produce incorrect results and not know why, or deploy applications that are vulnerable to hackers. Don't reinvent the wheel to solve problems SQL was designed to solve--this book will teach you new SQL techniques for getting your job done. 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.

Publisher: The Pragmatic Programmers
ISBN: 9781934356555
Number of pages: 300
Weight: 706 g
Dimensions: 229 x 191 x 27 mm

MEDIA REVIEWS

""This book is obviously the product of many years of practical experience with SQL databases. Each topic is covered in great depth, and the attention to detail in the book was beyond my expectations. Although it's not a beginner's book, any developer with a reasonable amount of SQL experience should find it to be a valuable reference and would be hard-pressed not to learn something new.""--Mike Naberezny, Partner at Maintainable Software; Coauthor of "Rails for PHP Developers"

""Bill has written an engaging, useful, important, and unique book. Software developers will certainly benefit from reading the antipatterns and solutions described here. I immediately applied techniques from this book and improved my applications. Fantastic work!""--Frederic Daoud, Author of "Stripes: ...And Java Web Development Is Fun Again" and "Getting Started with Apache Click"