Sams Teach Yourself SQL in 10 Minutes

Table of contents

1. Copyright
2. About the Author
3. Acknowledgments
4. Tell Us What You Think!
5. Introduction
6. Understanding SQL
   1. Database Basics
   2. What Is SQL?
   3. Summary
7. Retrieving Data
   1. The SELECT Statement
   2. Retrieving Individual Columns
   3. Retrieving Multiple Columns
   4. Retrieving All Columns
   5. Summary
8. Sorting Retrieved Data
   1. Sorting Data
   2. Sorting by Multiple Columns
   3. Sorting by Column Position
   4. Specifying Sort Direction
   5. Summary
9. Filtering Data
   1. Using the WHERE Clause
   2. The WHERE Clause Operators
   3. Summary
10. Advanced Data Filtering
    1. Combining WHERE Clauses
    2. Using the IN Operator
    3. Using the NOT Operator
    4. Summary
11. Using Wildcard Filtering
    1. Using the LIKE Operator
    2. Tips for Using Wildcards
    3. Summary
12. Creating Calculated Fields
    1. Understanding Calculated Fields
    2. Concatenating Fields
    3. Performing Mathematical Calculations
    4. Summary
13. Using Data Manipulation Functions
    1. Understanding Functions
    2. Using Functions
    3. Summary
14. Summarizing Data
    1. Using Aggregate Functions
    2. Aggregates on Distinct Values
    3. Combining Aggregate Functions
    4. Summary
15. Grouping Data
    1. Understanding Data Grouping
    2. Creating Groups
    3. Filtering Groups
    4. Grouping and Sorting
    5. SELECT Clause Ordering
    6. Summary
16. Working With Subqueries
    1. Understanding Subqueries
    2. Filtering by Subquery
    3. Using Subqueries as Calculated Fields
    4. Summary
17. Joining Tables
    1. Understanding Joins
    2. Creating a Join
    3. Summary
18. Creating Advanced Joins
    1. Using Table Aliases
    2. Join Types
    3. Using Joins with Aggregate Functions
    4. Using Joins and Join Conditions
    5. Summary
19. Combining Queries
    1. Understanding Combined Queries
    2. Creating Combined Queries
    3. Summary
20. Inserting Data
    1. Understanding Data Insertion
    2. Copying from One Table to Another
    3. Summary
21. Updating and Deleting Data
    1. Updating Data
    2. Deleting Data
    3. Guidelines for Updating and Deleting Data
    4. Summary
22. Creating and Manipulating Tables
    1. Creating Tables
    2. Updating Tables
    3. Deleting Tables
    4. Renaming Tables
    5. Summary
23. Using Views
    1. Understanding Views
    2. Creating Views
    3. Summary
24. Using Transaction Processing
    1. Understanding Transaction Processing
    2. Controlling Transactions
    3. Summary
25. Understanding Advanced SQL Features
    1. Understanding Constraints
    2. Understanding Indexes
    3. Understanding Stored Procedures
    4. Understanding Triggers
    5. Summary
26. Sample Table Scripts
    1. Sample Tables Overview
    2. Creating the Sample Tables
    3. Populating the Sample Tables
27. Working in Popular Applications
    1. Configuring ODBC Data Sources
    2. Using Allaire ColdFusion
    3. Using DB2
    4. Using Informix Dynamic Server 7.x
    5. Using Microsoft Access
    6. Using Microsoft ASP
    7. Using Microsoft Query
    8. Using Microsoft SQL Server 6.x
    9. Using Microsoft SQL Server 7
    10. Using Microsoft Visual Basic
    11. Using Microsoft Visual C++
    12. Using Oracle 8
    13. Using Sybase
28. SQL Statement Syntax
    1. ALTER TABLE
    2. COMMIT
    3. CREATE INDEX
    4. CREATE TABLE
    5. CREATE VIEW
    6. DELETE
    7. DROP
    8. INSERT
    9. INSERT SELECT
    10. ROLLBACK
    11. SELECT
    12. UPDATE
29. Using SQL Datatypes
    1. String Datatypes
    2. Numeric Datatypes
    3. Date and Time Datatypes
    4. Binary Datatypes
30. SQL Reserved Words
31. Index