You are previewing Sams Teach Yourself SQL in 10 Minutes.
O'Reilly logo
Sams Teach Yourself SQL in 10 Minutes

Book Description

Sams Teach Yourself SQL in 10 Minutes is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well-targeted lessons teach you in 10 minutes what some books take several hours or days to teach. It is for those users who don't have the time to read lengthy chapters, or are not inclined to read "manuals." You will learn retrieving and sorting data, advanced data filtering, using wildcard filtering, manipulating data, combining queries, using views, creating and using stored procedures, and creating triggers.

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