The Manga Guide to Databases

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

Full description

Bibliographic Details
Main Author: Takahashi, Mana (-)
Corporate Author: Trend-pro Co Content Provider (content provider)
Other Authors: Azuma, Shoko
Format: eBook
Language:Inglés
Published: San Francisco : No Starch Press 2009.
Edition:1st ed
Subjects:
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009644315806719
Table of Contents:
  • 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 StatementUsing 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 WebDistributed 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