SQL Antipatterns, Volume 1
Avoiding the Pitfalls of Database Programming
Price | $47.95
|
Rating | ![]() ![]() ![]() ![]() ![]() |
Author | Bill Karwin |
Publisher | The Pragmatic Programmers |
Published | 2022 |
Pages | 340 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 1680508989 |
ISBN-13 | 9781680508987 |
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!

- Bill Karwin (2 books)
4 5 480
Similar Books
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
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
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
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
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
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
Write Great Code: Volume 1, 2nd Edition
by Randall Hyde
This, the first volume in Randall Hyde's Write Great Code series, dives into machine organization without the extra overhead of learning assembly language programming. Written for high-level language programmers, Understanding the Machine fills in the low-level details of machine organization that are often left out of computer scien...
Price: $32.99 | Publisher: No Starch Press | Release: 2020
by David Crookes, Andrew Gillett, Liz Upton, Eben Upton, Sean M. Tracey, Dan Malone, Allister Brimble
This stunning 224-page hardback book not only tells the stories of some of the seminal video games of the 1970s and 1980s, but shows you how to create your own games inspired by them using Python and Pygame Zero, following examples programmed by Raspberry Pi founder Eben Upton.In the first of two volumes, we remake five classic video game...
Price: $17.07 | Free ebook | Publisher: Raspberry Pi Press | Release: 2019