A guide to SQL

A Guide to SQL
Table of Contents
Preface
About the Authors
Module 1: Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases
	Introduction
	What Is a Database?
	The KimTay Pet Supplies Database
	StayWell Student Accommodation Database
	Module Summary
	Key Term
	Case Exercises
Module 2: Database Design Fundamentals
	Introduction
	Database Concepts
	Functional Dependence
	Primary Keys
	Database Design
	Normalization
	Diagrams for Database Design
	Module Summary
	Key Terms
	Review Questions
	Case Exercises
Module 3: Creating Tables
	Introduction
	Creating and Running SQL Commands
	Creating a Database
	Creating a Table
	Using Data Types
	Using Nulls
	Adding Rows to a Table
	Viewing Table Data
	Correcting Errors in a Table
	Saving SQL Commands
	Creating the Remaining Database Tables
	Describing a Table
	Module Summary
	Key Terms
	Review Questions
	Case Exercises
Module 4; Single-Table Queries
	Introduction
	Constructing Simple Queries
	Sorting
	Using Functions
	Nesting Queries
	Grouping
	Nulls
	Summary of SQL Clauses, Functions, and Operators
	Module Summary
	Key Terms
	Review Questions
	Case Exercises
		KimTay Pet Supplies
		StayWell Student Accommodation
Module 5: Multiple-Table Queries
	Introduction
	Querying Multiple Tables
	Comparing Joins, IN, and EXISTS
	Set Operations
	ALL and ANY
	Special Operations
	Module Summary
	Key Terms
	Review Questions
	Case Exercises
		KimTay Pet Supplies
		StayWell Student Accommodation
Module 6: Updating Data
	Introduction
	Creating a New Table from an Existing Table
	Changing Existing Data in a Table
	Adding New Rows to an Existing Table
	Autocommit, Commit, and Rollback
	Transactions
	Changing and Deleting Existing Rows
	Changing a Value in a Column to Null
	Changing a Table’s Structure
	Dropping a Table
	Module Summary
	Key Terms
	Review Questions
	Case Exercises
		KimTay Pet Supplies
		StayWell Student Accommodation
Module 7: Database Administration
	Introduction
	Creating and using Views
	Using a View to Update Data
	Dropping a View
	Security
	Indexes
	System Catalog
	Integrity Constraints in SQL
	Module Summary
	Key Terms
	Review Questions
	Case Exercises
Module 8: Functions, Procedures, and Triggers
	Introduction
	Using SQL in a Programming Environment
	Using Functions
	Concatenating Columns
	Stored Procedures Using MySQL
	Error Handling
	Using Update Procedures
	Selecting Multiple Rows with a Procedure
	Using PL/SQL in Oracle
	Using T-SQL in SQL Server
	Using a Trigger
	Module Summary
	Key Terms
	Review Questions
	Case Exercises
		KimTay Pet Supplies
		StayWell Student Accommodation
Appendix A: SQL Reference
Appendix B: How Do I Reference
Appendix C: The 10 Commandments of Writing Queries
Index