Introduction
  • Introduction
  • What is SQL?
  • Getting Familiar with SQL Server Management Studio
  • Installing the Exercise Databases
  • Steps for a Successful Course
SQL: SELECT
  • The SELECT Syntax
  • SELECT Statements
  • Aliasing Columns
  • DISTINCT
  • Section SQL: SELECT
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
SQL: WHERE
  • The WHERE Syntax
  • Understanding LIKE, %
  • Understanding [ ]
  • Understanding NOT, ^
  • Understanding BETWEEN... AND
  • Understanding IN
  • Understanding NULL, NOT NULL
  • WHERE (1)
  • WHERE (2)
  • Section SQL: WHERE
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
SQL: ORDER BY
  • The ORDER BY Syntax
  • ORDER BY
  • Section SQL: ORDER BY
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
Introduction to Aggregate Functions in SQL
  • Aggregate Functions
  • SUM
  • COUNT
  • MIN, MAX and AVG (Average)
  • Section SQL: Aggregate Functions
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
SQL: Date and Time Functions
  • Displaying the Current System Date and Time
  • Formatting Dates and Times Using CONVERT
  • DAY, MONTH, YEAR Functions
  • DATEPART
  • DATEADD
  • DATEDIFF
  • Section SQL: Date and Time Function
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
SQL: String Functions
  • CONCAT
  • LOWER and UPPER
  • LEFT and RIGHT
  • SUBSTRING
  • LEN
  • LTRIM, and RTRIM
  • REPLACE
  • Section SQL: String Functions
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
SQL: Subqueries
  • Subqueries
  • Using EXISTS with Subqueries
  • Section SQL: Subqueries
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
Joining Tables Using SQL
  • Introduction to Joins
  • Common Types of Joins
  • The JOIN Syntax
  • Inner Joins
  • Outer Joins
  • Examples of Three or More Table Joins - UPDATED
  • Aliasing Tables in Joins
  • Union Joins
  • Self Joins
  • FAQ: Subqueries v. Joins
  • Section SQL: Joining Tables with SQL
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
  • How are you enjoying the course?
SQL: Views
  • Introduction to Views
  • Creating Views
  • Schemabinding
  • Altering Views
  • Dropping Views
  • Section SQL: Views
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers
SQL: Stored Procedures
  • Introduction to Stored Procedures
  • Creating Stored Procedures
  • Modifying Stored Procedures
  • Dropping Stored Procedures
  • Section SQL: Stored Procedures
  • Exercise: Lesson Lab Questions
  • Exercise: Lesson Lab Answers