Section 1 : Introduction to SELECT Statements

Lecture 1 START HERE Introduction Lecture 4:11
Lecture 2 How to Install Microsoft SQL Server Express Pdf
Lecture 3 How to Download and Install SQL Server Express 11:26
Lecture 4 How to Attach the AdventureWorks Database 4:45
Lecture 5 Introduction to T-SQL and Database Concepts 4:13
Lecture 6 Literal SELECT Statements - Part 1
Lecture 7 Literal SELECT Statements - Part 2 3:39
Lecture 8 Literal SELECT Statement Practice Problems Pdf
Lecture 9 Basic SELECT Statements - Part 1 8:42
Lecture 10 Basic SELECT Statements - Part 2 8:10
Lecture 11 Basic SELECT Statements - Part 3 6:29
Lecture 12 Basic SELECT Statement Practice Problems Pdf

Section 2 : Filtering Data with the WHERE Clause

Lecture 13 Using the WHERE Clause - Part 1 5:33
Lecture 14 Using the WHERE Clause - Part 2 5:11
Lecture 15 Using the WHERE Clause - Part 3
Lecture 16 Using the WHERE Clause - Part 4 8:16
Lecture 17 Using the WHERE Clause - Part 5 8:3
Lecture 18 Using the WHERE Clause - Part 6 8:29
Lecture 19 Using the WHERE Clause - Part 7 7:27
Lecture 20 WHERE Clause Practice Problems Pdf

Section 3 : Sorting Data with the ORDER BY Clause

Lecture 21 Sorting with the ORDER BY Clause - Part 1 7:48
Lecture 22 Sorting with the ORDER BY Clause - Part 2 6:23
Lecture 23 ORDER BY Clause Practice Problems Pdf

Section 4 : Querying Multiple Tables with Joins

Lecture 24 Using the INNER JOIN - Part 1 8:15
Lecture 25 Using the INNER JOIN - Part 2
Lecture 26 INNER JOIN Practice Problems Pdf
Lecture 27 Using the LEFT OUTER JOIN - Part 1
Lecture 28 Using the LEFT OUTER JOIN - Part 2 10:25
Lecture 29 Using the LEFT OUTER JOIN - Part 3
Lecture 30 LEFTRIGHT OUTER JOIN Practice Problems Pdf

Section 5 : Aggregate Functions

Lecture 31 Aggregate Functions - Part 1 7:53
Lecture 32 Aggregate Functions - Part 2 4:34
Lecture 33 Aggregate Function Practice Problems Pdf

Section 6 : Grouping Data with the GROUP BY Clause

Lecture 34 Grouping with the GROUP BY Clause - Part 1 6:45
Lecture 35 Grouping with the GROUP BY Clause - Part 2 8:9
Lecture 36 GROUP BY Clause Practice Problems Pdf

Section 7 : Filtering Groups with the HAVING Clause

Lecture 37 Filtering Groups with the HAVING Clause - Part 1 7:17
Lecture 38 Filtering Groups with the HAVING Clause - Part 2 7:10
Lecture 39 HAVING Clause Practice Problems Pdf