1. Relational Database Basics
A. Brief History of SQL
B. Relational Databases
- Tables
- Rows
- Columns
- Relationships
- Datatypes
- Primary Keys
- Foreign Keys
- Relational Database Management System
C. Popular Databases
- Commercial Databases
- Popular Open Source Databases
- Valid Object References
D. SQL Statements
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
2. Simple SELECTs
A. Introduction to the Northwind Database
B. Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
C. SELECTing All Columns in All Rows
D. Exploring the Tables
E. SELECTing Specific Columns
F. Sorting Records
- Sorting By a Single Column
- Sorting By Multiple Columns
- Sorting By Column Position
- Ascending and Descending Sorts
G. The WHERE Clause and Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
H. The WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
I. More SELECTs with WHERE
J. Checking Multiple Conditions
- AND
- OR
- Order of Evaluation
K. Writing SELECTs with Multiple Conditions
3. Advanced SELECTs
A. Calculated Fields
- Concatenation
- Mathematical Calculations
- Aliases
B. Calculating Fields
C. Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
- Selecting Distinct Records
D. Working with Aggregate Functions
E. Built-in Data Manipulation Functions
- Common Math Functions
- Common String Functions
- Common Date Functions
F. Data Manipulation Functions
4. Subqueries, Joins and Unions
A. Subqueries
B. Joins
- Table Aliases
- Multi-table Joins
C. Using Joins
D. Outer Joins
E. Unions
F. Working with Unions
If time allows, one or more of the following may be covered:
A. Conditional Processing with CASE
B. INSERT, UPDATE, DELETE
C. Student Challenges – Design your own reports