· Establish baseline knowledge required elsewhere in course

· Elements of the SELECT statement

· Optional clauses

· Working with NULL values

· Working with Dates

2: Working with Views

· Nature and purpose of views

· Creating and modifying view

· Limitations and cautions

3: Advanced SQL Query Tactics

· Scalar and vector aggregations

· Everything you need to know about JOINS

· UNION queries

· GROUP BY queries

· Sub-queries

4: Data Manipulation Statements

· Insert statements

· Update statements

· Delete statements

· Manipulation through views and over JOINs

5: Working with Procedures

· Nature and purpose of stored procedures and functions

· Calling stored procedures for effect

· Passing input parameters to stored procedures

· Calling procedures that return data

· Calling built-in functions

· Calling user-defined functions

6: Task-Oriented Queries

· Finding unmatched or missing records

· Finding duplicates

· Calculating running sums

· Changing a primary key