Book
SQL, 2nd Edition
Working with Databases, Starting from Zero
Mick
Summary
A Japanese-language, from-scratch introduction to SQL and relational databases by Mick; this entry covers the second edition. Ten chapters start with setting up a practice database and writing basic SELECT statements, then move through aggregation and sorting, updating data, more complex queries, and functions, predicates, and CASE expressions. Later chapters cover set operations, an introduction to window functions, and how an application connects to the database it queries; joins are covered as well. The book uses PostgreSQL throughout and treats SQL as a declarative, set-based language, aiming to move readers used to procedural code toward thinking in sets rather than step-by-step instructions.
Target Readers
- Engineers who are new to SQL and want a structured path from environment setup through basic queries
- Developers who have only queried a database through an ORM and want to read and write raw SQL directly
- Programmers used to procedural code who need to make the shift to SQL's declarative, set-based way of thinking
Tags
Colophon
- Publisher
- Shoeisha
- ISBN
- 978-4798144450
- Published
- Jun 2016
- List price
- ¥2,068incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Next Books
- Recommended
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
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
SQL Jissen Nyumon (A Practical Introduction to SQL)
Writing Fast, Easy-to-Understand Queries
Mick
Reason: After you can write correct SQL, the next lens is reading the execution plan (EXPLAIN) to understand why a query is slow. This book starts tuning from the execution plan, so reading it right after the basics grows you from 'can write SQL' to 'can write fast SQL'.
- Recommended
Riron kara Manabu Database Jissen Nyumon (Learning Databases from Theory)
Efficient SQL through the Relational Model
Mikiya Okuno
Reason: After you can make SQL 'run', the next goal is to internalize why tables are split this way and why we normalize—grounded in relational theory. Okuno's book reconstructs Codd's relational model in practitioner's terms, giving your syntax knowledge a theoretical backbone.
- Recommended
Yasashii Database Sekkei (A Gentle Guide to Database Design)
Key Points from Requirements Definition through Operations
Yutaka Eto
Reason: After learning basic SQL operations such as SELECT and JOIN, the natural next step is the upstream question of how to design the tables themselves. This book walks through requirements definition, logical design, physical design, and operations in one pass, giving concrete guidance at each stage where a reader new to DB design tends to stumble.
- Related
Relational Database Nyumon, 3rd Edition (An Introduction to Relational Databases)
Data Models, SQL, Management Systems, and NoSQL
Yoshifumi Masunaga
Reason: A branch for those who want the relational model systematically and academically. Masunaga's textbook covers relational algebra, normal forms, and concurrency control in textbook fashion, tracing the academic lineage descending from Codd's original paper—complementing the more practice-oriented Okuno book.