SQL Cookbook Query Solutions and Techniques for All SQL Users (Anthony Molinaro, Robert de Graaf)（Z-Library）

【One-Line Pitch】 A problem-first SQL reference that turns "I know the syntax but not the solution" into working, cross-platform queries. Best for analysts, data scientists, DBAs, and developers who already know basic SQL and want to solve real data problems faster. 【Book Arc】 - **Opening (~0%–10%)**: Frames the cookbook approach and the multi-vendor problem—every recipe must work across Oracle, DB2, SQL Server, MySQL, and PostgreSQL, so you learn to think in portable SQL rather than one dialect. - **Early (~10%–30%)**: Covers retrieval fundamentals: sorting results (including sorting by substrings and controlling NULL placement), working with multiple tables via joins and set operations, and the NULL pitfalls of NOT IN versus EXCEPT/MINUS. - **Early–Middle (~30%–45%)**: Moves into metadata queries, inserting/updating/deleting through views, and heavy string manipulation—concatenation, separating numeric from character data, extracting initials, alphabetizing strings, and parsing values like IP addresses. - **Middle (~45%–60%)**: Expands into numeric and date work: date arithmetic, business-day calculations, generating and filling date ranges, and identifying overlapping ranges. - **Late (~60%–85%)**: Advances to range handling and advanced searching—locating consecutive values, finding differences between rows in a partition, filling missing values, generating sequences, and paginating result sets. - **Ending (~85%–100%)**: Consolidates with window functions and CTEs as the modern backbone of readable solutions, plus expanded recipes aimed at non-DBAs such as data scientists. 【Key Takeaways】 - **Portability is the organizing principle** (Opening): each recipe shows vendor-specific variants side by side, so you learn both the general technique and the dialect quirks that break it. - **NULL handling is a recurring trap** (Early): NOT IN silently returns no rows when the subquery contains NULL, while EXCEPT/MINUS avoids the problem—an early lesson that shapes how you write later queries. - **String manipulation is where SQL gets surprisingly powerful** (Middle): TRANSLATE, REPLACE, SUBSTR, and recursive CTEs let you split, reorder, and parse text that many users assume requires application code. - **Dates and ranges need explicit scaffolding** (Middle–Late): business-day counts, missing-date filling, and consecutive-value detection require generating rows or auxiliary columns rather than relying on built-in functions alone. - **Window functions are now the default tool** (Late): the second edition revises recipes around their wider adoption, replacing older self-join and subquery patterns with cleaner OVER-based solutions. - **CTEs make complex queries readable** (Late): common table expressions are treated as a first-class technique for structuring multi-step logic instead of nesting subqueries. - **Advanced searching is about controlling result sets** (Late): pagination, skipping rows, and row-difference comparisons are framed as practical reporting needs, not academic exercises. - **The book is a reference, not a tutorial** (Throughout): recipes are indexed by problem, so the intended use is lookup-and-adapt rather than linear reading. 【Reading Tips】 - **Skim the vendor comparison blocks on first pass**: read the problem statement and the primary solution, then return to dialect-specific variants only when you hit a compatibility issue. - **Deep-read the NULL and set-operation discussions early**: these concepts recur throughout the book and misunderstanding them causes silent wrong answers. - **Treat string and date chapters as technique libraries**: the specific recipes matter less than the patterns—TRANSLATE/REPLACE tricks and row-generation scaffolding transfer to many problems. - **Use the window function and CTE recipes as your modernization checklist**: if your existing queries use older self-join patterns, these sections show the cleaner rewrite. - **Keep your own DBMS documentation open**: the book explicitly warns that view insertion and similar features have vendor rules too complex to fully cover. 【Coverage Limits】 The excerpts cover the table of contents, preface, and selected recipes through string, date, range, and advanced-searching chapters; later chapters on window functions and CTEs are referenced but their detailed recipes are not shown, so this guide describes their role rather than their specific content.