Book
Tatsujin ni Manabu SQL Tettei Shinansho, 2nd Edition (A Thorough Guide to SQL, Learned from an Expert)
For Those Who Do Not Want to Remain Beginners
Mick
Summary
A Japanese-language book on SQL by Mick, in its 2nd edition. It is a revision of a book of the same title that was expanded from a serial on CodeZine, a web magazine for developers, and published in 2008. The 2nd edition keeps the structure of the first while adopting window functions throughout and revising much of the code. It treats SQL as a set-oriented language and explains the correct ways of writing and thinking about it, covering CASE expressions, window functions, outer joins, the HAVING clause, and the EXISTS predicate, along with modern SQL features. Because it follows standard SQL, it applies to databases such as Oracle, SQL Server, DB2, PostgreSQL, and MySQL, and it includes practical coding examples, tuning techniques, and the history of relational databases. It also conveys the background of how SQL works and what its creators had in mind.
Target Readers
- DB engineers and programmers who want to move beyond the beginner level and aim higher
- People who want to know what SQL is
- Intermediate engineers who understand the basics of SQL but have not moved on to applications, and developers who design complex aggregation and analysis queries
Tags
Colophon
- Publisher
- Shoeisha
- ISBN
- 978-4798157825
- Published
- Oct 2018
- List price
- ¥2,750incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Recommended
SQL, 2nd Edition
Working with Databases, Starting from Zero
Mick
Reason: Once you have the basics of SELECT, the natural next step is set-oriented techniques—CASE expressions, window functions, set operations—that teach you to think in sets rather than procedurally. Both are Japanese SQL books by the same author (Mick), so the vocabulary carries over smoothly from introduction to application.
- Recommended
Riron kara Manabu Database Jissen Nyumon (Learning Databases from Theory)
Efficient SQL through the Relational Model
Mikiya Okuno
Reason: Grasping relational theory first makes the set operations and window functions in this advanced SQL guide land as the logical necessity of 'why think in sets'. Reading theory → implementation lets you derive each advanced SQL technique from first principles rather than memorizing it ad hoc.
- Related
Relational Database Nyumon, 3rd Edition (An Introduction to Relational Databases)
Data Models, SQL, Management Systems, and NoSQL
Yoshifumi Masunaga
Reason: After learning academic relational algebra and normalization theory, this path lets you verify how it is expressed in actual SQL via this advanced SQL guide. It grounds the abstractions you gained in theory into concrete query forms, converting knowledge into something usable in practice.
Next Books
- Recommended
Joe Celko's SQL for Smarties, 4th Edition
Advanced SQL Programming
Joe Celko
Reason: After the applied set operations, advance to Joe Celko's set-theory-based advanced idioms and the nested-set model for hierarchical data. Including declarative hierarchical queries such as recursive CTEs, it is the capstone of the set-theoretic mindset—shedding procedural thinking entirely.
- Recommended
SQL Performance Explained
Everything Developers Need to Know about SQL Performance
Markus Winand
Reason: Once you can write applied SQL, you want to understand why a query is fast or slow from the internal structure of indexes. Markus Winand's 'SQL Performance Explained' builds index design up from how B-Trees work, connecting the way you write SQL with how fast it runs.
- Recommended
Jissen dbt Nyumon (A Practical Introduction to dbt)
Noritaka Sekiyama, Michiaki Nakaya, Tokimasa Toyohara, Jun Ohashi, Sotaro Hikita
Reason: Once you can wield SQL as a set-oriented language—CASE expressions, window functions, self-joins—the next step is learning how to assemble that SQL into a production data-transformation pipeline. This book covers running models in dbt, structuring a project, and generating tests and documentation, connecting applied SQL knowledge to the practical operation of an analytics platform.
- Related
Shippai kara Manabu RDB no Tadashii Arukikata (The Right Way to Work with RDBs, Learned from Failure)
Taketomo Sone
Reason: Even when you can write applied SQL fluently, the RDB-specific pitfalls you meet in production are a separate body of knowledge. Adding the operational perspective from this Japanese book on RDB pitfalls balances the ability to write SQL with the ability to operate the database.