Sign-In
Cart
SQL That Scales: Queries, Indexes, and Performance You Can Prove
Paperback
Publisher: Independently Published
Published: Feb 23 2026
Pages: 184
Weight: 0.56
Height: 0.39 Width: 6.00 Depth: 9.00
Language: English
Most SQL books stop at syntax. This one starts where production pain begins. You'll learn how databases actually execute queries, how indexes truly work under the hood, and how to measure performance with evidence-not opinions. Through real-world examples, execution plans, and repeatable experiments, this book shows you how to turn slow, fragile queries into fast, predictable systems that scale with confidence.
Whether you're tuning a single query or designing data access for millions of users, SQL That Scales teaches you how to think like the optimizer, choose the right indexes, and validate every performance decision with proof. No cargo-cult advice. No magical thinking. Just SQL that holds up under load.
Inside you'll learn how to:
Read and reason about execution plans like a pro
Design indexes that improve performance without hidden tradeoffs
Write queries that stay fast as data volume grows
Measure and prove performance improvements using real metrics
Avoid common scaling traps that silently kill throughput
If you care about performance, reliability, and building systems that won't collapse at scale, this is the SQL book you've been waiting for.
Also from
Hawthorn, Amara
Godot Game Dev for Beginners: Make your first 2D and 3D games with the open-source Godot engine - no prior coding needed
Hawthorn, Amara
Paperback
Svelte & SvelteKit for Beginners: Develop high-performance web apps with Svelte - the modern framework without the fuss
Hawthorn, Amara
Paperback
Java Concurrency Mastery: Parallel and Multi-Threaded Programming Techniques
Hawthorn, Amara
Paperback
COBOL for a New Generation: A beginner's guide to an old language - maintain and modernize mainframe code
Hawthorn, Amara
Paperback
Refactoring Fundamentals: Learn to improve and restructure your code safely - a beginner's approach to cleaner code
Hawthorn, Amara
Paperback
Browser Extension Workshop: Create your own Chrome and Firefox extensions through step-by-step projects
Hawthorn, Amara
Paperback
Creative Automation for Designers: Write simple scripts to automate graphic design and media tasks (Adobe & beyond)
Hawthorn, Amara
Paperback
Git for Everyone Version Control Made Easy: A beginner's guide to Git and GitHub for solo projects and team collaboration
Hawthorn, Amara
Paperback
Data Wrangling 101: Clean and transform messy data using Python and open-source tools - for absolute beginners
Hawthorn, Amara
Paperback
Low-Level Linux: Memory, Syscalls, and Performance Tuning from the Metal Up
Hawthorn, Amara
Paperback
Writing Developer Documentation: A beginner's guide to documenting code, APIs, and projects clearly and effectively
Hawthorn, Amara
Paperback
Web Scraping for Beginners: Collect data from websites using Python - ethically and efficiently
Hawthorn, Amara
Paperback
Self-Hosting Handbook: Deploy your own web applications and services on a VPS or home server - an intro for indie developers
Hawthorn, Amara
Paperback
Rust Patterns in Practice: Ownership, Lifetimes, and Zero-Cost Abstractions
Hawthorn, Amara
Paperback
Python Crash Course: The Ultimate Beginner's Guide to Programming Fundamentals
Hawthorn, Amara
Paperback
JavaScript Projects in Action: Build Interactive Web Apps with React and Vue
Hawthorn, Amara
Paperback
Project-Based Python UI Automation (No GUI library names): Automate applications and workflows using scripts
Hawthorn, Amara
Paperback
GraphQL from Ground Zero: Build your first API with GraphQL - a project-based intro for REST developers and beginners
Hawthorn, Amara
Paperback
AR & VR for New Developers: An introductory guide to building simple augmented and virtual reality apps
Hawthorn, Amara
Paperback
Smart Game AI Made Simple: Program intelligent game characters and NPCs without a PhD - for beginners
Hawthorn, Amara
Paperback
Bug Bounty Bootcamp for Beginners: Find your first web app vulnerabilities and get started in bug bounty hunting
Hawthorn, Amara
Paperback
Data Visualization for Beginners: Turn raw data into charts and interactive dashboards using free tools and a bit of code
Hawthorn, Amara
Paperback
Smart Contracts for Beginners: Build your first blockchain applications and dApps without the hype
Hawthorn, Amara
Paperback
Web Accessibility for Developers: An introductory handbook to building inclusive websites (WCAG basics for beginners)
Hawthorn, Amara
Paperback
Carbon Unleashed: Safer Successor-Style Systems Programming for Large Teams
Hawthorn, Amara
Paperback
Chatbot Building for Beginners: Create your own simple chatbots and conversational assistants without heavy AI math
Hawthorn, Amara
Paperback
Low-Level Programming Basics: Get started with C and Assembly to see how software works at the hardware level
Hawthorn, Amara
Paperback
Legacy Code Survival Guide: Tips and techniques for understanding and improving inherited codebases for junior developers
Hawthorn, Amara
Paperback
Windows PowerShell for Absolute Beginners: Automate Windows tasks and manage your system with simple PowerShell Scripts
Hawthorn, Amara
Paperback
Modern C++ Mastery: Patterns, Tooling, and Performance for 21st-Century C++
Hawthorn, Amara
Paperback
Data Structures in Rust: Implementations, Benchmarks, and Production Tactics
Hawthorn, Amara
Paperback
The C++ Exit Plan: How to Move Mission-Critical Code to Safer, Modern Stacks
Hawthorn, Amara
Paperback
JavaScript Performance Tuning: Optimizing Your Code for Speed and Efficiency
Hawthorn, Amara
Paperback
Java for Absolute Beginners: A Step-by-Step Guide to Core Programming Concepts
Hawthorn, Amara
Paperback
Advanced Python Metaprogramming: Mastering Decorators, Metaclasses, and Code Generation
Hawthorn, Amara
Paperback
Modern C++ Practices: Writing Safe and Efficient Code with C++11 and Beyond
Hawthorn, Amara
Paperback
Mastering Python: A Comprehensive Guide to Writing Clean, Efficient, and Maintainable Code
Hawthorn, Amara
Paperback
Haskell Practical Guide: Functional Programming Techniques for Real-World Projects
Hawthorn, Amara
Paperback
Modern JavaScript Essentials: From ES6 Features to Next-Gen Web Development
Hawthorn, Amara
Paperback
Hands-On Python Projects: Build Real-World Applications with Python 3 and Beyond
Hawthorn, Amara
Paperback
Testing Python Applications: Test-Driven Development with pytest and unittest
Hawthorn, Amara
Paperback
Python for Automation: Automate Tasks, Web Scraping, and Workflow Orchestration
Hawthorn, Amara
Paperback
Scala Functional Programming: Building Reactive Systems with Akka and Streams
Hawthorn, Amara
Paperback
Front-End Engineering with JavaScript: Frameworks, State Management, and Performance
Hawthorn, Amara
Paperback
JavaScript Security Essentials: Secure Coding Practices for Front-End and Back-End
Hawthorn, Amara
Paperback
Kotlin for Android Development: Modern Programming Techniques and Best Practices
Hawthorn, Amara
Paperback
Java Testing Strategies: Unit, Integration, and End-to-End Testing with JUnit and Mockito
Hawthorn, Amara
Paperback
Full-Stack JavaScript Development: Building End-to-End Apps with Node, Express, and React
Hawthorn, Amara
Paperback
Learning Rust for Automation Projects: Automate everyday tasks with Rust scripts and tools
Hawthorn, Amara
Paperback
FastAPI Web Services for Beginners: Build lightning-fast Python APIs with modern tools - a step-by-step project Guide
Hawthorn, Amara
Paperback
Go Language Projects for Beginners: Learn Google's Go (Golang) by building practical tools and microservices
Hawthorn, Amara
Paperback
Competitive Programming Primer: Ace the basics of coding challenges with step-by-step problem solving strategies
Hawthorn, Amara
Paperback
Go Game Development for Beginners: Build playable games with Go step by step
Hawthorn, Amara
Paperback
Kotlin for Web Scraping Projects: Practical scraping and data extraction using Kotlin
Hawthorn, Amara
Paperback
Mastering Regex Without Tears: A beginner's guide to regular expressions - search and manipulate text like a pro
Hawthorn, Amara
Paperback
Computer Vision in Plain English: Learn image recognition and object detection through fun projects - for absolute beginners
Hawthorn, Amara
Paperback
Spreadsheet Automation with Python: Replace tedious Excel tasks with simple Python scripts - a guide for non- programmers
Hawthorn, Amara
Paperback
Building Apps for the Next Billion: Optimize mobile apps for emerging markets (offline-first, lightweight, multilingual)
Hawthorn, Amara
Paperback
Explainable AI for Beginners: Demystify machine learning with simple models you can interpret and trust
Hawthorn, Amara
Paperback
Open-Source Smart Home Automation: Control your home with Home Assistant and DIY electronics - a beginner's Guide
Hawthorn, Amara
Paperback
Android UIs with Jetpack Compose: Create modern Android app interfaces in Kotlin - a project-based introduction
Hawthorn, Amara
Paperback
Drone Coding for Beginners: Program and customize your own drone - from simple flight automation to aerial tricks
Hawthorn, Amara
Paperback
Java Performance Engineering: Profiling and Optimizing Enterprise Applications
Hawthorn, Amara
Paperback
Algorithmen für vielbeschäftigte Ingenieure: Praktische Schnittmuster, die Sie tatsächlich verwenden werden
Hawthorn, Amara
Paperback
Angewandte NLP mit Python: Textbereinigung, Einbettungen und praktische Anwendung
Hawthorn, Amara
Paperback
Automatisieren Sie es mit Python: Skripte, Zeitpläne und kleine Hilfsmittel, die wirklich etwas bewirken
Hawthorn, Amara
Paperback
Sauberer Code, saubere Teams: Gewohnheiten, Rezensionen und gemeinsame Standards
Hawthorn, Amara
Paperback
Carbon Unleashed: Sicherere Systemprogrammierung im Nachfolgerstil für große Teams
Hawthorn, Amara
Paperback
Datenverträge: Sicherere Schnittstellen zwischen Produzenten und Konsumenten
Hawthorn, Amara
Paperback
API-Design mit TypeScript: Vertragsorientiert, sichere Kunden, schnellere Teams
Hawthorn, Amara
Paperback
dbt anhand eines Beispiels: Versionierte Transformationen und Datenverträge
Hawthorn, Amara
Paperback
Datenstrukturen in Rust: Implementierungen, Benchmarks und Produktionstaktiken
Hawthorn, Amara
Paperback
FastAPI anhand von Beispielen: Produktions-APIs mit Typisierung, Tests und Dokumentation
Hawthorn, Amara
Paperback
Von der Unterstufe zur Oberstufe: Systemisches Denken, Eigenverantwortung und Mentoring
Hawthorn, Amara
Paperback
Erlang in der realen Welt: Zuverlässigkeit auf Telekommunikationsniveau für jedes Backend
Hawthorn, Amara
Paperback
Flutter UI-Meisterschaft: Animationen, Themen und Designsysteme in großem Umfang
Hawthorn, Amara
Paperback
Elixier für Pragmatiker: Parallelverarbeitung, Fehlertoleranz und freudvoller Code
Hawthorn, Amara
Paperback
Bereit fürs Vorstellungsgespräch: Datenstrukturen, Systemdesign und klare Kommunikation
Hawthorn, Amara
Paperback
Also in
Programming
Interactive Theorem Proving and Program Development: Coq'art: The Calculus of Inductive Constructions
Castéran, Pierre
Bertot, Yves
Hardcover
Seven Databases in Seven Weeks: A Guide to Modern Databases and the Nosql Movement
Redmond, Eric
Wilson, Jim
Perkins, Luc
Paperback
The Legend of Zelda(tm) Tears of the Kingdom - The Complete Official Guide: Collector's Edition
Piggyback
Hardcover
Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to Programming
Matthes, Eric
Paperback
Crisis Engineering: Time-Tested Tools for Turning Chaos Into Clarity
Nitze, Marina
Weaver, Matthew
Dickerson, Mikey
Paperback
Vibe Coding: Building Production-Grade Software with Genai, Chat, Agents, and Beyond
Yegge, Steve
Kim, Gene
Paperback
Accelerate: The Science of Lean Software and DevOps: Building and Scaling High Performing Technology Organizations
Humble, Jez
Kim, Gene
Forsgren Phd, Nicole
Paperback
The Legend of Zelda(tm) Tears of the Kingdom - The Complete Official Guide: Standard Edition
Piggyback
Paperback
Embedded Systems with ARM Cortex-M Microcontrollers in Assembly Language and C: Fourth Edition
Zhu, Yifeng
Paperback
Fundamentals of Software Architecture: A Modern Engineering Approach
Richards, Mark
Ford, Neal
Paperback
I Have an App Idea: The Essential Guide to Building an App Without Tech Skills
Spann, Amanda
Paperback
AI Projects with Raspberry Pi: High-Performance Artificial Intelligence for Robotics, Security, Home Automation, and Vision
Hattersley, Lucy
Jepson, Brian
Paperback
The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
Fournier, Camille
Paperback
Make: Electronics: Learning by Discovery: A Hands-On Primer for the New Electronics Enthusiast
Platt, Charles
Paperback
The Devops Handbook, 2nd Edition: How to Create World-Class Agility, Reliability, & Security in Technology Organizations
Humble, Jez
Debois, Patrick
Kim, Gene
Paperback
Building Applications with AI Agents: Designing and Implementing Multiagent Systems
Albada, Michael
Paperback
Cracking the Coding Interview: 189 Programming Questions and Solutions
McDowell, Gayle Laakmann
Paperback
The Developer's Guide to AI: A Field Guide for the Working Developer
Orshalick, Jacob
Reghunadh, Jerry M.
Thompson, Danny
Paperback
The New AI Cold War: Liberty vs. Tyranny in the Age of Machine Empires
Maginnis, Ltc Robert L.
Paperback
Learning Web Design: A Beginner's Guide to Html, Css, Javascript, and Web Images
Robbins, Jennifer
Paperback
The Staff Engineer's Path: A Guide for Individual Contributors Navigating Growth and Change
Reilly, Tanya
Paperback
Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures
Sadalage, Pramod
Ford, Neal
Richards, Mark
Paperback
The Official Raspberry Pi Handbook 2026: Astounding Projects with Raspberry Pi Computers
Makers of Raspberry Pi Official Magazine, The
Paperback
Linux Basics for Hackers, 2nd Edition: Getting Started with Networking, Scripting, and Security in Kali
Occupytheweb
Paperback
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Hardcover
The Pragmatic Programmer: Your Journey to Mastery, 20th Anniversary Edition
Thomas, David
Hunt, Andrew
Hardcover
Generative AI Design Patterns: Solutions to Common Challenges When Building Genai Agents and Applications
Lakshmanan, Valliappa
Hapke, Hannes
Paperback
Head First Design Patterns: Building Extensible and Maintainable Object-Oriented Software
Robson, Elisabeth
Freeman, Eric
Paperback
Frictionless: 7 Steps to Remove Barriers, Unlock Value, and Outpace Your Competition in the AI Era
Forsgren, Nicole
Noda, Abi
Paperback
The Return on AI: From Promise to Profit in the Age of Intelligent Business
Sawhney, Mohanbir
Mittal, Ashwin
Paperback
Forecasting: Principles and Practice, the Pythonic Way
Athanasopoulos, George
Hyndman, Rob J.
Paperback
Observability Engineering: Achieving Production Excellence
Miranda, George
Majors, Charity
Fong-Jones, Liz
Paperback
Arduino Programming for Beginners: A Comprehensive Beginner's Guide to Learn the Realms of Arduino Programming from A-Z
Protosmith, Ada
Paperback
Building AI-Powered Products: The Essential Guide to AI and Genai Product Management
Nika, Marily
Paperback
Grokking Algorithms, Second Edition: An Illustrated Guide for Programmers and Other Curious People
Bhargava, Aditya Y.
Paperback
Concrete Mathematics: A Foundation for Computer Science
Patashnik, Oren
Knuth, Donald
Graham, Ronald
Hardcover
Debugging: The 9 Indispensable Rules for Finding Even the Most Elusive Software and Hardware Problems
Agans, David J.
Paperback
Learning Generative AI Tools for Excel: Speed Up Your Everyday Tasks with Microsoft Excel, Copilot, Chatgpt, and Beyond
Duca, Angelica Lo
Paperback
Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy
Khononov, Vlad
Paperback
This Is Service Design Doing: Applying Service Design Thinking in the Real World
Lawrence, Adam
Hormess, Markus Edgar
Stickdorn, Marc
Paperback
Computer Science from Scratch: Building Interpreters, Art, Emulators and ML in Python
Kopec, David
Paperback
The Software Architect Elevator: Redefining the Architect's Role in the Digital Enterprise
Hohpe, Gregor
Paperback
Python Programming for Young Coders: A Hands-On, Project-Based Introduction to Coding for Beginners, Kids, and Teens
Pandey, Anand
Paperback
Software Engineering at Google: Lessons Learned from Programming Over Time
Manshreck, Tom
Wright, Hyrum
Winters, Titus
Paperback
Prompt Engineering for Llms: The Art and Science of Building Large Language Model-Based Applications
Ziegler, Albert
Berryman, John
Paperback
Learning Php, MySQL & JavaScript: A Step-By-Step Guide to Creating Dynamic Websites
Nixon, Robin
Paperback
Living a Jewish Life, Revised and Updated: Jewish Traditions, Customs, and Values for Today's Families
Diamant, Anita
Cooper, Howard
Paperback
Pro C# 10 with .Net 6: Foundational Principles and Practices in Programming
Troelsen, Andrew
Japikse, Phil
Paperback
Articulating Design Decisions: Communicate with Stakeholders, Keep Your Sanity, and Deliver the Best User Experience
Greever, Tom
Paperback
Kubernetes in Action, Second Edition: Deploying and Managing Containers and Cloud-Native Applications
Luksa, Marko
Conner, Kevin
Paperback
Adobe Photoshop, 2nd Edition: A Complete Course and Compendium of Features
Laskevitch, Stephen
Paperback
Spies, Lies, and Algorithms: The History and Future of American Intelligence
Zegart, Amy B.
Paperback
Ruined by Design: How Designers Destroyed the World, and What We Can Do to Fix It
Monteiro, Mike
Paperback
Site Reliability Engineering: How Google Runs Production Systems
Murphy, Niall Richard
Jones, Chris
Beyer, Betsy
Paperback