Introduction to SELECT Statements
  • START HERE: Introduction Lecture
  • ALSO START HERE: T-SQL Training Guide
  • Installing SQL Server Written Instructions
  • How to Install Microsoft SQL Server Express
  • How to Attach the AdventureWorks Sample 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
Using SQL Server Functions
  • Using SQL Server Functions - Part 1
  • Using SQL Server Functions - Part 2
  • Using SQL Server Functions - Part 3
  • Using SQL Server Functions - Part 4
  • Using SQL Server Functions - Part 5
  • Using SQL Server Functions - Part 6
  • Using SQL Server Functions - Part 7
  • Using SQL Server Functions - Part 8
  • Nesting Functions - Part 1
  • Nesting Functions - Part 2
  • SQL String and Nesting Function Practice Problems
  • Using Date Functions - Part 1
  • Using Date Functions - Part 2
  • Using Date Functions - Part 3
  • Date Function Practice Problems
  • NULL Handling Functions - Part 1
  • NULL Handling Functions - Part 2
  • NULL Handling Function Practice Problems
SQL Server Data Types and Type Casting
  • The Basics of SQL Server Data Types and Type Casting Functions
  • SQL Server Type Casting and Data Types Practice Problems
Working with Table Expressions
  • Using Derived Tables - Part 1
  • Using Derived Tables - Part 2
  • Using Derived Tables - Part 3
  • Using Derived Tables - Part 4
  • Using Derived Tables - Part 5
  • Derived Table Practice Problems
  • Working with CTEs - Part 1
  • Working with CTEs - Part 2
  • Working with CTEs - Part 3
  • Working with CTEs - Part 4
  • Common Table Expression (CTE) Practice Problems
CASE Statements
  • Using CASE Statements - Part 1
  • Using CASE Statements - Part 2
  • Using CASE Statements - Part 3
  • Using CASE Statements - Part 4
  • Using CASE Statements - Part 5
  • Using CASE Statements - Part 6
  • CASE Statement Practice Problems
Creating Tables and Inserting/Updating Data
  • Creating a Table
  • Insert Data into a Table
  • Updating Data in a Table