SQL Language Introduction - 1 Day

Overview of SQL
The SELECT statement
Sorting Retrieved Data
Filtering Data
Calculated Fields

Inserting Data
Updating Records
Deleting Records
Understanding the Principles of Relational Databases
Using a Relational Database to Retrieve Data

SQL Language Intermediate - 1 Day

Brief Review of Select Statements
Include info on Comparison Operators - perhaps most part use exercises to gauge how well they know the basics of SQL
Advanced Select Statements
Distinct
SELECT INTO

Ordering Data
Using AND & OR for comparison
Group By
SQL IN (and NOT IN)
SQL BETWEEN …. AND (and NOT BETWEEN)
SQL HAVING
Mathematical Operators - Advanced

SQL Aliases
SQL Joins
INNER JOINS
LEFT JOIN
RIGHT JOIN
SQL UNION
UNION ALL
Modifying the Database

SQL Creating Indexes
SQL Creating Tables
SQL Creating Databases

SQL DROP
Truncating Tables
SQL ALTER TABLE
SQL Functions
Aggregate Functions
Aggregate Functions and Access
Aggregate Functions and SQL Server
Scalar Functions