|
|
1. Course Introdution.mp4
|
MP4
|
18.4 MB
|
|
|
1. Course Introdution.srt
|
SRT
|
4.5 KB
|
|
|
1. Download and Install SQL Server Express.mp4
|
MP4
|
32.1 MB
|
|
|
1. Download and Install SQL Server Express.srt
|
SRT
|
6.2 KB
|
|
|
1. SELECT clause - Introduction and Demonstration.mp4
|
MP4
|
34.7 MB
|
|
|
1. SELECT clause - Introduction and Demonstration.srt
|
SRT
|
9.2 KB
|
|
|
1. SELECT course final summary.mp4
|
MP4
|
21.3 MB
|
|
|
1. SELECT course final summary.srt
|
SRT
|
9.2 KB
|
|
|
1. SSMS Layout and Connecting to a Database.mp4
|
MP4
|
26.3 MB
|
|
|
1. SSMS Layout and Connecting to a Database.srt
|
SRT
|
11.1 KB
|
|
|
1.1 01 - the SELECT clause.sql
|
SQL
|
2.6 KB
|
|
|
1.1 SQL Clause overview.pdf
|
PDF
|
171.6 KB
|
|
|
1.1 SQL Server Management Studio Overview 15.0.18384.pdf
|
PDF
|
1.2 MB
|
|
|
10. WHERE Clause - Part 2 - LIKE operator - Demonstration.mp4
|
MP4
|
21.2 MB
|
|
|
10. WHERE Clause - Part 2 - LIKE operator - Demonstration.srt
|
SRT
|
3.2 KB
|
|
|
10.1 05 - the WHERE clause part 2.sql
|
SQL
|
2.6 KB
|
|
|
11. A note about NULLs.mp4
|
MP4
|
27.3 MB
|
|
|
11. A note about NULLs.srt
|
SRT
|
6.4 KB
|
|
|
11.1 06 - a note about NULLs.sql
|
SQL
|
2.3 KB
|
|
|
11.2 NULL values.pdf
|
PDF
|
39.3 KB
|
|
|
12. WHERE Clause - Part 3 - Combining clauses - Demonstration.mp4
|
MP4
|
35.7 MB
|
|
|
12. WHERE Clause - Part 3 - Combining clauses - Demonstration.srt
|
SRT
|
8.4 KB
|
|
|
12.1 07 - the WHERE clause part 3.sql
|
SQL
|
2.9 KB
|
|
|
13. WHERE Clause - Test Answers.mp4
|
MP4
|
51.6 MB
|
|
|
13. WHERE Clause - Test Answers.srt
|
SRT
|
8 KB
|
|
|
13.1 07 - the WHERE clause part 3 test.sql
|
SQL
|
3 KB
|
|
|
14. ORDER BY Clause - Introduction.mp4
|
MP4
|
8 MB
|
|
|
14. ORDER BY Clause - Introduction.srt
|
SRT
|
4.6 KB
|
|
|
15. ORDER BY Clause - Demonstration.mp4
|
MP4
|
32 MB
|
|
|
15. ORDER BY Clause - Demonstration.srt
|
SRT
|
4.5 KB
|
|
|
15.1 08 - the ORDER BY clause.sql
|
SQL
|
3.8 KB
|
|
|
16. ORDER BY Clause - Test Answers.mp4
|
MP4
|
35.3 MB
|
|
|
16. ORDER BY Clause - Test Answers.srt
|
SRT
|
5.7 KB
|
|
|
16.1 08 - the ORDER BY clause test.sql
|
SQL
|
2.6 KB
|
|
|
17. JOIN Clause - Part 1 - Introduction.mp4
|
MP4
|
31.4 MB
|
|
|
17. JOIN Clause - Part 1 - Introduction.srt
|
SRT
|
9.9 KB
|
|
|
17.1 Table JOINs.pdf
|
PDF
|
235.1 KB
|
|
|
18. JOIN Clause - Part 1 - Demonstration.mp4
|
MP4
|
43.5 MB
|
|
|
18. JOIN Clause - Part 1 - Demonstration.srt
|
SRT
|
8.6 KB
|
|
|
18.1 09 - table JOINS part 1.sql
|
SQL
|
3.3 KB
|
|
|
19. JOIN Clause - Part 1 - Test Answers.mp4
|
MP4
|
39 MB
|
|
|
19. JOIN Clause - Part 1 - Test Answers.srt
|
SRT
|
6.2 KB
|
|
|
19.1 09 - table JOINS part 1 test.sql
|
SQL
|
2.8 KB
|
|
|
19.2 Table Joins part 1 test - table relationships.pdf
|
PDF
|
10 KB
|
|
|
2. Download and Install SQL Server Management Studio (SSMS).mp4
|
MP4
|
33.2 MB
|
|
|
2. Download and Install SQL Server Management Studio (SSMS).srt
|
SRT
|
6.4 KB
|
|
|
2. FROM clause - Introduction.mp4
|
MP4
|
4.4 MB
|
|
|
2. FROM clause - Introduction.srt
|
SRT
|
2.5 KB
|
|
|
2. SELECT course final test answers.mp4
|
MP4
|
156.1 MB
|
|
|
2. SELECT course final test answers.srt
|
SRT
|
23 KB
|
|
|
2. Tree view, Menus and Editing code.mp4
|
MP4
|
22.2 MB
|
|
|
2. Tree view, Menus and Editing code.srt
|
SRT
|
8.8 KB
|
|
|
2.1 15 - Final Test.sql
|
SQL
|
4.8 KB
|
|
|
2.2 final test - table relationships.pdf
|
PDF
|
17.2 KB
|
|
|
20. JOIN Clause - Part 2 - Joining multiple tables - Introduction.mp4
|
MP4
|
21.6 MB
|
|
|
20. JOIN Clause - Part 2 - Joining multiple tables - Introduction.srt
|
SRT
|
7.4 KB
|
|
|
21. JOIN Clause - Part 2 - Joining multiple tables - Demonstration.mp4
|
MP4
|
19.3 MB
|
|
|
21. JOIN Clause - Part 2 - Joining multiple tables - Demonstration.srt
|
SRT
|
3.2 KB
|
|
|
21.1 10 - table JOINS part 2.sql
|
SQL
|
1.7 KB
|
|
|
22. JOIN Clause - Part 2 - Joining multiple tables - Test Answers.mp4
|
MP4
|
56.3 MB
|
|
|
22. JOIN Clause - Part 2 - Joining multiple tables - Test Answers.srt
|
SRT
|
6.7 KB
|
|
|
22.1 10 - table JOINS part 2 test.sql
|
SQL
|
5.1 KB
|
|
|
22.2 Table Joins part 2 test - table relationships.pdf
|
PDF
|
12.8 KB
|
|
|
23. Aggregates and Grouping - Introduction.mp4
|
MP4
|
7.5 MB
|
|
|
23. Aggregates and Grouping - Introduction.srt
|
SRT
|
2.9 KB
|
|
|
24. Aggregate Functions - Demonstration.mp4
|
MP4
|
18.5 MB
|
|
|
24. Aggregate Functions - Demonstration.srt
|
SRT
|
3.3 KB
|
|
|
24.1 11 - Agregate functions.sql
|
SQL
|
2.7 KB
|
|
|
24.2 Aggregate functions-.pdf
|
PDF
|
169.8 KB
|
|
|
25. GROUP BY Clause - Introduction.mp4
|
MP4
|
7.7 MB
|
|
|
25. GROUP BY Clause - Introduction.srt
|
SRT
|
1.7 KB
|
|
|
26. GROUP BY Clause - Demonstration.mp4
|
MP4
|
20.1 MB
|
|
|
26. GROUP BY Clause - Demonstration.srt
|
SRT
|
4.4 KB
|
|
|
26.1 12 - the GROUP BY clause.sql
|
SQL
|
1.9 KB
|
|
|
27. GROUP BY Clause - Test Answers.mp4
|
MP4
|
71.9 MB
|
|
|
27. GROUP BY Clause - Test Answers.srt
|
SRT
|
9.3 KB
|
|
|
27.1 12 - the GROUP BY clause test.sql
|
SQL
|
3.2 KB
|
|
|
27.2 GROUP BY clause test - table relationships.pdf
|
PDF
|
10.4 KB
|
|
|
28. HAVING Clause - Introduction.mp4
|
MP4
|
6.4 MB
|
|
|
28. HAVING Clause - Introduction.srt
|
SRT
|
2.5 KB
|
|
|
29. HAVING Clause - Demonstration.mp4
|
MP4
|
19.5 MB
|
|
|
29. HAVING Clause - Demonstration.srt
|
SRT
|
3.7 KB
|
|
|
29.1 13 - the HAVING clause.sql
|
SQL
|
1.7 KB
|
|
|
3. AdventureWorks Database - Introduction.mp4
|
MP4
|
18.1 MB
|
|
|
3. AdventureWorks Database - Introduction.srt
|
SRT
|
3.5 KB
|
|
|
3. Course Outro.mp4
|
MP4
|
1.4 MB
|
|
|
3. Course Outro.srt
|
SRT
|
921.6 B
|
|
|
3. FROM clause - Demonstration.mp4
|
MP4
|
64 MB
|
|
|
3. FROM clause - Demonstration.srt
|
SRT
|
11.2 KB
|
|
|
3.1 02 - the FROM clause.sql
|
SQL
|
3.3 KB
|
|
|
3.1 AdventureWorks2016 data dictionary.pdf
|
PDF
|
600.1 KB
|
|
|
30. HAVING Clause - Test Answers.mp4
|
MP4
|
30.6 MB
|
|
|
30. HAVING Clause - Test Answers.srt
|
SRT
|
4.5 KB
|
|
|
30.1 13 - the HAVING clause test.sql
|
SQL
|
2.4 KB
|
|
|
30.2 HAVING clause test - table relationships.pdf
|
PDF
|
10.1 KB
|
|
|
4. FROM Clause - Test Answers.mp4
|
MP4
|
77.4 MB
|
|
|
4. FROM Clause - Test Answers.srt
|
SRT
|
8.5 KB
|
|
|
4. Option 1 - Install AdventureWorks from a backup.mp4
|
MP4
|
81.7 MB
|
|
|
4. Option 1 - Install AdventureWorks from a backup.srt
|
SRT
|
11.7 KB
|
|
|
4.1 02 - the FROM clause test.sql
|
SQL
|
3.1 KB
|
|
|
5. A note about Data Types.mp4
|
MP4
|
24.8 MB
|
|
|
5. A note about Data Types.srt
|
SRT
|
11.4 KB
|
|
|
5. Option 2 - Install AdventureWorks from a script file.mp4
|
MP4
|
19.7 MB
|
|
|
5. Option 2 - Install AdventureWorks from a script file.srt
|
SRT
|
3 KB
|
|
|
5.1 00 - create database and tables V1.sql
|
SQL
|
42.1 MB
|
|
|
5.1 SQL server basic data types.pdf
|
PDF
|
303 KB
|
|
|
6. WHERE Clause - Part 1 - Introduction.mp4
|
MP4
|
15.5 MB
|
|
|
6. WHERE Clause - Part 1 - Introduction.srt
|
SRT
|
3.4 KB
|
|
|
6.1 WHERE clause operators.pdf
|
PDF
|
61.3 KB
|
|
|
7. WHERE Clause - Part 1 - Demonstration.mp4
|
MP4
|
57.8 MB
|
|
|
7. WHERE Clause - Part 1 - Demonstration.srt
|
SRT
|
8.7 KB
|
|
|
7.1 03 - the WHERE clause part 1.sql
|
SQL
|
3.3 KB
|
|
|
8. A Note about Dates.mp4
|
MP4
|
37.7 MB
|
|
|
8. A Note about Dates.srt
|
SRT
|
10 KB
|
|
|
8.1 04 - a note about DATES.sql
|
SQL
|
2.8 KB
|
|
|
8.2 DATES datatype.pdf
|
PDF
|
104.7 KB
|
|
|
9. WHERE Clause - Part 2 - LIKE operator - Introduction.mp4
|
MP4
|
15.7 MB
|
|
|
9. WHERE Clause - Part 2 - LIKE operator - Introduction.srt
|
SRT
|
8.1 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
