Latest SQL for Non-Programmers Quick Tip
  • Quick Tip: Getting Only What You Need
Introduction to Scripting SQL with Microsoft Access
  • Welcome
  • Using the Exercise Database
  • Steps for a Successful Course
SQL: SELECT
  • The SELECT Syntax
  • SELECT Statements
  • Aliasing Columns
  • Section SQL - SELECT
  • Exercise: Lesson Lab
SQL: WHERE
  • The WHERE Syntax
  • Understanding LIKE, *, and [ ]
  • Understanding NOT, !, BETWEEN...AND, IN, NULL, NOT NULL
  • WHERE Part I
  • WHERE Part II
  • Section SQL - WHERE
  • Exercise: Lesson Lab
SQL: ORDER BY
  • The ORDER BY Syntax
  • ORDER BY
  • Section SQL - ORDER BY
  • Exercise: Lesson Lab
Introduction to Aggregate Functions in SQL
  • Intro to Aggregate Functions
  • SUM
  • AVERAGE
  • COUNT
  • MIN and MAX
  • Section SQL - Aggregate Functions
  • Exercise: Lesson Lab
SQL: Date Functions
  • Date
  • Now
  • Day
  • MonthName
  • DatePart
  • DateAdd
  • DateDiff
  • DateValues
  • Formatting Dates
  • Section SQL - Date Functions
  • Exercise: Lesson Lab
SQL: String Functions
  • Using CONCATENATE
  • LCase and UCase
  • Left and Right
  • Mid
  • Len
  • Trim, LTrim, and RTrim
  • Replace
  • Section SQL - String Functions
  • Exercise: Lesson Lab
Updating and Deleting Records Using SQL
  • The UPDATE Syntax
  • UPDATE
  • The DELETE Syntax
  • DELETE
  • Section SQL - Updating and Deleting Records
  • Exercise: Lesson Lab
  • How Are You Enjoying the Course?
SQL: Subqueries
  • Subqueries
  • Using EXISTS with Subqueries
  • Section SQL - Subqueries
  • Exercise: Lesson Lab
Joining Tables Using SQL
  • Primary Key and Foreign Key
  • Common Types of Joins
  • The JOIN Syntax
  • JOIN
  • More Examples of Three Table Joins
  • Aliasing Tables in Joins
  • Subqueries vs. Joins
  • Section SQL - Joins
  • Exercise: Lesson Lab
SQL: Tables
  • The CREATE TABLE Syntax
  • Data Types
  • CREATE TABLE I
  • CREATE TABLE II
  • The INSERT INTO Syntax
  • INSERT INTO
  • ALTER TABLE
  • Section SQL - Tables
  • Exercise: Lesson Lab
Other SQL Clauses & Functions
  • Using TRANSFORM and PIVOT to Create Crosstabs
  • Using DISTINCT
  • Using TOP
  • UNION Queries
  • Formatting Numbers
  • Section SQL - Other Clauses & Functions
Test Your SQL Skills
  • Test Your Skills Questions
  • Test Your Skills Answers
  • Thank you!
  • Next Steps for Success