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

Descripción completa

Detalles Bibliográficos
Autor principal: Takahashi, Mana (-)
Autor Corporativo: Trend-pro Co Content Provider (content provider)
Otros Autores: Azuma, Shoko
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Francisco : No Starch Press 2009.
Edición:1st ed
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009644315806719
Tabla de Contenidos:
  • 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