The Manga Guide to Databases (Paperback)

~ (Author), Shoko Azuma (Author), Trend-pro Ltd. (Author)
Key Phrases: export department, export destination name, network data model, The Kingdom of Minanmi, Alpha Empire, North Sea (more...)

Editorial Reviews

Product Description

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.

About the Author

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.

Product Details

• Paperback: 224 pages
• Publisher: No Starch Press; Ill edition (January 28, 2009)
• Language: English
• ISBN-10: 1593271905
• ISBN-13: 978-1593271909
• Product Dimensions: 9.2 x 7 x 0.7 inches
• Shipping Weight: 13.6 ounces (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (15 customer reviews)
• Amazon.com Sales Rank: #82,350 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #83 in

  Books > Computers & Internet > Software > Databases

Customer Reviews

Most Helpful Customer Reviews

20 of 20 people found the following review helpful:

5.0 out of 5 stars My 9 Year Old Daughter Now Understands Database Concepts, April 16, 2009

By	Glenn Auerbach (Ann Arbor, MI, USA) - See all my reviews (REAL NAME)

BACKGROUND: I spend a large part of my working day in a SQL Server database, so I have very strong database knowledge. My daughter is 9 years old and is a very strong reader, but could care less about how a computer actually works... as long as she can get to ClubPenguin.com or the other websites she likes to visit for fun.

STORY: A friend loaned me this book to show her, so I gave it to her and asked her to try it. If she read the first 10 pages and it was boring, she should stop. If she liked it, she could keep it until she was done. She opened it on the spot and was 20 pages in before she realized she still was standing in the middle of our kitchen. One day later, she was finished and said it was "cool" and that she liked it.

I asked her if she learned anything or if it was just a story and she started talking. She said a little bit and talked about tables and how information is stored in columns and rows. She talked in a 9 year old's language and vocabulary, but basically explained to me the concept and benefits of centralized data stored in a single database. She made a couple other comments whose specifics I can't remember, but clearly articulated database ideas. It was somewhat surreal hearing these things come from a 3rd grader's mouth. She didn't feel like she had learned very much. I told her I probably could count on my fingers how many people at my work (300 people total - manufacturing industry, not IT) knew more about databases than she did, based on what she had finished telling me.

SUMMARY: She felt like she read a fun Manga-style story. In reality, she did that but also learned and retained ideas that normally would be taught to much older people. This book took what could be a dry learning experience and changed it into a fun activity no different than if she was reading her Nancy Drew books or her Lego magazines. I see that there are other topics (statistics, physics, etc.) and I'll ask her if she's interested in seeing any of the other books. If she wants to, I absolutely would buy them.

And obviously, if you're read this far, I completely would recommend this book to anyone interested in learning about databases on an introductory level.

5 of 5 people found the following review helpful:

5.0 out of 5 stars A suprisingly superb database book, June 10, 2009

By	waveninja "http://geekatlarge.blogspot.com" (The Hague, The Netherlands) - See all my reviews

Most of my friends and colleagues had to laugh when I told about or showed them this manga guide. Though this book is really fun to read and contains many subtle jokes, it's not something to dismiss as some crazy comic book.

Don't fool yourself, under the happy Manga lies a superb learning book on databases. The book deals with the fundamentals in a clear, quick and fun way. It's quite amazing how some conceptually difficult topics are explained in such a short book. The book brought a clear understanding of some things a 4-year bachelor's study on the subject failed to clearly explain. I hated everything Database before I read this book. Mostly because I felt it was a dry and boring subject and this idea was supported by terribly boring, big fat books with a lot of difficult language.

The book tackles all you need to know to be able to design, use and maintain a database. Subjects such as Database normalization, Database design, ERD models, SQL, ACID, locking mechanisms, query and database optimization, security, architecture, stored procedures and database replication are all explained wonderfully. There are exercises on each topic, and answers are provided a few pages further.

One of the strong points of the book is that it succeeds in explaining some very practical things without being implementation dependent. All the knowledge you gain from this book will be applicable to any database system.

The author is a sheer didactic genius! Repetition is cleverly hidden in comics, written out paragraphs, drawings and exercises. You hardly notice you are actually learning Your thought process is guided by the main characters in the book and a few hours later you know all the Database fundamentals.

People who care about the environment can also enjoy this book since it's been printed on some nice quality Sustainable Forestry Initiative paper.

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.

Everything should have it's own Manga Guide!

[...]

5 of 5 people found the following review helpful:

5.0 out of 5 stars Great intro to databases and SQL, May 4, 2009

By	M. Helmke - See all my reviews (REAL NAME)

I have used relational databases for years. I've used them to store mailing lists, email account data for postfix, blog and forum data, and more. They are convenient and powerful time savers. Most of what I have learned has been indirectly learned while studying something else; documentation for a computer programming language like PHP or Python, a book on website design for commerce, or documentation and code for an open source project like Wordpress or Drupal. As a result, my knowledge is adequate for simple tasks and queries, but I'm nowhere near ready to be a database admin. What I know is incomplete, adequate for my actual needs, but with gaping holes in my knowledge.

Until this week, I was comfortable with this fact.

I found this systematic and foundational introduction to database design clear, interesting, and enjoyable--so much so that I have ordered a few more books on database theory and design and SQL for further study. Contrast that with the indirect introductions I have previously encountered that made me want to ignore the topic, except for the aspects vital to my task(s) at hand.

The Manga Guide to Databases uses a somewhat silly, but pleasant story with well drawn artwork to ease the reader into a complicated subject that requires paying a bit of attention to for comprehension. It begins with the assumption that the reader knows nothing about the topic, so it would be perfect as a base level introductory text, especially for high school aged readers (or those of us who are a bit older, but who still enjoy a bit of whimsy).

We start with the question "What is a database?" and a great description of how and why they are useful. We move into a basic definition of relational databases with a very brief mention of other types of databases that exist. The fun continues with a chance to design a database around the model of entities and relationships.

Once the foundation is laid with a conceptual understanding of databases and their design, structured query language (SQL) is introduced. I was thrilled to discover this wasn't product specific language, but rather standard ANSI, at least as far as I can tell (okay, I know a little more than I let on earlier, but I still consider myself a database/SQL novice). That is great, because it means that whatever is learned here should apply anywhere, whether using MySQL, PostgreSQL, Oracle, Access, Microsoft SQL Server, or whatever, so long as the product conforms to the standard. This certainly isn't a complete SQL introductory text, but it is enough to get a person started understanding the basic concepts and how to operate a database.

Ultimately, the book was a success. I wouldn't kid anyone into thinking that reading and understanding this book would make a person capable of real database administration, but it does give a clear and solid foundation for further study, and in my case has whet my appetite for going back to fill in some personal knowledge gaps that I have been content to let exist for a very long time.