Section 1 : Introduction to SELECT Statements

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

Section 2 : Filtering Data with the WHERE Clause

Lecture 1 Using the WHERE Clause - Part 1 00:05:33 Duration
Lecture 2 Using the WHERE Clause - Part 2 00:05:11 Duration
Lecture 3 Using the WHERE Clause - Part 3
Lecture 4 Using the WHERE Clause - Part 4 00:08:16 Duration
Lecture 5 Using the WHERE Clause - Part 5 00:08:03 Duration
Lecture 6 Using the WHERE Clause - Part 6 00:08:29 Duration
Lecture 7 Using the WHERE Clause - Part 7 00:07:27 Duration
Lecture 8 WHERE Clause Practice Problems

Section 3 : Sorting Data with the ORDER BY Clause

Lecture 1 Sorting with the ORDER BY Clause - Part 1 00:07:48 Duration
Lecture 2 Sorting with the ORDER BY Clause - Part 2 00:06:23 Duration
Lecture 3 ORDER BY Clause Practice Problems

Section 4 : Querying Multiple Tables with Joins

Lecture 1 Using the INNER JOIN - Part 1 00:08:15 Duration
Lecture 2 Using the INNER JOIN - Part 2
Lecture 3 INNER JOIN Practice Problems
Lecture 4 Using the LEFT OUTER JOIN - Part 1
Lecture 5 Using the LEFT OUTER JOIN - Part 2 00:10:25 Duration
Lecture 6 Using the LEFT OUTER JOIN - Part 3
Lecture 7 LEFTRIGHT OUTER JOIN Practice Problems

Section 5 : Aggregate Functions

Lecture 1 Aggregate Functions - Part 1 00:07:53 Duration
Lecture 2 Aggregate Functions - Part 2 00:04:34 Duration
Lecture 3 Aggregate Function Practice Problems

Section 6 : Grouping Data with the GROUP BY Clause

Lecture 1 Grouping with the GROUP BY Clause - Part 1 00:06:45 Duration
Lecture 2 Grouping with the GROUP BY Clause - Part 2 00:08:09 Duration
Lecture 3 GROUP BY Clause Practice Problems

Section 7 : Filtering Groups with the HAVING Clause

Lecture 1 Filtering Groups with the HAVING Clause - Part 1 00:07:17 Duration
Lecture 2 Filtering Groups with the HAVING Clause - Part 2 00:07:10 Duration
Lecture 3 HAVING Clause Practice Problems