SQL Antipatterns, Volume 1

Avoiding the Pitfalls of Database Programming



Bookstore > Books > SQL Antipatterns, Volume 1

Price$47.95
Rating
AuthorBill Karwin
PublisherThe Pragmatic Programmers
Published2022
Pages340
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101680508989
ISBN-139781680508987
EBook Hardcover Paperback

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!


  1. (2 books)


4 5 480

Similar Books


Deep Belief Nets in C++ and CUDA C: Volume 1

Deep Belief Nets in C++ and CUDA C: Volume 1

by Timothy Masters

Discover the essential building blocks of the most common forms of deep belief networks. At each step this book provides intuitive motivation, a summary of the most important equations relevant to the topic, and concludes with highly commented code for threaded computation on modern CPUs as well as massive parallel processing on computers...

Price:  $32.13  |  Publisher:  Apress  |  Release:  2018

Using and Administering Linux: Volume 1

Using and Administering Linux: Volume 1

by David Both

Become a Linux sysadmin and expert user of Linux, even with no previous Linux experience and learn to manage complex systems with ease. Volume 1 of this three volume training course introduces operating systems in general and Linux in particular. It briefly explores the The Linux Philosophy for SysAdmins in preparation for the rest of the...

Price:  $29.54  |  Publisher:  Apress  |  Release:  2020

Write Great Code, Volume 1

Write Great Code, Volume 1

by Randall Hyde

Today's programmers are often narrowly trained because the industry moves too fast. That's where Write Great Code, Volume 1: Understanding the Machine comes in. This, the first of four volumes by author Randall Hyde, teaches important concepts of machine organization in a language-independent fashion, giving programmers what the...

Price:  $31.71  |  Publisher:  No Starch Press  |  Release:  2004

Windows Server 2012 R2 Inside Out Volume 1

Windows Server 2012 R2 Inside Out Volume 1

by William Stanek

This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds for Windows Server 2012 R2 - with a focus on configuration, storage, and essential administrative tasks....

Price:  $39.21  |  Publisher:  Microsoft Press  |  Release:  2014

Resilient Oracle PL/SQL

Resilient Oracle PL/SQL

by Stephen B. Morris

As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, an...

Price:  $79.99  |  Publisher:  O'Reilly Media  |  Release:  2023

Using and Administering Linux: Volume 2

Using and Administering Linux: Volume 2

by David Both

Experience an in-depth exploration of logical volume management and the use of file managers to manipulate files and directories and the critical concept that, in Linux, everything is a file and some fun and interesting uses of the fact that everything is a file.This book builds upon the skills you learned in Volume 1 of this course and i...

Price:  $34.20  |  Publisher:  Apress  |  Release:  2020

Using and Administering Linux: Volume 3

Using and Administering Linux: Volume 3

by David Both

Manage complex systems with ease and equip yourself for a new career. This book builds upon the skills you learned in Volumes 1 and 2 of this course and it depends upon the virtual network and virtual machine you created there. However, more experienced Linux users can begin with this volume and download an assigned script that will set u...

Price:  $30.86  |  Publisher:  Apress  |  Release:  2020

Encyclopedia of Electronic Components Volume 1

Encyclopedia of Electronic Components Volume 1

by Charles Platt

Want to know how to use an electronic component? This first book of a three-volume set includes key information on electronics parts for your projects-complete with photographs, schematics, and diagrams. You'll learn what each one does, how it works, why it's useful, and what variants exist. No matter how much you know about ele...

Price:  $14.69  |  Publisher:  O'Reilly Media  |  Release:  2012