Introduction 1 Who Is the Teach Yourself SQL Book For? . 1 DBMSs Covered in This Book . 2 Conventions Used in This Book . 2 1 Understanding SQL 5 Database Basics . 5 What Is SQL? . 10 Try It Yourself . 10 Summary . 12 2 Retrieving Data 13 The SELECT Statement .
13 Retrieving Individual Columns . 14 Retrieving Multiple Columns . 16 Retrieving All Columns . 17 Retrieving Distinct Rows . 17 Limiting Results . 19 Using Comments . 21 Summary . 22 Challenges .
23 3 Sorting Retrieved Data 25 Sorting Data . 25 Sorting by Multiple Columns . 27 Sorting by Column Position . 28 Specifying Sort Direction . 29 Summary . 30 Challenges . 31 4 Filtering Data 33 Using the WHERE Clause . 33 The WHERE Clause Operators .
34 Summary . 39 Challenges . 40 5 Advanced Data Filtering 41 Combining WHERE Clauses . 41 Using the IN Operator . 45 Using the NOT Operator . 46 Summary . 48 Challenges . 49 6 Using Wildcard Filtering 51 Using the LIKE Operator .
51 Tips for Using Wildcards . 57 Summary . 57 Challenges . 58 7 Creating Calculated Fields 59 Understanding Calculated Fields . 59 Concatenating Fields . 60 Performing Mathematical Calculations . 65 Summary . 67 Challenges .
68 8 Using Data Manipulation Functions 69 Understanding Functions . 69 Using Functions . 70 Summary . 77 Challenges . 78 9 Summarizing Data 79 Using Aggregate Functions . 79 Aggregates on Distinct Values . 85 Combining Aggregate Functions . 86 Summary .
87 Challenges . 88 10 Grouping Data 89 Understanding Data Grouping. 89 Creating Groups . 90 Filtering Groups . 91 Grouping and Sorting . 94 SELECT Clause Ordering . 96 Summary . 96 Challenges .
97 11 Working with Subqueries 99 Understanding Subqueries . 99 Filtering by Subquery . 99 Using Subqueries as Calculated Fields . 103 Summary . 105 Challenges . 106 12 Joining Tables 107 Understanding Joins . 107 Creating a Join . 109 Summary .
115 Challenges . 116 13 Creating Advanced Joins 117 Using Table Aliases . 117 Using Different Join Types . 118 Using Joins with Aggregate Functions . 123 Using Joins and Join Conditions . 124 Summary . 125 Challenges . 126 14 Combining Queries 127 Understanding Combined Queries.
127 Creating Combined Queries . 127 Summary . 133 &nb.