SQL Antipatterns, by Bill Karwin, Pragmatic Bookshelf, mention of a broad variety of databases such as MySQL, Oracle, SQL Server. Common blunders of SQL database design, queries, and software SQL Antipatterns Strike Back Bill Karwin 1 Monday, April 20, 1. Bill Karwin has helped thousands of people write better SQL and buildstronger relational databases. Now he’s sharing his collection of antipatterns–the most.

Author: Saran Mugul
Country: Tajikistan
Language: English (Spanish)
Genre: Finance
Published (Last): 28 December 2009
Pages: 146
PDF File Size: 3.53 Mb
ePub File Size: 4.12 Mb
ISBN: 269-6-49820-240-8
Downloads: 32327
Price: Free* [*Free Regsitration Required]
Uploader: Nisar

Rails especially has the mysterious controller helpers that no one really understands, but the always-safe-bet is put your services-like logic in A must-read for beginners, good for intermediate.

Book Review – SQL Antipatterns

Concise, stand-alone chapters allow you to easily find and read about specific topics. Mar 02, Todor rated it really liked it. Working with data analytics, I found part 3 to be the most useful with Query Antipatterns.

Throughout his career, Bill has shared his knowledge to help other katwin achieve success and productivity. Skip to main content. If you are working with relational databases definitely give it a read.

I just want to warn everyone reading it, to give it a chance and read the whole of it.

SQL Antipatterns by Bill Karwin

So I knew most of the anti patterns and their solution. Mar 19, Adi rated it really liked it. The book is well-written, and I will likely require it of my students if I ever A very good book for younger developers, but I’ve learned kzrwin of these solutions already so I wanted a bit more out of this book.


Leave a Comment Posted on January 10, by vladmihalcea. What’s most important to read and understand thoroughly is the “Logical Kawin Design Anti-patterns” chapters.

I am a strong advocate of best practices.

SQL Antipatterns

This post is a review of what this book is all about and why you should be interested sal reading it. With many relational database systems available in the market, I find there is not much need to design a RDBMS product to the level this book gives.

The message throughout the book is: A sound coverage of typical SQL schema mistakes, with a useful exposition of the choices available in implementing inheritance.

Use the Right Tool for the Job Chapter If you’re a developer struggling with database problems, I’d say, pick this book antipatterhs.

Establish Primary Key Conventions Antipattern: I struggled for a long time with a database that had a large tree structure, so I’m always looking for better ways of dealing with trees in databases. After a lot of work, I finally ended up with what anipatterns equates to the Enumerated Path pattern. It’s still a good read. Majority of the issues are addressed with proper training so I can see this book would be good for those who are self learners who may not antipattrns many opportunities for formal training.


If you’re advanced with SQL, you already know these patterns. Bill has succeeded in making the teachings accessible for developers in a good descriptive form, as well as being easy to reference later. Apr 02, Jason rated it really liked it Recommends it for: I wish I had read this book sooner. Feb 23, David rated it kxrwin it.

Bill Karwin collected the most uses anti-patterns and explains how you can do a better job.

Distinguish Missing Values Antipattern: For the reader with no experience in database design another book should be read first to gain a thorough understanding of the basics. Harmed with this knowledge, I should not repeat those mistakes and I should have better arguments next time someone in my team is about to commit one. Developers and DBAs antipwtterns would benefit from this read. This website uses cookies for account and order processing. Model the Subtypes Chapter 7: Goodreads helps you keep track of books you want to read.

It isn’t a very long book but you get the sense that the advice given came from some hard learned lessons on the job.