Book
SQL 第2版
ミック
Summary
RDBMS の基本操作と SQL の宣言的・集合指向の性質を体系的に学ぶ入門書。 PostgreSQL を例に SELECT/JOIN/集合演算/ウィンドウ関数の基礎までを順序立ててカバーし、 手続き型言語に慣れた開発者が「集合で考える」SQL 思考へ切り替える最初の足場を提供する。
Target Readers
- SQL を初めて学ぶエンジニア
- ORM 経由ではなく素の SQL を書けるようになりたい開発者
Tags
Colophon
- Publisher
- 翔泳社
- 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
達人に学ぶSQL徹底指南書 第2版
ミック
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実践入門
ミック
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
理論から学ぶデータベース実践入門
奥野幹也
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. This Japanese book (理論から学ぶデータベース実践入門) reconstructs Codd's relational model in practitioner's terms, giving your syntax knowledge a theoretical backbone.
- Recommended
やさしいデータベース設計
衛藤豊
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.
Sources
- Related
リレーショナルデータベース入門 第3版
増永良文
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.