BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming
Stock photo: cover may vary

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming Paperback - 2022

by Bill Karwin

Add to wish list

Reader reviews for SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

Write a review for this book

There are no reviews for this book yet. Be the first to write a review!

Your review will be anonymous unless you login or create an account first.

Overall rating
Remember: You’re rating the book as a work, not the seller or the condition of the specific copy you purchased!

Important Terms and Guidelines

  • Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
  • Reviews must be at least 140 characters in length.
  • Please do not reveal critical plot elements.
  • This is not a help line. Contact customer support if you need help.
Your review must not include:
  • Obscenities, discriminatory language, or other insulting language not suitable for public domain
  • Advertisements, “spam” content, or references to other products, offers or websites.
  • Email addresses, URLs, phone numbers, physical addresses or other contact information.
  • Overly critical comments about other reviews or reviewers
  • Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
  • Availability, price, or alternative ordering/shipping information

From the publisher

SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these common blunders. Refactor an inherited nightmare into a data model that really works. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand new mini-antipatterns for quick wins.

No matter which platform, framework, or language you use, the database is the foundation of your application, and the SQL database language is the standard for working with it. Antipatterns are solutions that look simple at the surface, but soon mire you down with needless work. Learn to identify these traps, and craft better solutions for the often-asked questions in this book. Avoid the mistakes that lead to poor performance and quality, and master the principles that make SQL a powerful and flexible tool for handling data and logic.

Dive deep into SQL and database design, and learn to recognize the most common missteps made by software developers in database modeling, SQL query logic, and code design of data-driven applications. See practical examples of misconceptions about SQL that can lure software projects astray. Find the greatest value in each group of data. Understand why an intersection table may be your new best friend. Store passwords securely and don't reinvent the wheel. Handle NULL values like a pro. Defend your web applications against the security weakness of SQL injection.

Use SQL the right way - it can save you from headaches and needless work, and let your application really shine!

What You Need:

The SQL examples use the MySQL 8.0 flavor, but other popular brands of RDBMS are mentioned. Other code examples use Python 3.9+ or Ruby 2.7+.

Details

  • Title SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming
  • Author Bill Karwin
  • Binding Paperback
  • Pages 380
  • Volumes 1
  • Language ENG
  • Publisher Pragmatic Bookshelf
  • Publication date 2022-11-29
  • ISBN 9781680508987 / 1680508989
  • Weight 1.44 lbs (0.65 kg)
  • Dimensions 9.25 x 7.5 x 0.78 in (23.50 x 19.05 x 1.98 cm)
  • Category Computers - Languages / Programming

About the author

Bill Karwin has been a software engineer for over thirty years, developing and supporting applications, libraries, and servers, and consulting for leading technology companies. 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.

Back to top↑

More Copies for Sale

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

by Bill Karwin

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
10
Seller
The Saint Bookstore
Biblio Top Seller
Item price
A$62.35
A$19.21 Delivery to USA

Show details

Description:
Paperback / softback. New.
Add to wish list
Item price
A$62.35
A$19.21 Delivery to USA
SQL Antipatterns, Volume 1 : Avoiding the Pitfalls of Database Programming

SQL Antipatterns, Volume 1 : Avoiding the Pitfalls of Database Programming

by Bill Karwin

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
1071
Seller
Ria Christie Collections
Item price
A$70.36
A$15.43 Delivery to USA

Show details

Description:
Paperback. New. New Book; Fast Shipping from UK; Not signed; Not First Edition; SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend
Add to wish list
Item price
A$70.36
A$15.43 Delivery to USA
Sql Antipatterns
Stock photo: cover may vary

Sql Antipatterns

by Karwin, Bill,

  • New
Condition
New
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
3
Seller
GreatBookPrices
Item price
A$61.24
A$5.78 Delivery to USA

Show details

Description:
new.
Add to wish list
Item price
A$61.24
A$5.78 Delivery to USA
SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming [Paperback] Karwin, Bill
Stock photo: cover may vary

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming [Paperback] Karwin, Bill

  • New
Condition
New
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
4
Seller
Mediaoutletdeal1
Item price
A$61.25
A$5.78 Delivery to USA

Show details

Description:
New. 0x0x0.
Add to wish list
Item price
A$61.25
A$5.78 Delivery to USA
Sql Antipatterns
Stock photo: cover may vary

Sql Antipatterns

by Karwin, Bill,

  • Used
Condition
New
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
3
Seller
GreatBookPrices
Item price
A$74.67
A$5.78 Delivery to USA

Show details

Description:
like new.
Add to wish list
Item price
A$74.67
A$5.78 Delivery to USA
SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming [Paperback] Karwin, Bill
Stock photo: cover may vary

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming [Paperback] Karwin, Bill

  • Used
Condition
New
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
4
Seller
Mediaoutletdeal1
Item price
A$74.69
A$5.78 Delivery to USA

Show details

Description:
Like New. 0x0x0.
Add to wish list
Item price
A$74.69
A$5.78 Delivery to USA
SQL Antipatterns: Avoiding the Pitfalls of Database Programming: Vol 1
Stock photo: cover may vary

SQL Antipatterns: Avoiding the Pitfalls of Database Programming: Vol 1

by Karwin, Bill

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
2
Seller
Revaluation Books
Item price
A$111.56
A$28.96 Delivery to USA

Show details

Description:
Pragmatic Bookshelf, 2022. Paperback. New. 340 pages. 9.25x7.50x0.78 inches.
Add to wish list
Item price
A$111.56
A$28.96 Delivery to USA
SQL Antipatterns, Volume 1
Stock photo: cover may vary

SQL Antipatterns, Volume 1

  • New
Condition
New
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
3
Seller
Cold Books
Item price
A$109.35
A$5.78 Delivery to USA

Show details

Description:
. Papeback. New.
Add to wish list
Item price
A$109.35
A$5.78 Delivery to USA
SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming
Stock photo: cover may vary

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

by Karwin, Bill

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9781680508987 / 1680508989
Quantity available
1
Seller
Bonita
Item price
A$111.46
Free Delivery to USA

Show details

Description:
paperback. Good. Access codes and supplements are not guaranteed with used items. May be an ex-library book.
Add to wish list
Item price
A$111.46
Free Delivery to USA
Show all copies
Back to top↑

Please wait a moment while we load the requested page.