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
- 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 Learn About SQL!
- Using SQL
- Searching for Data Using a SELECT Statement (1/2)
- Searching for Data Using a SELECT Statement (2/2)
- Using Aggregate Functions
- Joining Tables
- Creating a Table
- SQL Overview
- Searching for Data Using a SELECT Statement
- Creating Conditions
- Aggregate Functions
- Searching for Data
- Joining Tables
- Creating a Table
- Summary
- Answers
-
Chapter 5: Let's Operate a Database!
- What Is a Transaction?
- What Is a Lock? (1/2)
- What Is a Lock? (2/2)
- Database Security
- Speeding Things Up with Indexing (1/2)
- Speeding Things Up with Indexing (2/2)
- Disaster Recovery
- Properties of Transactions (1/2)
- Properties of Transactions (2/2)
- When Disaster Strikes
- Indexes
- Optimizing a Query
- Summary
- Answers
-
Chapter 6: Databases Are Everywhere!
- Databases in Use
- Databases and the Web (1/2)
- Databases and the Web (2/2)
- Distributed Databases
- Stored Procedures and Triggers (1/2)
- Stored Procedures and Triggers (2/2)
- Databases on the Web
- What Is a Distributed Database?
- Partitioning Data
- Preventing Inconsistencies with a Two-Phase Commit
- Database Replication
- Further Application of Databases
- Summary
- Answers
- Closing Remarks
- Frequently Used SQL Statements
- References
- Index (1/2)
- Index (2/2)
Product information
- Title: The Manga Guide to Databases
- Author(s):
- Release date: January 2009
- Publisher(s): No Starch Press
- ISBN: 9781593271909
You might also like
book
The Manga Guide to Physics
Megumi is an all-star athlete, but she's a failure when it comes to physics class. And …
book
The Manga Guide to Electricity
Rereko is just your average high-school girl from Electopia, the land of electricity, but she's totally …
book
The Manga Guide to Statistics
Think you can't have fun learning statistics? Think again. The Manga Guide to Statistics will teach …
book
The Manga Guide to Calculus
Noriko is just getting started as a junior reporter for the Asagake Times. She wants to …