|
|
1. Introduction to Aggregate functions.mp4
|
MP4
|
52.8 MB
|
|
|
1. Introduction to Aggregate functions.srt
|
SRT
|
7.8 KB
|
|
|
1. Introduction to basic database concepts.mp4
|
MP4
|
65.3 MB
|
|
|
1. Introduction to basic database concepts.srt
|
SRT
|
11.1 KB
|
|
|
1. Introduction to table joining.mp4
|
MP4
|
82.7 MB
|
|
|
1. Introduction to table joining.srt
|
SRT
|
12.3 KB
|
|
|
1. Introduction to the GROUP BY clause.mp4
|
MP4
|
46 MB
|
|
|
1. Introduction to the GROUP BY clause.srt
|
SRT
|
6.9 KB
|
|
|
1. Introduction to the HAVING clause.mp4
|
MP4
|
36.5 MB
|
|
|
1. Introduction to the HAVING clause.srt
|
SRT
|
5.7 KB
|
|
|
1. Introduction to the ORDER BY clause.mp4
|
MP4
|
29 MB
|
|
|
1. Introduction to the ORDER BY clause.srt
|
SRT
|
4.5 KB
|
|
|
1. Introduction to the SELECT statement.mp4
|
MP4
|
21.3 MB
|
|
|
1. Introduction to the SELECT statement.srt
|
SRT
|
3.4 KB
|
|
|
1. Introduction to the WHERE clause.mp4
|
MP4
|
248.1 MB
|
|
|
1. Introduction to the WHERE clause.srt
|
SRT
|
31.8 KB
|
|
|
1.1 01 - DB and SQL.pdf
|
PDF
|
15.7 MB
|
|
|
1.1 02 - SELECT statments.pdf
|
PDF
|
15.7 MB
|
|
|
1.1 03 - The WHERE clause.pdf
|
PDF
|
15.8 MB
|
|
|
1.1 04 - Aggregate functions.pdf
|
PDF
|
7.8 MB
|
|
|
1.1 05 - Group By.pdf
|
PDF
|
15.7 MB
|
|
|
1.1 06 - The HAVING clause.pdf
|
PDF
|
15.8 MB
|
|
|
1.1 07 - The ORDER BY clause.pdf
|
PDF
|
15.8 MB
|
|
|
1.1 08 - Introduction to joins.pdf
|
PDF
|
15.8 MB
|
|
|
2. Aggregate functions - MAX().mp4
|
MP4
|
37.8 MB
|
|
|
2. Aggregate functions - MAX().srt
|
SRT
|
7.1 KB
|
|
|
2. Basic SELECT statements Part 1.mp4
|
MP4
|
41.8 MB
|
|
|
2. Basic SELECT statements Part 1.srt
|
SRT
|
9.8 KB
|
|
|
2. Download & Install - SQL Express 2019.mp4
|
MP4
|
32.9 MB
|
|
|
2. Download & Install - SQL Express 2019.srt
|
SRT
|
6.4 KB
|
|
|
2. Using the GROUP BY clause.mp4
|
MP4
|
61.3 MB
|
|
|
2. Using the GROUP BY clause.srt
|
SRT
|
8.9 KB
|
|
|
2. Using the HAVING clause.mp4
|
MP4
|
64.3 MB
|
|
|
2. Using the HAVING clause.srt
|
SRT
|
9.3 KB
|
|
|
2. Using the ORDER BY clause.mp4
|
MP4
|
80.9 MB
|
|
|
2. Using the ORDER BY clause.srt
|
SRT
|
14.4 KB
|
|
|
2. WHERE clause - comparison operators - Part 1.mp4
|
MP4
|
61.5 MB
|
|
|
2. WHERE clause - comparison operators - Part 1.srt
|
SRT
|
7.6 KB
|
|
|
2. the JOIN syntax and table aliases.mp4
|
MP4
|
70.6 MB
|
|
|
2. the JOIN syntax and table aliases.srt
|
SRT
|
9.7 KB
|
|
|
2.1 08 - Joins - Syntax and aliases.pdf
|
PDF
|
15.8 MB
|
|
|
3. Aggregate functions - MIN().mp4
|
MP4
|
36.8 MB
|
|
|
3. Aggregate functions - MIN().srt
|
SRT
|
6 KB
|
|
|
3. Assignments - GROUP BY.html
|
HTML
|
204.8 B
|
|
|
3. Assignments - the HAVING Clause.html
|
HTML
|
204.8 B
|
|
|
3. Assignments - the ORDER BY Clause.html
|
HTML
|
204.8 B
|
|
|
3. Basic SELECT statements Part 2.mp4
|
MP4
|
78.5 MB
|
|
|
3. Basic SELECT statements Part 2.srt
|
SRT
|
8.9 KB
|
|
|
3. Download& Install - SSMS.mp4
|
MP4
|
31.3 MB
|
|
|
3. Download& Install - SSMS.srt
|
SRT
|
5.3 KB
|
|
|
3. INNER JOIN.mp4
|
MP4
|
54.4 MB
|
|
|
3. INNER JOIN.srt
|
SRT
|
7.5 KB
|
|
|
3. WHERE clause - comparison operators - Part 2.mp4
|
MP4
|
95.7 MB
|
|
|
3. WHERE clause - comparison operators - Part 2.srt
|
SRT
|
10.1 KB
|
|
|
4. Aggregate functions - COUNT().mp4
|
MP4
|
61.2 MB
|
|
|
4. Aggregate functions - COUNT().srt
|
SRT
|
8.9 KB
|
|
|
4. Basic SELECT statements Part 3.mp4
|
MP4
|
21.1 MB
|
|
|
4. Basic SELECT statements Part 3.srt
|
SRT
|
10.4 KB
|
|
|
4. Download & install - AdventureWorks2019.mp4
|
MP4
|
51.1 MB
|
|
|
4. Download & install - AdventureWorks2019.srt
|
SRT
|
7.3 KB
|
|
|
4. FULL (OUTER) JOIN.mp4
|
MP4
|
73.5 MB
|
|
|
4. FULL (OUTER) JOIN.srt
|
SRT
|
7.6 KB
|
|
|
4. WHERE clause - logical operators.mp4
|
MP4
|
86.8 MB
|
|
|
4. WHERE clause - logical operators.srt
|
SRT
|
9.9 KB
|
|
|
5. Aggregate functions - SUM().mp4
|
MP4
|
54.4 MB
|
|
|
5. Aggregate functions - SUM().srt
|
SRT
|
6.9 KB
|
|
|
5. Basic SELECT statements Part 4.mp4
|
MP4
|
48.8 MB
|
|
|
5. Basic SELECT statements Part 4.srt
|
SRT
|
5.9 KB
|
|
|
5. Basic database concepts.mp4
|
MP4
|
57.4 MB
|
|
|
5. Basic database concepts.srt
|
SRT
|
8.6 KB
|
|
|
5. LEFT (OUTER) JOIN.mp4
|
MP4
|
61.1 MB
|
|
|
5. LEFT (OUTER) JOIN.srt
|
SRT
|
7.1 KB
|
|
|
5. WHERE clause - the IN operator.mp4
|
MP4
|
38.9 MB
|
|
|
5. WHERE clause - the IN operator.srt
|
SRT
|
4.9 KB
|
|
|
5.1 01 - Basic Database Concepts.pdf
|
PDF
|
16.2 MB
|
|
|
6. Aggregate functions - AVG().mp4
|
MP4
|
50.1 MB
|
|
|
6. Aggregate functions - AVG().srt
|
SRT
|
7.8 KB
|
|
|
6. Assignments - SELECT statements.html
|
HTML
|
204.8 B
|
|
|
6. RIGHT (OUTER) JOIN.mp4
|
MP4
|
46.6 MB
|
|
|
6. RIGHT (OUTER) JOIN.srt
|
SRT
|
4.6 KB
|
|
|
6. WHERE clause - the BETWEEN operator.mp4
|
MP4
|
47.2 MB
|
|
|
6. WHERE clause - the BETWEEN operator.srt
|
SRT
|
5 KB
|
|
|
7. Assignments - Aggregate Functions.html
|
HTML
|
204.8 B
|
|
|
7. Introduction to CROSS JOIN.mp4
|
MP4
|
25.4 MB
|
|
|
7. Introduction to CROSS JOIN.srt
|
SRT
|
3.5 KB
|
|
|
7. WHERE clause - the LIKE operator.mp4
|
MP4
|
58 MB
|
|
|
7. WHERE clause - the LIKE operator.srt
|
SRT
|
8.8 KB
|
|
|
7.1 Presentation - 08 - Joins - Cross Joins.pdf
|
PDF
|
832.6 KB
|
|
|
8. CROSS JOIN.mp4
|
MP4
|
57.4 MB
|
|
|
8. CROSS JOIN.srt
|
SRT
|
6.2 KB
|
|
|
8. WHERE clause - the IS NULL operator.mp4
|
MP4
|
30.9 MB
|
|
|
8. WHERE clause - the IS NULL operator.srt
|
SRT
|
3.1 KB
|
|
|
9. Assignments - How to JOIN Tables.html
|
HTML
|
204.8 B
|
|
|
9. Assignments - the WHERE clause.html
|
HTML
|
204.8 B
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
