A Guide to SQL

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