|
|
1. CTEs - Part 1-en_US.srt
|
SRT
|
13.6 KB
|
|
|
1. CTEs - Part 1.mp4
|
MP4
|
67.6 MB
|
|
|
1. Introducing Window Functions With OVER-en_US.srt
|
SRT
|
11.8 KB
|
|
|
1. Introducing Window Functions With OVER.mp4
|
MP4
|
52.9 MB
|
|
|
1. Introduction-en_US.srt
|
SRT
|
1.8 KB
|
|
|
1. Introduction.mp4
|
MP4
|
4.6 MB
|
|
|
1. Optimizing With UPDATE - Part 1-en_US.srt
|
SRT
|
9.7 KB
|
|
|
1. Optimizing With UPDATE - Part 1.mp4
|
MP4
|
45.3 MB
|
|
|
1. Scalar Subqueries-en_US.srt
|
SRT
|
9.3 KB
|
|
|
1. Scalar Subqueries.mp4
|
MP4
|
47.8 MB
|
|
|
1. Temp Tables - Part 1-en_US.srt
|
SRT
|
13.3 KB
|
|
|
1. Temp Tables - Part 1.mp4
|
MP4
|
55.8 MB
|
|
|
1. Variables - Part 1-en_US.srt
|
SRT
|
12.1 KB
|
|
|
1. Variables - Part 1.mp4
|
MP4
|
57.1 MB
|
|
|
2. CTEs - Part 2-en_US.srt
|
SRT
|
10.3 KB
|
|
|
2. CTEs - Part 2.mp4
|
MP4
|
54.7 MB
|
|
|
2. Correlated Subqueries-en_US.srt
|
SRT
|
13.4 KB
|
|
|
2. Correlated Subqueries.mp4
|
MP4
|
62.5 MB
|
|
|
2. Installing SQL Server 2019 Express-en_US.srt
|
SRT
|
10.2 KB
|
|
|
2. Installing SQL Server 2019 Express.mp4
|
MP4
|
41.9 MB
|
|
|
2. Optimizing With UPDATE - Part 2-en_US.srt
|
SRT
|
10.4 KB
|
|
|
2. Optimizing With UPDATE - Part 2.mp4
|
MP4
|
76.2 MB
|
|
|
2. PARTITION BY-en_US.srt
|
SRT
|
7.1 KB
|
|
|
2. PARTITION BY.mp4
|
MP4
|
37.8 MB
|
|
|
2. Temp Tables - Part 2-en_US.srt
|
SRT
|
6.7 KB
|
|
|
2. Temp Tables - Part 2.mp4
|
MP4
|
23.3 MB
|
|
|
2. Variables - Part 2-en_US.srt
|
SRT
|
8.8 KB
|
|
|
2. Variables - Part 2.mp4
|
MP4
|
52.3 MB
|
|
|
3. An Improved EXISTS With UPDATE-en_US.srt
|
SRT
|
14 KB
|
|
|
3. An Improved EXISTS With UPDATE.mp4
|
MP4
|
68.2 MB
|
|
|
3. CREATE and INSERT-en_US.srt
|
SRT
|
17.1 KB
|
|
|
3. CREATE and INSERT.mp4
|
MP4
|
76.6 MB
|
|
|
3. EXISTS-en_US.srt
|
SRT
|
17.4 KB
|
|
|
3. EXISTS.mp4
|
MP4
|
95.8 MB
|
|
|
3. Installing SQL Server Management Studio-en_US.srt
|
SRT
|
5.4 KB
|
|
|
3. Installing SQL Server Management Studio.mp4
|
MP4
|
25.1 MB
|
|
|
3. Introducing User Defined Functions-en_US.srt
|
SRT
|
10.7 KB
|
|
|
3. Introducing User Defined Functions.mp4
|
MP4
|
38.5 MB
|
|
|
3. ROW_NUMBER-en_US.srt
|
SRT
|
12 KB
|
|
|
3. ROW_NUMBER.mp4
|
MP4
|
61.2 MB
|
|
|
3. Recursive CTEs-en_US.srt
|
SRT
|
17.5 KB
|
|
|
3. Recursive CTEs.mp4
|
MP4
|
57.9 MB
|
|
|
4. Downloading the AdventureWorks Sample Database-en_US.srt
|
SRT
|
9.5 KB
|
|
|
4. Downloading the AdventureWorks Sample Database.mp4
|
MP4
|
45.9 MB
|
|
|
4. FOR XML PATH With STUFF-en_US.srt
|
SRT
|
18.7 KB
|
|
|
4. FOR XML PATH With STUFF.mp4
|
MP4
|
79.5 MB
|
|
|
4. Introducing Indexes-en_US.srt
|
SRT
|
11.8 KB
|
|
|
4. Introducing Indexes.mp4
|
MP4
|
47.4 MB
|
|
|
4. Making Functions Flexible With Parameters-en_US.srt
|
SRT
|
14 KB
|
|
|
4. Making Functions Flexible With Parameters.mp4
|
MP4
|
68.1 MB
|
|
|
4. RANK and DENSE_RANK-en_US.srt
|
SRT
|
8.6 KB
|
|
|
4. RANK and DENSE_RANK.mp4
|
MP4
|
47.2 MB
|
|
|
4. TRUNCATE - Part 1-en_US.srt
|
SRT
|
11.5 KB
|
|
|
4. TRUNCATE - Part 1.mp4
|
MP4
|
54.8 MB
|
|
|
5. Course Environment Walkthrough-en_US.srt
|
SRT
|
12.6 KB
|
|
|
5. Course Environment Walkthrough.mp4
|
MP4
|
78.7 MB
|
|
|
5. LEAD and LAG-en_US.srt
|
SRT
|
17.3 KB
|
|
|
5. LEAD and LAG.mp4
|
MP4
|
111 MB
|
|
|
5. Optimizing With Indexes - Example-en_US.srt
|
SRT
|
12.7 KB
|
|
|
5. Optimizing With Indexes - Example.mp4
|
MP4
|
69.9 MB
|
|
|
5. PIVOT - Part 1-en_US.srt
|
SRT
|
12.9 KB
|
|
|
5. PIVOT - Part 1.mp4
|
MP4
|
54.5 MB
|
|
|
5. Stored Procedures-en_US.srt
|
SRT
|
14.4 KB
|
|
|
5. Stored Procedures.mp4
|
MP4
|
63.3 MB
|
|
|
5. TRUNCATE - Part 2-en_US.srt
|
SRT
|
10.1 KB
|
|
|
5. TRUNCATE - Part 2.mp4
|
MP4
|
49.2 MB
|
|
|
6. Control Flow With IF Statements-en_US.srt
|
SRT
|
14 KB
|
|
|
6. Control Flow With IF Statements.mp4
|
MP4
|
63.6 MB
|
|
|
6. Introducing Subqueries-en_US.srt
|
SRT
|
8.9 KB
|
|
|
6. Introducing Subqueries.mp4
|
MP4
|
30.8 MB
|
|
|
6. Lookup Tables - Part 1-en_US.srt
|
SRT
|
16.8 KB
|
|
|
6. Lookup Tables - Part 1.mp4
|
MP4
|
57.4 MB
|
|
|
6. PIVOT - Part 2-en_US.srt
|
SRT
|
10.4 KB
|
|
|
6. PIVOT - Part 2.mp4
|
MP4
|
52.8 MB
|
|
|
6. UPDATE - Part 1-en_US.srt
|
SRT
|
10.6 KB
|
|
|
6. UPDATE - Part 1.mp4
|
MP4
|
67 MB
|
|
|
7. Lookup Tables - Part 2-en_US.srt
|
SRT
|
10 KB
|
|
|
7. Lookup Tables - Part 2.mp4
|
MP4
|
61.9 MB
|
|
|
7. UPDATE - Part 2-en_US.srt
|
SRT
|
10.1 KB
|
|
|
7. UPDATE - Part 2.mp4
|
MP4
|
68.5 MB
|
|
|
7. Using Multiple IF Statements-en_US.srt
|
SRT
|
9.3 KB
|
|
|
7. Using Multiple IF Statements.mp4
|
MP4
|
57.9 MB
|
|
|
8. DELETE-en_US.srt
|
SRT
|
6 KB
|
|
|
8. DELETE.mp4
|
MP4
|
21 MB
|
|
|
8. Dynamic SQL - Part 1-en_US.srt
|
SRT
|
11.7 KB
|
|
|
8. Dynamic SQL - Part 1.mp4
|
MP4
|
53.6 MB
|
|
|
9. Dynamic SQL - Part 2-en_US.srt
|
SRT
|
17 KB
|
|
|
9. Dynamic SQL - Part 2.mp4
|
MP4
|
91.8 MB
|
|
|
An Improved EXISTS With UPDATE - Exercise.html
|
HTML
|
512 B
|
|
|
An-Improved-EXISTS-With-UPDATE-Example-Code.sql
|
SQL
|
1.2 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
CREATE and INSERT - Exercise.html
|
HTML
|
102.4 B
|
|
|
CREATE-and-INSERT-Example-Code.sql
|
SQL
|
1 KB
|
|
|
CTEs - Exercise.html
|
HTML
|
716.8 B
|
|
|
CTEs-Example-Code.sql
|
SQL
|
1.6 KB
|
|
|
Control Flow With IF Statements - Exercise.html
|
HTML
|
512 B
|
|
|
Control-Flow-With-IF-Statements-Example-Code.sql
|
SQL
|
1.3 KB
|
|
|
Correlated Subqueries - Exercises.html
|
HTML
|
1.1 KB
|
|
|
Correlated-Subqueries-Example-Code.sql
|
SQL
|
409.6 B
|
|
|
DELETE-Example-Code.sql
|
SQL
|
1.2 KB
|
|
|
Dynamic SQL - Exercises.html
|
HTML
|
2.1 KB
|
|
|
Dynamic-SQL-Part-1-Example-Code.sql
|
SQL
|
204.8 B
|
|
|
Dynamic-SQL-Part-2-Example-Code.sql
|
SQL
|
819.2 B
|
|
|
EXISTS - Exercises.html
|
HTML
|
1.5 KB
|
|
|
EXISTS-Example-Code.sql
|
SQL
|
1.9 KB
|
|
|
FOR XML PATH With STUFF - Exercises.html
|
HTML
|
1 KB
|
|
|
FOR-XML-PATH-With-STUFF-Example-Code.sql
|
SQL
|
1.4 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Indexes-Example-Code.sql
|
SQL
|
2.2 KB
|
|
|
Indexes.pdf
|
PDF
|
177.8 KB
|
|
|
Introducing Subqueries - Exercises.html
|
HTML
|
1.8 KB
|
|
|
Introducing Window Functions With OVER - Exercises.html
|
HTML
|
1.5 KB
|
|
|
Introducing-User-Defined-Functions-Example-Code.sql
|
SQL
|
409.6 B
|
|
|
LEAD and LAG - Exercises.html
|
HTML
|
2 KB
|
|
|
LEAD-and-LAG-Example-Code.sql
|
SQL
|
1 KB
|
|
|
Lookup Tables - Exercises.html
|
HTML
|
614.4 B
|
|
|
Lookup-Tables-Part-One-Example-Code.sql
|
SQL
|
1.1 KB
|
|
|
Lookup-Tables-Part-Two-Example-Code.sql
|
SQL
|
921.6 B
|
|
|
OVER-Example-Code.sql
|
SQL
|
512 B
|
|
|
Optimizing With Indexes - Exercise.html
|
HTML
|
307.2 B
|
|
|
Optimizing With UPDATE - Exercise.html
|
HTML
|
307.2 B
|
|
|
Optimizing-With-UPDATE-Example-Code.sql
|
SQL
|
2.4 KB
|
|
|
PARTITION BY - Exercises.html
|
HTML
|
1.7 KB
|
|
|
PARTITION-BY-Example-Code.sql
|
SQL
|
614.4 B
|
|
|
PIVOT - Exercises.html
|
HTML
|
819.2 B
|
|
|
PIVOT-Part-1-Example-Code.sql
|
SQL
|
614.4 B
|
|
|
PIVOT-Part-2-Example-Code.sql
|
SQL
|
614.4 B
|
|
|
RANK and DENSE_RANK - Exercises.html
|
HTML
|
1.3 KB
|
|
|
RANK-and-DENSE-RANK-Example-Code.sql
|
SQL
|
409.6 B
|
|
|
ROW-NUMBER-Example-Code.sql
|
SQL
|
614.4 B
|
|
|
ROW-NUMBER.mp4
|
MP4
|
26.2 MB
|
|
|
ROW_NUMBER - Exercises.html
|
HTML
|
2.1 KB
|
|
|
Recursive CTEs - Exercises.html
|
HTML
|
716.8 B
|
|
|
Recursive-CTEs-Example-Code.sql
|
SQL
|
512 B
|
|
|
Scalar Subqueries - Exercises.html
|
HTML
|
1.5 KB
|
|
|
Scalar-Subqueries-Example-Code.sql
|
SQL
|
716.8 B
|
|
|
Stored Procedures - Exercise.html
|
HTML
|
512 B
|
|
|
Stored-Procedures-Example-Code.sql
|
SQL
|
1.5 KB
|
|
|
Subqueries-Example-Code.sql
|
SQL
|
307.2 B
|
|
|
TRUNCATE - Exercise.html
|
HTML
|
1.3 KB
|
|
|
TRUNCATE-Example-Code.sql
|
SQL
|
1.7 KB
|
|
|
Temp Tables - Exercises.html
|
HTML
|
204.8 B
|
|
|
Temp-Tables-Example-Code.sql
|
SQL
|
716.8 B
|
|
|
UPDATE - Exercise.html
|
HTML
|
819.2 B
|
|
|
Update-Example-Code.sql
|
SQL
|
1.1 KB
|
|
|
User Defined Functions - Exercises.html
|
HTML
|
1.6 KB
|
|
|
User-Defined-Functions-With-Parameters-Example-Code.sql
|
SQL
|
1 KB
|
|
|
Using Multiple IF Statements - Exercise.html
|
HTML
|
921.6 B
|
|
|
Using-Multiple-IF-Statements-Example-Code.sql
|
SQL
|
1.8 KB
|
|
|
Variables - Exercise 1.html
|
HTML
|
204.8 B
|
|
|
Variables - Exercise 2.html
|
HTML
|
819.2 B
|
|
|
Variables-Part-1-Example-Code.sql
|
SQL
|
819.2 B
|
|
|
Variables-Part-2-Example-Code.sql
|
SQL
|
409.6 B
|
![[ FreeCourseWeb ] Udemy - The Advanced SQL Server Masterclass For Data Analysis](/static/img/no-torrent-image.png "[ FreeCourseWeb ] Udemy - The Advanced SQL Server Masterclass For Data Analysis")
