|
|
|
|
|
|
Course Title |
|||
|
Transact-SQL Querying - Fast Track |
|||
|
Module Names |
Content Type |
|
Duration (mm:ss:00) |
|
Module 0: Introduction |
|||
|
Lecture |
Full Module |
11:44:00 |
|
|
Before You Begin The Demos |
|||
|
Lecture |
Before You Begin The Demos |
7:42:00 |
|
|
Module 1: Introduction To T-SQL Querying |
|||
|
Lecture |
Intro & Agenda |
1:18:00 |
|
|
Lecture |
Historical Information |
2:55:00 |
|
|
Lecture |
Logical Flow of a SELECT Statement |
4:20:00 |
|
|
Demos |
Demos: Logical Flow of a SELECT Statement |
12:22:00 |
|
|
Lecture |
T-SQL Language Elements |
2:19:00 |
|
|
Lecture |
TOP Clause |
3:15:00 |
|
|
Demos |
Demos: Working with TOP Clause |
9:14:00 |
|
|
Lecture |
Query Optimizer Basics |
8:15:00 |
|
|
Demos |
Demos: Query Optimizer Basics |
14:48:00 |
|
|
Lecture |
TRUE, FALSE & UNKNOWN |
4:40:00 |
|
|
Demos |
Demos: TRUE, FALSE & UNKNOWN |
9:09:00 |
|
|
Lecture |
Summary |
2:03:00 |
|
|
Total Duration |
74:38:00 |
||
|
Module 2: Joins |
|||
|
Lecture |
Intro & Agenda |
4:04:00 |
|
|
Lecture |
Inner Join |
5:33:00 |
|
|
Lecture |
Outer Join (LEFT, RIGHT, FULL) |
6:00:00 |
|
|
Lecture |
Physical Join Types |
2:59:00 |
|
|
Lecture |
Physical Join Types |
5:15:00 |
|
|
Lecture |
Physical Join Types |
4:53:00 |
|
|
Lecture |
APPLY Operator |
1:56:00 |
|
|
Demos |
Demos: Cross Join |
17:38:00 |
|
|
Demos |
Demos: Inner & Outer Join |
17:21:00 |
|
|
Demos |
Demos: APPLY Operator |
14:17:00 |
|
|
Lecture |
Summary |
1:08:00 |
|
|
Total Duration |
81:04:00 |
||
|
Module 3: Set Operators |
|||
|
Lecture |
Intro & Agenda |
10:45:00 |
|
|
Demos |
Demos: SET Operators |
18:02:00 |
|
|
Lecture |
Summary |
0:54:00 |
|
|
Total Duration |
29:41:00 |
||
|
Module 4: Subqueries |
|||
|
Lecture |
Intro & Agenda |
5:38:00 |
|
|
Demos |
Demos: Scalar Subqueries |
15:34:00 |
|
|
|
Demos: Correlated Subqueries |
21:53:00 |
|
|
Lecture |
Summary |
0:59:00 |
|
|
Total Duration |
44:04:00 |
||
|
Module 5: Table Expressions |
|||
|
Lecture |
Intro & Agenda |
4:32:00 |
|
|
Demos |
Demos: Derived Tables & Common Table Expressions |
26:11:00 |
|
|
Lecture |
Summary |
0:47:00 |
|
|
Total Duration |
31:30:00 |
||
|
Module 6: Ranking Functions |
|||
|
Lecture |
Intro & Agenda |
8:29:00 |
|
|
Demos |
Demos: Ranking Functions |
27:01:00 |
|
|
Lecture |
Summary |
1:00:00 |
|
|
Total Duration |
36:30:00 |
||
|
Module 7: Aggregations |
|||
|
Lecture |
Intro & Agenda |
8:30:00 |
|
|
Demos |
Demos: OVER Clause |
12:21:00 |
|
|
Demos |
Demos: CUBE & ROLLUP |
10:27:00 |
|
|
Demos |
Demos: Grouping Sets & Grouping_ID |
10:41:00 |
|
|
Demos |
Demos: Cumulative Aggregations |
20:28:00 |
|
|
Lecture |
Summary |
0:45:00 |
|
|
Total Duration |
63:12:00 |
||
|
Module 8: Pivoting |
|||
|
Lecture |
Intro & Agenda |
3:32:00 |
|
|
Demos |
Demos: Pivoting & Unpivoting |
12:57:00 |
|
|
Lecture |
Summary |
0:59:00 |
|
|
Total Duration |
17:28:00 |
||
|
Module 9: Wrap Up |
|||
|
Lecture |
Full Module |
2:21:00 |
|
|
Total Course Duration (MM:SS:00) |
399:54:00 |
||
|
Total Course Duration (HH:MM:SS) |
6 hrs 40 mins |
||
|
Total Lecture Time |
2 hrs 10 mins |
||
|
Total Demo Time |
4 hrs 30 mins |
||
|
Yeah, demos are the real value ! |
