SQL Crash Course (Thomas Liddle)（Z-Library）

# SQL Crash Course — Reading Guide ## 【One-Line Pitch】 A practical, project-driven introduction to SQL that takes you from your first SELECT statement through database security, performance tuning, and multi-database deployment — ideal for beginners and career-switchers who want hands-on database skills without academic fluff. --- ## 【Book Arc】 - **Opening (~0%–8%)**: Front matter, author background, and a chapter-by-chapter roadmap. Establishes the book's progressive structure: fundamentals → advanced queries → database objects → optimization → security → real-world projects. - **Early (~8%–23%)**: Core SQL foundations — database structure (tables, rows, columns, constraints, normalization), basic queries (WHERE, ORDER BY, GROUP BY, HAVING, LIMIT), joins (INNER, LEFT, RIGHT, FULL, CROSS), string manipulation, advanced retrieval with subqueries and aggregation, and data modification (INSERT, UPDATE, DELETE, NULL handling). - **Early–Middle (~23%–38%)**: Intermediate topics — SET operators (UNION, INTERSECT, EXCEPT), managing database objects (tables, indexes, views, stored procedures, triggers, cursors), performance optimization with indexing and execution plans, and data generation/conversion across string, numeric, and temporal types. - **Middle (~38%–50%)**: Transaction management and concurrency control, followed by a survey of major SQL database systems (MySQL, PostgreSQL, SQL Server, SQLite, Oracle) — including how to choose the right database for a project and connection best practices. - **Middle–Late (~50%–65%)**: Security considerations — access control, authentication, authorization, least privilege, data encryption, SQL injection prevention, auditing, monitoring, backup/recovery strategies, and compliance requirements. - **Late (~65%–73%)**: Hands-on projects using SQLite and the Sakila sample database — building customer rating systems, generating rental reports, and analyzing revenue trends — followed by best practices for writing clean, efficient, and maintainable SQL code. --- ## 【Key Takeaways】 - **SQL is built on set theory and relational algebra** (Late): This mathematical foundation is why SQL can handle complex multi-table queries efficiently — understanding this helps you reason about why queries behave the way they do. - **The SELECT statement is the gateway to everything** (Early): Mastery of clauses (WHERE, ORDER BY, GROUP BY, HAVING, LIMIT) and their combination order is the single most important skill for querying — the book drills this systematically before moving to advanced topics. - **Joins are how relational databases earn their name** (Early): Understanding INNER, LEFT, RIGHT, FULL, and CROSS joins — and when each is appropriate — unlocks the power of working with multiple related tables. - **NULL handling requires deliberate discipline** (Early): Inserting, updating, and deleting records with NULL values demands explicit strategies — the book treats NULL management as a best practice rather than an afterthought. - **Indexes are the primary lever for query performance** (Middle): Knowing when to create indexes, what types exist, and how they affect execution plans is essential for moving from "working" queries to "fast" queries. - **Database choice is a project decision, not a religion** (Middle): MySQL prioritizes speed and simplicity, PostgreSQL emphasizes standards compliance, SQLite is lightweight and self-contained, while SQL Server and Oracle target enterprise integration — the book provides a framework for matching databases to requirements. - **Security is a layered responsibility** (Middle): Access control, encryption, SQL injection prevention, auditing, and backup/recovery form complementary defenses — no single measure is sufficient, and compliance requirements shape the overall approach. - **Practice projects cement learning** (Late): Working through real scenarios with the Sakila database — building rating systems and generating business reports — transforms abstract syntax into applied skill. --- ## 【Reading Tips】 1. **Skim the chapter openers and "Structure" sections** — each chapter lists its objectives and sections upfront, letting you decide where to focus or skip based on your current level. 2. **Deep-read Chapters 3–5 (Basic Queries, Strings, Advanced Retrieval)** — these are the conceptual core. Work through every example; query syntax only sticks with repetition. 3. **Treat Chapter 12 (Different SQL Databases) as a reference, not a cover-to-cover read** — skim the comparison sections and return when you actually need to choose or connect to a specific database. 4. **Don't skip the exercises at each chapter's end** — they're designed to reinforce exactly what the chapter taught, and the later projects assume you've done them. 5. **If you're a complete beginner, start with Chapter 1's environment setup before anything else** — the book assumes you'll follow along with a working SQL installation. --- ## 【Coverage Limits】 This guide is based on sampled excerpts that thoroughly cover the table of contents, chapter objectives, and key conceptual passages, but detailed code examples and exercise solutions from the body of each chapter were not fully available in the source material. --- ##