
The Manga Guide to Databases
No Starch Press
Published on 15. January 2009
224 pages
978-1-59327-297-5 (ISBN)
System requirements
for ePUB without DRM
E-Book Single Licence
You are acquiring a single user licence for this eBook, which you might not transfer. [L]
Available for download
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
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.
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.
More details
Series
Language
English
Place of publication
San Francisco
United States
Product notice
Fixed format
File size
32,32 MB
ISBN-13
978-1-59327-297-5 (9781593272975)
Schweitzer Classification
Other editions
Additional editions

Mana Takahashi | Shoko Azuma | Trend-pro Co., Ltd.
The Manga Guide to Databases
Book
01/2009
1st Edition
No Starch Press
€24.00
Available immediately
Persons
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.
Content
- Intro
- Contents
- Preface
- Chapter 1: What Is a Database?
- Why Do We Need Databases?
- What's Up in the Kingdom?
- A Database-That's Our Solution!
- Summary
- Chapter 2: What Is a Relational Database?
- Database Terms
- Relational Databases
- Types of Data Models
- Data Extraction Operations
- Questions
- The Relational Database Prevails!
- Summary
- Answers
- Chapter 3: Let's Design a Database!
- The E-R Model
- Normalizing a Table
- What Is the E-R Model?
- How to Analyze the E-R Model
- Normalizing a Table
- Steps for Designing a Database
- Answers
- Chapter 4: Let's Learn About SQL!
- Using SQL
- Searching for Data Using a SELECT Statement
- 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?
- Database Security
- Speeding Things Up with Indexing
- Disaster Recovery
- Properties of Transactions
- When Disaster Strikes
- Indexes
- Optimizing a Query
- Summary
- Answers
- Chapter 6: Databases Are Everywhere!
- Databases in Use
- Databases and the Web
- Distributed Databases
- Stored Procedures and Triggers
- 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 SQLStatements
- References
- Index
- About the Author
- Updates
- More Manga Guides
System requirements
File format: ePUB
Copy protection: without DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Use a reader that can handle the file format ePUB, such as Adobe Digital Editions or FBReader – both free (see eBook Help).
- Tablet/Smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePUB works well for novels and non-fiction books – i.e., 'flowing' text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook does not use copy protection or Digital Rights Management
For more information, see our eBook Help page.