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 |