The Manga Guide to Databases

The Manga Guide to Databases
by 
Mana Takahashi, Shoko Azuma, and Trend-Pro Co., Ltd
January 2009, 224 pp.
ISBN-13: 
978-1-59327-190-9

"Highly recommended."
Choice Magazine

"Whether you're new to the whole concept of databases, or a hard-core database geek, you need to have The Manga Guide to Databases. Really, you want this book."
Josh Berkus, PostgreSQL Core Team (Read More)

Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you.

Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod's humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many customers! It's all such a confusing mess. But a mysterious book and a helpful fairy promise to solve her organizational problems—with the practical magic of databases.

In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship model, perform basic database operations, and delve into more advanced topics. Once the Princess is familiar with transactions and basic SQL statements, she can keep her data timely and accurate for the entire kingdom. Finally, Tico explains ways to make the database more efficient and secure, and they discuss methods for concurrency and replication.

Examples and exercises (with answer keys) help you learn, and an appendix of frequently used SQL statements gives the tools you need to create and maintain full-featured databases.

(Of course, it wouldn't be a royal kingdom without some drama, so read on to find out who gets the girl—the arrogant prince or the humble servant.)

This EduManga book is a translation of a bestselling series in Japan, co-published with Ohmsha, Ltd., of Tokyo, Japan.

Author Bio 

Mana Takahashi is a graduate of the Tokyo University, Faculty of Economics. She is an active technical writer and has published a number of books on topics such as Java, C, XML, Information Engineering, and System Administration.

Table of contents 

Preface

Chapter 1: What is a Database?
Chapter 2: What is a Relational Database?
Chapter 3: Let's Design a Database
Chapter 4: Let's Use a Database - Basic Operation of SQL
Chapter 5: Let's Operate the Database
Chapter 6: Spread and Contribution of Databases

Appendix: Frequently Used SQL Statements
References
Index

View the detailed Table of Contents (PDF)

View the Index (PDF)

Reviews 

"Highly recommended."
Choice Magazine

"This is a solid book and I wish there were more like it in the IT world."
Slashdot (Read More)

"Without a doubt, The Manga Guide to Databases was the most enjoyable tech book I've ever read. . . . I loved this book and highly recommend it if you'd like a beginner's book with a fun overview of databases, served up manga-style."
Rikki Kite, Linux Pro Magazine (Read More)

"Whether you're new to the whole concept of databases, or a hard-core database geek, you need to have The Manga Guide to Databases. Really, you want this book."
Josh Berkus, PostgreSQL Core Team (Read More)

"For an American audience, this is certainly off-the-beaten-path approach to technical training. However, its ability to effectively plunge into a topic that can be a morass of arcane theory is undeniable. Over the years, we've learned to expect the unexpected from No Starch Press."
MacDirectory

"This book is by far the best book I have read on the subject. I think this book absolutely rocks and recommend it to anyone working with or just interested in databases."
Geek at Large (Read More)

"From data tables to flow charts, The Manga Guide to Databases is a valuable resource to students who wish to know more about the process of information manipulation and storage."
Eclectic Homeschool Online (Read More)

"Love, intrigue, and databases—yes!"
Adobe.shobes (Read More)

"If you're in the market to learn more about databases and you hate normal tech books this is a great pickup."
The CaffiNation Podcast (Read More)

"If you need to learn about databases and you're tired of the Databases for Dummies-type fare, pick up this guide! If you plan on running your own business and are a manga fanatic, drop everything and pick up this guide!"
Anime 3000 (Read More)

"The Manga Guide to Databases is not just a lightweight illustrated treatment of RDBMSs. I like that the book covers different data models, and includes a discussion of some relational operations. The explanations of transactions and ACID principles were very concise and clear. This book gets bonus points for having a thorough index and a 'frequently used SQL statements' cheat sheet."
Bacon and Tech (Read More)

"I tested the book on a genuine teen, my son John. . . When I quizzed him about database design, he really had picked up the essentials. He told me about one-to-one, one-to-many, and many-to-many relationships; the importance of a primary key; and using transactions to avoid corrupting the database."
AppScout (Read More)

The Manga Guide to Databases "is a light, impressively non-oppressive read, especially considering the technical nature of its subject."
Ain't It Cool News (Read More)

"A clear and solid foundation for further study."
Matthew Helmke (dot) Net (Read More)

"SQL is no longer a total mystery to me."
Carnegie Library of Pittsburgh Teen Services (Read More)

"Somehow, it all works together. There's an awful lot of information conveyed as Ruruna and Cain modernize their country."
Comics Worth Reading (Read More)

"Those who are just getting started with relational database design and data modeling will find this guide to be entertaining and extremely comprehensive."
Cloud-Based Application Platform and PaaS by LongJump (Read More)

"It’s relatively easy, completely fun, and explains a lot of how each part of a database relates to another. Besides, Tico the fairy is cute, too!"
Sequential Tart (Read More)

Extra Stuff 

Sample pages from The Manga Guide to Databases:

book spread

Updates 

Errata for the Second Printing:

Page 112:
Question Q13 should read, "What is the largest population of a country in the North Sea District?"

Page 120/123:
The from statement in the answer to Q20 should read: FROM export_destination


Errata for the First Printing:

Page 98:
In the first panel, the statement should read:
SELECT *
FROM product
WHERE unit_price ORDER BY unit_price;

Page 98:
In the 5th and last panel, the average unit price should be 317.5

Page 101:
In the third panel, the last item in the SELECT phrase should be "quantity" instead of "export_destination."

Page 112:
Question Q13 should read, "What is the largest population of a country in the North Sea District?"

Page 119:
The result of the query in Q4 should be the empty set.

Page 120:
The results of the query in Q6 should include "The Kingdom of Minanmi," "The Kingdom of Ritol," and "The Kingdom of Sazanna."

Page 120/123:
The from statement in the answer to Q20 should read: FROM export_destination

Page 156:
The second sentence of the first paragraph should read "When an
exclusive lock is applied, another user can not apply a shared lock
or an exclusive lock to other transactions."

Page 160:
Q10 should read "Create an SQL statement to revoke the Overseas Business Department's privilege to delete data from the Product Table."