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...
Autor principal: | |
---|---|
Autor Corporativo: | |
Otros Autores: | |
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