Preface; Why Learn SQL?; Why Use This Book to Do It?; Structure of This Book; Conventions Used in This Book; How to Contact Us; Using Code Examples; Safari Enabled; Acknowledgments;Chapter 1: A Little Background; 1.1 Introduction to Databases; 1.2 What Is SQL?; 1.3 What Is MySQL?; 1.4 What's in Store;Chapter 2: Creating and Populating a Database; 2.1 Creating a MySQL Database; 2.2 Using the mysql Command-Line Tool; 2.3 MySQL Data Types; 2.

4 Table Creation; 2.5 Populating and Modifying Tables; 2.6 When Good Statements Go Bad; 2.7 The Bank Schema;Chapter 3: Query Primer; 3.1 Query Mechanics; 3.2 Query Clauses; 3.3 The select Clause; 3.4 The from Clause; 3.

5 The where Clause; 3.6 The group by and having Clauses; 3.7 The order by Clause; 3.8 Exercises;Chapter 4: Filtering; 4.1 Condition Evaluation; 4.2 Building a Condition; 4.3 Condition Types; 4.4 NULL: That Four-Letter Word; 4.

5 Exercises;Chapter 5: Querying Multiple Tables; 5.1 What Is a Join?; 5.2 Joining Three or More Tables; 5.3 Self-Joins; 5.4 Equi-Joins Versus Non-Equi-Joins; 5.5 Join Conditions Versus Filter Conditions; 5.6 Exercises;Chapter 6: Working with Sets; 6.1 Set Theory Primer; 6.

2 Set Theory in Practice; 6.3 Set Operators; 6.4 Set Operation Rules; 6.5 Exercises;Chapter 7: Data Generation, Conversion, and Manipulation; 7.1 Working with String Data; 7.2 Working with Numeric Data; 7.3 Working with Temporal Data; 7.4 Conversion Functions; 7.

5 Exercises;Chapter 8: Grouping and Aggregates; 8.1 Grouping Concepts; 8.2 Aggregate Functions; 8.3 Generating Groups; 8.4 Group Filter Conditions; 8.5 Exercises; 8.6 8-4 (Extra Credit);Chapter 9: Subqueries; 9.1 What Is a Subquery?; 9.

2 Subquery Types; 9.3 Noncorrelated Subqueries; 9.4 Correlated Subqueries; 9.5 When to Use Subqueries; 9.6 Subquery Wrap-up; 9.7 Exercises;Chapter 10: Joins Revisited; 10.1 Outer Joins; 10.2 Cross Joins; 10.

3 Natural Joins; 10.4 Exercises;Chapter 11: Conditional Logic; 11.1 What Is Conditional Logic?; 11.2 The Case Expression; 11.3 Case Expression Examples; 11.4 Exercises;Chapter 12: Transactions; 12.1 Multiuser Databases; 12.2 What Is a Transaction?;Chapter 13: Indexes and Constraints; 13.

1 Indexes; 13.2 Constraints;Appendix A: ER Diagram for Example Database;Appendix B: MySQL Extensions to the SQL Language; B.1 Select Extensions; B.2 Combination Insert/Update Statements; B.3 Ordered Updates and Deletes; B.4 Multitable Updates and Deletes;Appendix C: Solutions to Exercises; C.1 Chapter 3; C.2 Chapter 4; C.

3 Chapter 5; C.4 Chapter 6; C.5 Chapter 7; C.6 Chapter 8; C.7 8-4 (Extra Credit); C.8 Chapter 9; C.9 Chapter 10; C.10 Chapter 11;Appendix D: Further Resources; D.

1 Advanced SQL; D.2 Database Programming; D.3 Database Design; D.4 Database Tuning; D.5 Database Administration; D.6 Report Generation;Colophon;.