Download The Manga guide to databases PDF

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