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

Book Description

Sams Teach Yourself SQL in 10 Minutes, 2E 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. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.

The reader of this book will learn how to:

  • Retrieve and sort data

  • Filter data using comparisons and wildcards

  • Use the aggregate functions to analyze data

  • Perform insert, update, and delete operations

  • Join relational tables using inner, outer, and self joins

  • Combine queries using unions

  • Use views

  • Create and use stored procedures, triggers, and other advanced database features

  • 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. Try It Yourself
      4. 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. Working with Stored Procedures
      1. Understanding Stored Procedures
      2. Why to Use Stored Procedures
      3. Executing Stored Procedures
      4. Creating Stored Procedures
      5. Summary
    25. Managing Transaction Processing
      1. Understanding Transaction Processing
      2. Controlling Transactions
      3. Summary
    26. Using Cursors
      1. Understanding Cursors
      2. Working with Cursors
      3. Summary
    27. Understanding Advanced SQL Features
      1. Understanding Constraints
      2. Understanding Indexes
      3. Understanding Triggers
      4. Database Security
      5. Summary
    28. Sample Table Scripts
      1. Sample Tables Overview
      2. Creating the Sample Tables
      3. Populating the Sample Tables
    29. Working in Popular Applications
      1. Configuring ODBC Data Sources
      2. Using Allaire ColdFusion
      3. Using Allaire JRun 3.x
      4. Using DB2
      5. Using Informix Dynamic Server 7.x
      6. Using Microsoft Access
      7. Using Microsoft ASP
      8. Using Microsoft Query
      9. Using Microsoft SQL Server 6.x
      10. Using Microsoft SQL Server 7
      11. Using Microsoft SQL Server 2000
      12. Using Microsoft Visual Basic
      13. Using Microsoft Visual C++
      14. Using Oracle 8
      15. Using Query Tool
      16. Using Sybase
    30. SQL Statement Syntax
      1. ALTER TABLE
      2. COMMIT
      3. CREATE INDEX
      4. CREATE PROCEDURE
      5. CREATE TABLE
      6. CREATE VIEW
      7. DELETE
      8. DROP
      9. INSERT
      10. INSERT SELECT
      11. ROLLBACK
      12. SELECT
      13. UPDATE
    31. Using SQL Datatypes
      1. String Datatypes
      2. Numeric Datatypes
      3. Date and Time Datatypes
      4. Binary Datatypes
    32. SQL Reserved Words
    33. Index