Introduction to SELECT Statements
  • START HERE: Introduction Lecture
  • How to Install Microsoft SQL Server Express
  • How to Download and Install SQL Server Express
  • How to Attach the AdventureWorks Database
  • Introduction to T-SQL and Database Concepts
  • Literal SELECT Statements - Part 1
  • Literal SELECT Statements - Part 2
  • Literal SELECT Statement Practice Problems
  • Basic SELECT Statements - Part 1
  • Basic SELECT Statements - Part 2
  • Basic SELECT Statements - Part 3
  • Basic SELECT Statement Practice Problems
Filtering Data with the WHERE Clause
  • Using the WHERE Clause - Part 1
  • Using the WHERE Clause - Part 2
  • Using the WHERE Clause - Part 3
  • Using the WHERE Clause - Part 4
  • Using the WHERE Clause - Part 5
  • Using the WHERE Clause - Part 6
  • Using the WHERE Clause - Part 7
  • WHERE Clause Practice Problems
Sorting Data with the ORDER BY Clause
  • Sorting with the ORDER BY Clause - Part 1
  • Sorting with the ORDER BY Clause - Part 2
  • ORDER BY Clause Practice Problems
Querying Multiple Tables with Joins
  • Using the INNER JOIN - Part 1
  • Using the INNER JOIN - Part 2
  • INNER JOIN Practice Problems
  • Using the LEFT OUTER JOIN - Part 1
  • Using the LEFT OUTER JOIN - Part 2
  • Using the LEFT OUTER JOIN - Part 3
  • LEFT/RIGHT OUTER JOIN Practice Problems
Aggregate Functions
  • Aggregate Functions - Part 1
  • Aggregate Functions - Part 2
  • Aggregate Function Practice Problems
Grouping Data with the GROUP BY Clause
  • Grouping with the GROUP BY Clause - Part 1
  • Grouping with the GROUP BY Clause - Part 2
  • GROUP BY Clause Practice Problems
Filtering Groups with the HAVING Clause
  • Filtering Groups with the HAVING Clause - Part 1
  • Filtering Groups with the HAVING Clause - Part 2
  • HAVING Clause Practice Problems