SQL cookbook [query solutions and techniques for database developers covers SQL server, PostgreSQL, Oracle, MySQL, and DB2] (Anthony Molinaro) (Z-Library)

【One-Line Pitch】 A practical, recipe-driven reference for SQL developers who need ready-to-use solutions for common and complex query tasks across SQL Server, PostgreSQL, Oracle, MySQL, and DB2 — ideal for anyone who wants to move beyond basic SELECT statements and master real-world data manipulation. 【Book Arc】 - **Opening (~0%–20%)**: The book opens with the foundational skill of retrieving records — covering how to pull all or subsets of rows and columns, apply conditions, use aliases, handle NULLs, and search patterns. This section establishes the core SELECT mechanics that every later recipe builds upon. - **Early (~20%–40%)**: Moves into sorting and multi-table operations. Readers learn to order results by substrings, mixed alphanumeric data, and data-dependent keys, then tackle joins — stacking rowsets, finding common or missing rows, avoiding Cartesian products, and handling aggregates with joins. - **Middle (~40%–60%)**: Covers data modification (insert, update, delete, merge) and metadata queries. Recipes show how to copy rows, block inserts, update from other tables, delete duplicates, and query the data dictionary to list tables, columns, indexes, and constraints — including using SQL to generate SQL. - **Middle (~60%–80%)**: Dives into string and number manipulation. String recipes cover walking strings, counting characters, parsing delimited data, extracting initials, and alphabetizing; number recipes cover averages, running totals/products, mode, median, and percentage-of-total calculations. - **Late (~80%–100%)**: Focuses on date arithmetic and manipulation, then ranges and advanced searching. Readers learn to add/subtract time units, count business days, build calendars, fill missing dates, locate consecutive ranges, paginate result sets, rank results, and investigate future rows. 【Key Takeaways】 - **Retrieval fundamentals are the gateway to everything else** (Opening): mastering row/column subsets, aliases, NULL handling, and pattern searches makes all later recipes easier to follow and adapt. - **Sorting is more than ORDER BY** (Early): recipes for sorting by substrings, mixed alphanumeric data, and data-dependent keys solve problems that naive sorting cannot handle. - **Joins require deliberate strategy** (Early): knowing when to use outer joins, how to avoid Cartesian products, and how to combine aggregates with joins prevents both performance disasters and incorrect results. - **Data modification is a minefield of edge cases** (Middle): inserting defaults, overriding with NULL, merging records, and deleting duplicates all have vendor-specific traps that the recipes explicitly address. - **Metadata queries turn the database into a self-documenting system** (Middle): listing tables, columns, indexes, and constraints — and generating SQL from SQL — empowers developers to automate schema analysis. - **String manipulation is the most versatile skill set** (Middle): walking strings, parsing delimited data, and extracting substrings solve data-cleaning problems that appear in nearly every real-world project. - **Date arithmetic is deceptively complex** (Late): business-day counts, leap-year detection, calendar generation, and filling missing dates require careful logic that varies significantly across database platforms. - **Advanced searching unlocks analytical power** (Late): pagination, ranking, top-n selection, and investigating future rows are the building blocks of modern reporting and analytics queries. 【Reading Tips】 - **Skim the Opening and Early sections if you're comfortable with basic SELECTs** — but do revisit the sorting and join recipes, as they contain non-obvious techniques like data-dependent keys and aggregate-safe joins. - **Deep-read the string and date chapters** — these are the densest and most transferable; the patterns here (parsing, walking, calendar generation) reappear across countless business problems. - **Treat each recipe as a template, not a script** — the book provides solutions for multiple databases, so compare the vendor-specific versions to understand which parts are portable and which are dialect-dependent. - **Use the table of contents as your index** — the recipe titles are descriptive enough that you can jump straight to a problem without reading linearly. - **Watch for the "how it works" explanations** — these are where the real learning happens; don't just copy the code, understand why the solution is structured that way. 【Coverage Limits】 This guide is based on the table of contents and early front matter; the excerpts do not include actual recipe code or explanations, so specific syntax details and vendor differences are not covered here.