DATABASE SYSTEMS IN PRACTICE: Understanding Data Storage, SQL, Database Design, Administration, Security, and Everyday Operations
Haagenrud, Thom
Synopsis "DATABASE SYSTEMS IN PRACTICE: Understanding Data Storage, SQL, Database Design, Administration, Security, and Everyday Operations"
Knowing how to write a query is only the beginning. Knowing how a reliable database actually works is what turns knowledge into a practical skill. Database Systems in Practice takes you beyond isolated commands and introduces the complete world behind modern relational databases—from organizing information and creating reliable schemas to writing queries, managing transactions, improving performance, protecting access, recovering from failure, and keeping a database environment healthy. Written with beginners and developing professionals in mind, this practical guide breaks complex concepts into clear explanations, realistic examples, structured exercises, and repeatable workflows. Inside, you’ll learn how to: • Understand how a DBMS works beyond tables and queries • Build relational structures using keys, relationships, constraints, and normalization • Write accurate queries using joins, aggregation, subqueries, CTEs, and other essential techniques • Work safely with INSERT, UPDATE, DELETE, transactions, and NULL values • Understand ACID principles, locking, blocking, isolation levels, and concurrency • Read execution plans and make evidence-based indexing and optimization decisions • Apply authentication, authorization, least privilege, encryption, auditing, and injection defenses • Plan and test backups, restores, replication, point-in-time recovery, and high availability • Monitor logs, alerts, capacity, failed jobs, and common operational problems • Troubleshoot systematically instead of changing configurations by guesswork Rather than teaching each topic in isolation, the book follows Northstar Outfitters, a fictional business whose evolving environment lets you see how requirements connect to schemas, queries, permissions, indexing, recovery, and day-to-day management. Examples primarily use PostgreSQL-compatible syntax while explaining important differences found in MySQL, Microsoft SQL Server, Oracle Database, and SQLite. Whether you're opening a database console for the first time, moving from software development into a data-focused role, preparing for DBA responsibilities, or strengthening your technical foundation, this book gives you a practical framework you can continue using long after the final chapter. Stop memorizing disconnected commands. Start understanding how databases work as complete, living environments. The promises in that description closely match the manuscript's stated learning objectives, including relational modeling, multi-table querying, transactions, execution-plan interpretation, least-privilege access, recovery techniques, and health reviews.
