- Buy this product and stream 90 days of Amazon Music Unlimited for free. E-mail after purchase. Conditions apply. Learn more
SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers) Paperback – 10 Jul 2017
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Special offers and product promotions
Frequently bought together
Customers who viewed this item also viewed
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
""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"
About the Author
Bill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5, the InterBase relational database, and the Enhydra Java application server. Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.
Customers who bought this item also bought
There was a problem filtering reviews right now. Please try again later.
I gave it 4 stars because I enjoyed the read, I would have given it 5 if I had learned more new stuff. If you are new to DBA/Dev then it would probably be a 5 star book for you.
The book has 25 short chapters, split into 4 sections, each chapter explaining a common error or anti-pattern in database use.
While I haven't made all of these mistakes I've at least made some of them and seen other people make even more of them: SQL injection (21), SQL Spaghetti Query (18) - trying to do everything in one query , naive trees (3) - fixed depth, to name but a few.
The book is well written and actually quite funny in parts and it joins my very small library of great database books which includes : Essence of databases (for an overview), Sams SQL in 10 minutes (for syntax) and High Performance MySQL (MySQL only). My rule of thumb is thinner books are better, although High Performance MySQL is an exception.
Recommended, probably most use if you're at an intermediate level.
As a team leader in a dev shop, this is the kind of book that I want all my team to read. I'm going to get a few more copies for the company and add it the required reading list along the Code Complete and Clean Code.