More SQL Antipatterns

Name: More SQL Antipatterns
Brand: Pragmatic Programmers
Price: 75.75 AUD
Availability: PreOrder

Avoid Common but Deadly Mistakes of Database Optimization

By: Bill Karwin, Jacquelyn Carter (Editor)

Write A Review

Paperback | 24 September 2026

At a Glance

Format
Paperback

Dimensions(cm)
23.4 x 19.0 x 1.2

Paperback

RRP $94.99

$75.75

20%OFF

or 4 interest-free payments of $18.94 with

Available: 24th September 2026

Preorder. Will ship when available.

Don't make the mistakes most people make when optimizing your database.

It's easy to get something working with SQL but getting it working well requires skill and experience. Rather than learning by trial and error, let renowned database expert Bill Karwin give you the benefit of his years of experience as he shows you the mistakes people make and how to fix them.

Dig into SQL language issues rarely covered in other books. Learn advanced queries such as relational division, efficient pagination, and pivoting. Explore tradeoffs in optimization, including denormalization, JSON, and choosing SQL versus NoSQL. Turn mistakes into successes by employing SQL in application design: transactions, polling, and object-relational mapping. Finally, take a deep dive into scaling out with sharded databases.

This book contains fourteen all-new topics, making it a valuable complement to SQL Antipatterns Volume 1. In each chapter, you'll learn how to recognize one type of common pitfall, and how to solve it. Examples use the current popular combination of PostgreSQL and Python, but the principles apply to any modern database and language. Like the first volume, this book also includes a selection of mini-antipatterns, or brief tips you can use for quick wins.

Optimize SQL the right way and graduate from journeyman to senior database developer.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.