The Manga Guide to Databases

The Manga Guide to Databases

by Mana Takahashi, Shoko Azuma, Ltd. Trend-Pro Co.
Released January 2009
Publisher(s): No Starch Press
ISBN: 9781593271909

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Buy on ebooks.com
Start your free trial

Book 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.

Table of contents

  1. Contents
  2. Preface
  3. Chapter 1: What Is a Database?
    1. Why Do We Need Databases? (1/3)
    2. Why Do We Need Databases? (2/3)
    3. Why Do We Need Databases? (3/3)
    4. What’s Up in the Kingdom?
    5. A Database—That’s Our Solution!
    6. Summary
  4. Chapter 2: What Is a Relational Database?
    1. Database Terms (1/2)
    2. Database Terms (2/2)
    3. Relational Databases
    4. Types of Data Models
    5. Data Extraction Operations
    6. Questions
    7. The Relational Database Prevails!
    8. Summary
    9. Answers
  5. Chapter 3: Let’s Design a Database!
    1. The E-R Model
    2. Normalizing a Table (1/4)
    3. Normalizing a Table (2/4)
    4. Normalizing a Table (3/4)
    5. Normalizing a Table (4/4)
    6. What Is the E-R Model?
    7. How to Analyze the E-R Model
    8. Normalizing a Table
    9. Steps for Designing a Database
    10. Answers
  6. Chapter 4: Let's Learn About SQL!
    1. Using SQL
    2. Searching for Data Using a SELECT Statement (1/2)
    3. Searching for Data Using a SELECT Statement (2/2)
    4. Using Aggregate Functions
    5. Joining Tables
    6. Creating a Table
    7. SQL Overview
    8. Searching for Data Using a SELECT Statement
    9. Creating Conditions
    10. Aggregate Functions
    11. Searching for Data
    12. Joining Tables
    13. Creating a Table
    14. Summary
    15. Answers
  7. Chapter 5: Let's Operate a Database!
    1. What Is a Transaction?
    2. What Is a Lock? (1/2)
    3. What Is a Lock? (2/2)
    4. Database Security
    5. Speeding Things Up with Indexing (1/2)
    6. Speeding Things Up with Indexing (2/2)
    7. Disaster Recovery
    8. Properties of Transactions (1/2)
    9. Properties of Transactions (2/2)
    10. When Disaster Strikes
    11. Indexes
    12. Optimizing a Query
    13. Summary
    14. Answers
  8. Chapter 6: Databases Are Everywhere!
    1. Databases in Use
    2. Databases and the Web (1/2)
    3. Databases and the Web (2/2)
    4. Distributed Databases
    5. Stored Procedures and Triggers (1/2)
    6. Stored Procedures and Triggers (2/2)
    7. Databases on the Web
    8. What Is a Distributed Database?
    9. Partitioning Data
    10. Preventing Inconsistencies with a Two-Phase Commit
    11. Database Replication
    12. Further Application of Databases
    13. Summary
    14. Answers
    15. Closing Remarks
  9. Frequently Used SQL Statements
  10. References
  11. Index (1/2)
  12. Index (2/2)

Product information

  • Title: The Manga Guide to Databases
  • Author(s): Mana Takahashi, Shoko Azuma, Ltd. Trend-Pro Co.
  • Release date: January 2009
  • Publisher(s): No Starch Press
  • ISBN: 9781593271909