SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)

3.93 avg rating
( 306 ratings by Goodreads )
 
9781934356555: SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)
View all copies of this ISBN edition:
 
 

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.

Most developers aren't 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. 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.

"synopsis" may belong to another edition of this title.

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.

Review:

""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 this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Karwin, Bill
Published by Pragmatic Bookshelf 7/5/2010 (2010)
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Paperback or Softback Quantity Available: 5
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Pragmatic Bookshelf 7/5/2010, 2010. Paperback or Softback. Condition: New. SQL Antipatterns: Avoiding the Pitfalls of Database Programming. Book. Seller Inventory # BBS-9781934356555

More information about this seller | Contact this seller

Buy New
US$ 23.16
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

2.

Karwin, Bill
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Quantity Available: 1
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2010. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Seller Inventory # KB-9781934356555

More information about this seller | Contact this seller

Buy New
US$ 19.67
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

3.

Bill Karwin
Published by The Pragmatic Programmers, United States (2010)
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Paperback Quantity Available: 10
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description The Pragmatic Programmers, United States, 2010. Paperback. Condition: New. Language: English. Brand new Book. 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. Seller Inventory # APC9781934356555

More information about this seller | Contact this seller

Buy New
US$ 27.15
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

4.

Karwin, Bill
Published by Pragmatic Bookshelf (2018)
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(NORTH MIAMI BEACH, FL, U.S.A.)
Rating
[?]

Book Description Pragmatic Bookshelf, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 1934356557

More information about this seller | Contact this seller

Buy New
US$ 27.20
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

5.

Karwin, Bill
Published by Pragmatic Bookshelf
ISBN 10: 1934356557 ISBN 13: 9781934356555
New PAPERBACK Quantity Available: 15
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)
Rating
[?]

Book Description Pragmatic Bookshelf. PAPERBACK. Condition: New. 1934356557 BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|1.45. Seller Inventory # OTF-Y-9781934356555

More information about this seller | Contact this seller

Buy New
US$ 23.24
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

6.

Bill Karwin
Published by Pragmatic Bookshelf (2010)
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Pragmatic Bookshelf, 2010. Paperback. Condition: New. 1. Seller Inventory # DADAX1934356557

More information about this seller | Contact this seller

Buy New
US$ 26.88
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

7.

Bill Karwin
Published by Pragmatic Bookshelf
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description Pragmatic Bookshelf. Paperback. Condition: New. 328 pages. 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 hes 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 antipatterns 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 experts playbook. Now you can stamp out these common database errors once and for all. Whatever platform or programming language you use, whether youre 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. Youll 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. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781934356555

More information about this seller | Contact this seller

Buy New
US$ 31.96
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

8.

Bill Karwin
Published by The Pragmatic Programmers, United States (2010)
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Paperback Quantity Available: 10
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description The Pragmatic Programmers, United States, 2010. Paperback. Condition: New. Language: English. Brand new Book. 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. Seller Inventory # APC9781934356555

More information about this seller | Contact this seller

Buy New
US$ 32.10
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

9.

Karwin, Bill
Published by Pragmatic Bookshelf (2010)
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Paperback Quantity Available: 10
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Pragmatic Bookshelf, 2010. Paperback. Condition: New. Seller Inventory # INGM9781934356555

More information about this seller | Contact this seller

Buy New
US$ 28.88
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

10.

Bill Karwin
Published by Pragmatic Bookshelf (2010)
ISBN 10: 1934356557 ISBN 13: 9781934356555
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Pragmatic Bookshelf, 2010. Condition: New. book. Seller Inventory # MB011DC04EK

More information about this seller | Contact this seller

Buy New
US$ 30.45
Convert currency

Add to Basket

Shipping: US$ 3.27
Within U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book