Cover -- SQL: Practical Guide for Developers -- Copyright -- Table of Contents -- Preface -- Chapter 1. Databasics -- 1.1 Tables -- 1.2 Data Types -- 1.3 NULL -- 1.4 Primary Key -- 1.5 Table Relationships -- 1.6 Restaurant Database -- 1.7 Wrap Up -- Chapter 2. Retrieval: Basic SELECTion -- 2.1 Simple SELECT -- 2.2 Selecting Rows -- 2.3 Standard Comparison Operators -- 2.4 String Comparisons -- 2.5 Matching String Patterns with LIKE -- 2.6 Getting What We Haven't Got with NOT -- 2.7 Combining Conditions with AND and OR -- 2.8 Selecting a Range of Values with BETWEEN -- 2.9 Selecting a Set of Values Using IN -- 2.10 IS NULL: Exploring the Unknown -- 2.11 ANDs, ORs, NOTs with NULLs: Three-Valued Logic -- 2.12 Three-Valued Logic and the IN Operator -- 2.13 How WHERE Determines What's In and Out -- 2.14 Wrap Up -- Chapter 3. Reshaping Results -- 3.1 AS: Naming Result Table Columns -- 3.2 DISTINCT and ALL: Dealing with Duplicates -- 3.3 Derived Attributes -- 3.4 Computation in the WHERE Clause -- 3.5 ORDER BY: Ordering Result Table Traversal -- 3.6 CAST: Data Type Conversion -- 3.7 CASE, COALESCE, and NULLIF: Conditional Expressions -- 3.8 Wrap Up -- Chapter 4. Aggregating Results -- 4.1 Aggregation Functions -- 4.2 Removing Rows before Aggregation with WHERE -- 4.3 Removing Repeating Data with DISTINCT before Aggregation -- 4.4 Mixing Attributes, Aggregates, and Literals -- 4.5 Group Aggregation Using GROUP BY -- 4.6 Removing Rows before Grouping with WHERE -- 4.7 Sorting Groups with ORDER BY -- 4.8 Removing Groups with HAVING -- 4.9 Aggregates over Expressions -- 4.10 Wrap Up -- Chapter 5. Joins -- 5.1 Two Table Joins with WHERE -- 5.2 Table Aliases -- 5.3 Joins Needing More Than Two Tables -- 5.4 Self-Join: Joining a Table with Itself -- 5.5 Example Joins -- 5.6 How Does a Join Really Work? -- 5.7 Theta Joins: Generalizing Join Predicates.

5.8 JOIN Operator -- 5.9 Join Strategies -- 5.10 Wrap Up -- Chapter 6. Set Queries: UNION, INTERSECT, and EXCEPT -- 6.1 UNION -- 6.2 INTERSECT -- 6.3 EXCEPT -- 6.4 Wrap Up -- Chapter 7. Subqueries -- 7.1 What Are Subqueries? -- 7.2 Multilevel Subquery Nesting -- 7.3 Subqueries Using NOT IN -- 7.4 Subqueries with Empty Results -- 7.5 Combining JOIN and Subqueries -- 7.6 Standard Comparison Operators with Lists Using ANY, SOME, or ALL -- 7.7 Correlated Subqueries -- 7.8 EXISTS -- 7.9 Derived Relations„Subqueries in the FROM Clause -- 7.10 Subqueries in the HAVING Clause -- 7.11 Subset Queries -- 7.12 Subqueries in the SELECT Clause -- 7.13 Wrap Up -- Chapter 8. Modifying Data -- 8.1 INSERT: Adding New Rows -- 8.2 DELETE: Removing Rows -- 8.3 UPDATE: Changing Row Values -- 8.4 Testing Your DELETE and UPDATE WHERE Conditions -- 8.5 Living within Constraints -- 8.6 Wrap Up -- Chapter 9. Creating, Deleting, and Altering Tables -- 9.1 Creating Simple Tables -- 9.2 DEFAULT Values -- 9.3 Constraints -- 9.4 Creating a Table from Tables -- 9.5 CREATE DOMAIN -- 9.6 Referential Actions: The Autopilot of Foreign Key Maintenance -- 9.7 Indexes -- 9.8 DROP TABLE -- 9.9 ALTER TABLE -- 9.10 Generated Values -- 9.11 Sequences -- 9.12 Global and Local Temporary Tables -- 9.13 Creating a Database -- 9.14 Wrap Up -- Chapter 10. Views -- 10.1 Why Views? -- 10.2 Querying Views -- 10.3 Updating Views -- 10.4 DROP VIEW -- 10.5 Wrap Up -- Chapter 11. Transactions -- 11.1 Ending a Transaction„COMMIT and ROLLBACK -- 11.2 Starting a Transaction„START TRANSACTION -- 11.3 Auto-Commit -- 11.4 SAVEPOINTs -- 11.5 Immediate or Deferred Constraints -- 11.6 Testing Changes with Transactions -- 11.7 Transaction Characteristics -- 11.8 Locking Issues -- 11.9 Wrap Up -- Chapter 12. Database Privileges -- 12.1 GRANT -- 12.2 REVOKE -- 12.3 PUBLIC.

12.4 Creating a Set of Privileges Using ROLEs -- 12.5 Using Privileges and Views -- 12.6 Wrap Up -- Chapter 13. Introduction to Cursors, Embedded SQL, Stored Procedures, and Triggers -- 13.1 CURSORs -- 13.2 Programming with SQL -- 13.3 Triggers -- 13.4 Wrap Up -- Index.