Beginning SQL -- About the Authors -- Credits -- Contents -- Acknowledgments -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p. wrox. com -- Chapter 1: Introduction to SQL -- A Brief History of Databases -- Structured Query Language (SQL) -- Database Creation -- Creating, Altering, and Deleting Tables -- Good Database Design -- Creating the Example Database -- Summary -- Exercises -- Chapter 2: Entering Information -- Inserting New Data -- Inserting Data into the Case Study Database -- Updating Data -- Deleting Data -- Summary -- Exercises -- Chapter 3: Extracting Information -- The SELECT Statement -- Logical Operators and Operator Precedence -- Ordering Results with ORDER BY -- Selecting Data from More Than One Table -- Introducing NULL Data -- Summary -- Exercises -- Chapter 4: Advanced Database Design -- Normalization -- Ensuring Data Validity with Constraints -- Speeding Up Results with Indexes -- Summary -- Exercises -- Chapter 5: Manipulating Data -- Understanding SQL Arithmetic -- Introducing String Functions -- Converting Different Data Types -- Re-examining NULL -- Using INSERT INTO with the SELECT Statement -- Summary -- Exercises -- Chapter 6: Grouping and Aggregating Data -- Grouping Results -- Summarizing and Aggregating Data -- Using the HAVING Clause with GROUP BY Statements -- Summary -- Exercises -- Chapter 7: Selecting Data from Different Tables -- Joins Revisited -- Combining Results Sets with the UNION Operator -- Summary -- Exercises -- Chapter 8: Queries within Queries -- Subquery Terminology -- Subqueries in a SELECT List -- Subqueries in the WHERE Clause -- Operators in Subqueries -- Correlated Subquery -- Subqueries Used with Other Statements -- Summary -- Exercises -- Chapter 9: Advanced Queries.

Updating the Database -- Tackling Difficult Queries -- Top Tips for Efficient Queries -- Summary -- Exercises -- Chapter 10: Views -- Introducing Views -- Summary -- Exercises -- Chapter 11: Transactions -- Introducing Transactions -- Transaction Logs -- Locks -- Isolation Levels -- Problem Examples -- Revisiting the Example Code -- Summary -- Exercises -- Chapter 12: SQL Security -- Security Concepts -- Summary -- Exercises -- Chapter 13: Database Tuning -- Tuning Hardware -- Tuning SQL -- Tuning Tips -- Summary -- Exercises -- Appendix A: Exercise Answers -- Chapter 1 -- Chapter 2 -- Chapter 3 -- Chapter 4 -- Chapter 5 -- Chapter 6 -- Chapter 7 -- Chapter 8 -- Chapter 9 -- Chapter 10 -- Chapter 11 -- Chapter 12 -- Chapter 13 -- Appendix B: Setting Up and Using the Five Database Systems -- Installing and Using MySQL Version 4.1 -- Installing and Using IBM DB2 -- Installing and Using Microsoft Access XP -- Installing and Using Microsoft SQL Server 2000 -- Installing and Using Oracle 10g -- Appendix C: Initial Data Setup -- Category Table -- MemberDetails Table -- Location Table -- FavCategory Table -- Films Table -- Attendance Table -- Index.