List of Examples
Chapter 2:
Retrieving Data with SQL
JOINING STRINGS (SQL SERVER)
JOINING STRINGS (MYSQL)
JOINING STRINGS (ORACLE)
JOINING STRINGS (DB2)
JOINING STRINGS (ACCESS)
WHERE CLAUSE COMPARISONS
FINDING RECORDS IN A SET
PATTERN MATCHING
COMPLEX PATTERN MATCHING (ACCESS AND SQL SERVER)
REGULAR EXPRESSION MATCHING (MYSQL)
Chapter 3:
Modifying Data
ADDING A SINGLE ROW TO A TABLE
ADDING MULTIPLE ROWS TO A TABLE
MODIFYING ROW DATA
DELETING ROW DATA
Chapter 4:
Summarizing and Grouping Data
COUNTING ROWS
SUMMING COLUMNS
GETTING COLUMN AVERAGES
MAXIMUM AND MINIMUM COLUMN VALUES
GROUPING DATA
RETRIEVING THE TOP FIVE STUDENTS (SQL SERVER/ACCESS)
RETRIEVING THE TOP FIVE STUDENTS (MYSQL)
RETRIEVING THE TOP FIVE STUDENTS (DB2)
RETRIEVING THE TOP FIVE STUDENTS (ORACLE)
Chapter 5:
Performing Calculations and using Functions
USING EXPRESSIONS
ROUNDING UP AND DOWN (SQL SERVER AND DB2)
ROUNDING UP AND DOWN (ORACLE)
ROUNDING UP AND DOWN (MYSQL)
ROUNDING UP AND DOWN (ACCESS)
MANIPULATING STRINGS (SQL SERVER)
MANIPULATING STRINGS (ORACLE)
MANIPULATING STRINGS (DB2)
MANIPULATING STRINGS (MYSQL)
MANIPULATING STRINGS (ACCESS)
DIFFERENCES BETWEEN DATES (SQL SERVER)
DIFFERENCES BETWEEN DATES (ORACLE)
DIFFERENCES BETWEEN DATES (DB2)
DIFFERENCES BETWEEN DATES (MYSQL)
DIFFERENCES BETWEEN DATES (ACCESS)
CREATING A FUNCTION (SQL SERVER)
CREATING A FUNCTION (ORACLE)
CREATING A FUNCTION (DB2)
CREATING A FUNCTION (MYSQL)
Chapter 6:
Combining SQL Queries
SIMPLE SUBQUERIES
USING ALIASES WITH SIMPLE SUBQUERIES
USING SET MEMBERSHIP WITH SUBQUERIES
USING THE EXISTS OPERATOR
USING THE ALL OPERATOR
USING THE ANY OPERATOR
COMBINING DATA WITH UNION
Chapter 7:
Querying Multiple Tables
TWO TABLE EQUI-JOINS
MULTI-TABLE EQUI-JOINS (NOT ACCESS)
NESTED MULTI-TABLE EQUI-JOINS (ALL PLATFORMS)
NON-EQUI JOINS
INNER AND OUTER JOINS
Chapter 8:
Hiding Complex SQL with Views
CREATING A VIEW (SQL SERVER)
CREATING A VIEW (ORACLE)
CREATING A VIEW (DB2)
CHANGING A VIEW
DELETING A VIEW
Chapter 9:
Using Stored Procedures
CREATING A SIMPLE STORED PROCEDURE (SQL SERVER)
CREATING A SIMPLE STORED PROCEDURE (ORACLE)
CREATING A SIMPLE STORED QUERY (ACCESS)
USING OUTPUT PARAMETERS (SQL SERVER)
USING OUTPUT PARAMETERS (ORACLE)
USING OUTPUT PARAMETERS (DB2)
CONDITIONAL EXPRESSIONS (SQL SERVER)
CONDITIONAL EXPRESSIONS (ORACLE)
CONDITIONAL EXPRESSIONS (DB2)
USING CURSORS (SQL SERVER)
USING CURSORS (ORACLE)
USING CURSORS (DB2)
RETURNING ROWS (SQL SERVER AND ACCESS)
RETURNING ROWS (DB2)
RETURNING ROWS (ORACLE)
ERROR HANDLING (SQL SERVER)
ERROR HANDLING (ORACLE)
ERROR HANDLING (DB2)
Chapter 10:
Transactions
SQL SERVER TRANSACTIONS AND SAVEPOINTS
SQL SERVER TRANSACTIONS WITH ERROR HANDLING
ORACLE TRANSACTIONS AND SAVEPOINTS
ORACLE TRANSACTIONS AND EXCEPTION HANDLING
DB2 TRANSACTIONS
MYSQL TRANSACTIONS
Chapter 12:
Working with Database Objects
USING TEMPORARY TABLES (SQL SERVER)
USING TEMPORARY TABLES (ORACLE)
USING TEMPORARY TABLES (DB2)
USING TEMPORARY TABLES (MYSQL)
AUTONUMBERED COLUMNS (SQL SERVER)
AUTONUMBERED COLUMNS (ORACLE)
AUTONUMBERED COLUMNS (DB2)
AUTONUMBERED COLUMNS (MYSQL)
AUTONUMBERED COLUMNS (ACCESS)
Appendix B:
Setting up the InstantUniversity Database
TESTING THE DATA 1
TESTING THE DATA 2
