SQL in 10 Minutes, Sams Teach Yourself

Ben Forta is Adobe Systems’ Director of Developer Relations and has more than 20 years of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes, spinoff titles on MySQL and SQL Server T-SQL, ColdFusion Web Application Construction Kit and Advanced ColdFusion Application Development (both published by Adobe Press), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, Windows, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on Internet and database technologies. 

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

1 Understanding SQL
Database Basics


What Is SQL?


Try It Yourself


2 Retrieving Data


The SELECT Statement


Retrieving Individual Columns


Retrieving Multiple Columns


Retrieving All Columns


Retrieving Distinct Rows


Limiting Results


Using Comments


3 Sorting Retrieved Data


Sorting Data


Sorting by Multiple Columns


Sorting by Column Position


Specifying Sort Direction


4 Filtering Data


Using the WHERE Clause


The WHERE Clause Operators


5 Advanced Data Filtering


Combining WHERE Clauses


Using the IN Operator


Using the NOT Operator


6 Using Wildcard Filtering


Using the LIKE Operator


Tips for Using Wildcards


7 Creating Calculated Fields


Understanding Calculated Fields


Concatenating Fields


Performing Mathematical Calculations


8 Using Data Manipulation Functions


Understanding Functions


Using Functions


9 Summarizing Data


Using Aggregate Functions


Aggregates on Distinct Values


Combining Aggregate Functions


10 Grouping Data


Understanding Data Grouping


Creating Groups


Filtering Groups


Grouping and Sorting


SELECT Clause Ordering


11 Working with Subqueries


Understanding Subqueries


Filtering by Subquery


Using Subqueries as Calculated Fields


12 Joining Tables


Understanding Joins


Creating a Join


13 Creating Advanced Joins


Using Table Aliases


Using Different Join Types


Using Joins with Aggregate Functions


Using Joins and Join Conditions


14 Combining Queries


Understanding Combined Queries


Creating Combined Queries


15 Inserting Data


Understanding Data Insertion


Copying from One Table to Another


16 Updating and Deleting Data


Updating Data


Deleting Data


Guidelines for Updating and Deleting Data


17 Creating and Manipulating Tables


Creating Tables


Updating Tables


Deleting Tables


Renaming Tables


18 Using Views


Understanding Views


Creating Views


19 Working with Stored Procedures


Understanding Stored Procedures


Why to Use Stored Procedures


Executing Stored Procedures


Creating Stored Procedures


20 Managing Transaction Processing


Understanding Transaction Processing


Controlling Transactions


21 Using Cursors


Understanding Cursors


Working with Cursors


22 Understanding Advanced SQL Features


Understanding Constraints


Understanding Indexes


Understanding Triggers


Database Security


A Sample Table Scripts


Understanding the Sample Tables


Obtaining the Sample Tables


B Working in Popular Applications


Using Apache Open Office Base


Using Adobe ColdFusion


Using IBM DB2


Using MariaDB


Using Microsoft Access


Using Microsoft ASP


Using Microsoft ASP.NET


Using Microsoft Query


Using Microsoft SQL Server (including Microsoft SQL Server Express)


Using MySQL


Using Oracle


Using Oracle Express


Using PHP


Using PostgreSQL


Using SQLite


Configuring ODBC Data Sources


C SQL Statement Syntax


ALTER TABLE


COMMIT


CREATE INDEX


CREATE PROCEDURE


CREATE TABLE


CREATE VIEW


DELETE


DROP


INSERT


INSERT SELECT


ROLLBACK


SELECT


UPDATE


D Using SQL Datatypes


String Datatypes


Numeric Datatypes


Date and Time Datatypes


Binary Datatypes


E SQL Reserved Words