1. How to Install Microsoft SQL Server Express
2. How to Download and Install SQL Server Express
3. How to Attach the AdventureWorks Database
4. Introduction to T-SQL and Database Concepts
5. Introduction to SELECT STATMENT
a. Literal SELECT Statements – Part 2
b. Literal SELECT Statement Practice Problems
c. Basic SELECT Statements – Part 2
d. Basic SELECT Statements – Part 3
e. Basic SELECT Statement Practice Problems
6. Filter Data with the Where Clause
a. Using the WHERE Clause – Part 1
b. Using the WHERE Clause – Part 2
c. Using the WHERE Clause – Part 4
d. Using the WHERE Clause – Part 5
e. Using the WHERE Clause – Part 6
f. Using the WHERE Clause – Part 7
g. WHERE Clause Practice Problems
7. Sort Data with the ORDER BY Clause
a. Sorting with the ORDER BY Clause – Part 1
b. Sorting with the ORDER BY Clause – Part 2
c. ORDER BY Clause Practice Problems
8. Queries with Multiple TABLES with JOINS
a. Using the INNER JOIN – Part 1
b. Using the INNER JOIN – Part 2
c. INNER JOIN Practice Problems
d. Using the LEFT OUTER JOIN – Part 1
e. Using the LEFT OUTER JOIN – Part 2
f. Using the LEFT OUTER JOIN – Part 3
g. LEFT/RIGHT OUTER JOIN Practice Problems
9. Aggregate Functions
a. Aggregate Functions – Part 1
b. Aggregate Functions – Part 2
c. Aggregate Function Practice Problems
10. Group Data with the GROUP BY CLAUSE
a. Grouping with the GROUP BY Clause – Part 1
b. Grouping with the GROUP BY Clause – Part 2
c. GROUP BY Clause Practice Problems
11. Filtering GROUPS With the HAVING CLAUSE
a. Filtering Groups with the HAVING Clause – Part 1
b. Filtering Groups with the HAVING Clause – Part 2
c. HAVING Clause Practice Problems
