|
|
1. AND Operator.mp4
|
MP4
|
9.6 MB
|
|
|
1. AND Operator.srt
|
SRT
|
3.5 KB
|
|
|
1. INNER JOIN.mp4
|
MP4
|
28.5 MB
|
|
|
1. INNER JOIN.srt
|
SRT
|
5.7 KB
|
|
|
1. Introduction to Aggregate Functions.mp4
|
MP4
|
22.1 MB
|
|
|
1. Introduction to Aggregate Functions.srt
|
SRT
|
6.7 KB
|
|
|
1. Understanding the Foundations of SQL.mp4
|
MP4
|
23.5 MB
|
|
|
1. Understanding the Foundations of SQL.srt
|
SRT
|
9.2 KB
|
|
|
1. Welcome to the Course!.mp4
|
MP4
|
12.4 MB
|
|
|
1. Welcome to the Course!.srt
|
SRT
|
2.3 KB
|
|
|
10. Row Ordering - ORDER BY.mp4
|
MP4
|
23.8 MB
|
|
|
10. Row Ordering - ORDER BY.srt
|
SRT
|
10.1 KB
|
|
|
11. LIMIT Clause.mp4
|
MP4
|
17.8 MB
|
|
|
11. LIMIT Clause.srt
|
SRT
|
5.1 KB
|
|
|
12. ORDER BY Challenges.mp4
|
MP4
|
7.5 MB
|
|
|
12. ORDER BY Challenges.srt
|
SRT
|
2.3 KB
|
|
|
12.1 ORDER BY Challenges - including hints.pdf
|
PDF
|
163.9 KB
|
|
|
12.2 ORDER BY Challenges - without hints.pdf
|
PDF
|
161.6 KB
|
|
|
13. Solutions to the ORDER BY Challenges.mp4
|
MP4
|
43.6 MB
|
|
|
13. Solutions to the ORDER BY Challenges.srt
|
SRT
|
6.5 KB
|
|
|
13.1 Solutions to the ORDER BY Challenges.sql
|
SQL
|
1.1 KB
|
|
|
14. WHERE Clause - Three-valued Logic.mp4
|
MP4
|
17.7 MB
|
|
|
14. WHERE Clause - Three-valued Logic.srt
|
SRT
|
5.6 KB
|
|
|
15. Replacing Nulls in Queries.mp4
|
MP4
|
26.7 MB
|
|
|
15. Replacing Nulls in Queries.srt
|
SRT
|
6.6 KB
|
|
|
16. WHERE Clause - Comparison Operators.mp4
|
MP4
|
13.8 MB
|
|
|
16. WHERE Clause - Comparison Operators.srt
|
SRT
|
5 KB
|
|
|
17. WHERE Clause Challenges.mp4
|
MP4
|
8.9 MB
|
|
|
17. WHERE Clause Challenges.srt
|
SRT
|
2.8 KB
|
|
|
17.1 WHERE Clause Challenges - including hints.pdf
|
PDF
|
154.9 KB
|
|
|
17.2 WHERE Clause Challenges - without hints.pdf
|
PDF
|
123.2 KB
|
|
|
18. Solutions to the WHERE Clause Challenges.mp4
|
MP4
|
25.2 MB
|
|
|
18. Solutions to the WHERE Clause Challenges.srt
|
SRT
|
4.9 KB
|
|
|
18.1 Solutions to the WHERE Clause Challenges.sql
|
SQL
|
614.4 B
|
|
|
19. Introduction to Collations and Pattern Matching.mp4
|
MP4
|
45.4 MB
|
|
|
19. Introduction to Collations and Pattern Matching.srt
|
SRT
|
11.6 KB
|
|
|
2. GROUP BY and Aggregate Functions.mp4
|
MP4
|
23.6 MB
|
|
|
2. GROUP BY and Aggregate Functions.srt
|
SRT
|
7 KB
|
|
|
2. LEFT OUTER JOIN and RIGHT OUTER JOIN.mp4
|
MP4
|
25.2 MB
|
|
|
2. LEFT OUTER JOIN and RIGHT OUTER JOIN.srt
|
SRT
|
4.6 KB
|
|
|
2. OR Operator.mp4
|
MP4
|
10.4 MB
|
|
|
2. OR Operator.srt
|
SRT
|
3.6 KB
|
|
|
2. SELECT Statement.mp4
|
MP4
|
13.4 MB
|
|
|
2. SELECT Statement.srt
|
SRT
|
12.4 KB
|
|
|
20. Pattern Matching - Part 2.mp4
|
MP4
|
17.4 MB
|
|
|
20. Pattern Matching - Part 2.srt
|
SRT
|
5.1 KB
|
|
|
21. Pattern Matching Challenges.mp4
|
MP4
|
3.8 MB
|
|
|
21. Pattern Matching Challenges.srt
|
SRT
|
1.2 KB
|
|
|
21.1 Pattern Matching Challenges - including hints.pdf
|
PDF
|
139.9 KB
|
|
|
21.2 Pattern Matching Challenges - without hints.pdf
|
PDF
|
117.4 KB
|
|
|
22. Solutions to the Pattern Matching Challenges.mp4
|
MP4
|
18.4 MB
|
|
|
22. Solutions to the Pattern Matching Challenges.srt
|
SRT
|
4.4 KB
|
|
|
22.1 Solutions to Pattern Matching Challenges.sql
|
SQL
|
819.2 B
|
|
|
23. MySQL Data Types.mp4
|
MP4
|
32.4 MB
|
|
|
23. MySQL Data Types.srt
|
SRT
|
9.7 KB
|
|
|
3. FULL OUTER JOIN.mp4
|
MP4
|
17.6 MB
|
|
|
3. FULL OUTER JOIN.srt
|
SRT
|
4.4 KB
|
|
|
3. HAVING Clause.mp4
|
MP4
|
18.5 MB
|
|
|
3. HAVING Clause.srt
|
SRT
|
5.9 KB
|
|
|
3. Operator Precedence.mp4
|
MP4
|
15.6 MB
|
|
|
3. Operator Precedence.srt
|
SRT
|
4.8 KB
|
|
|
3. Software Installation (Windows).mp4
|
MP4
|
60.9 MB
|
|
|
3. Software Installation (Windows).srt
|
SRT
|
15 KB
|
|
|
3.1 Entity Relationship Diagram.pdf
|
PDF
|
45.3 KB
|
|
|
4. IN Operator.mp4
|
MP4
|
4.3 MB
|
|
|
4. IN Operator.srt
|
SRT
|
3.2 KB
|
|
|
4. Integrity Constraints.mp4
|
MP4
|
63.5 MB
|
|
|
4. Integrity Constraints.srt
|
SRT
|
16.2 KB
|
|
|
4. Logical Query Processing Order.mp4
|
MP4
|
12.7 MB
|
|
|
4. Logical Query Processing Order.srt
|
SRT
|
10 KB
|
|
|
4. Overview of the Course Challenges.mp4
|
MP4
|
7.7 MB
|
|
|
4. Overview of the Course Challenges.srt
|
SRT
|
3.4 KB
|
|
|
4.1 Entity Relationship Diagram.pdf
|
PDF
|
45.3 KB
|
|
|
5. GROUP BY Challenges.mp4
|
MP4
|
12.2 MB
|
|
|
5. GROUP BY Challenges.srt
|
SRT
|
3.7 KB
|
|
|
5. Join Challenges.mp4
|
MP4
|
7.8 MB
|
|
|
5. Join Challenges.srt
|
SRT
|
2.3 KB
|
|
|
5. Logical Operator Challenges.mp4
|
MP4
|
6.5 MB
|
|
|
5. Logical Operator Challenges.srt
|
SRT
|
2.6 KB
|
|
|
5. SELECT Challenges.mp4
|
MP4
|
7.9 MB
|
|
|
5. SELECT Challenges.srt
|
SRT
|
2.8 KB
|
|
|
5.1 Entity Relationship Diagram.pdf
|
PDF
|
45.3 KB
|
|
|
5.1 GROUP BY Challenges - including hints.pdf
|
PDF
|
135.1 KB
|
|
|
5.1 Logical Operator Challenges - including hints.pdf
|
PDF
|
139.2 KB
|
|
|
5.1 SELECT Challenges - including hints.pdf
|
PDF
|
99.7 KB
|
|
|
5.2 GROUP BY Challenges - without hints.pdf
|
PDF
|
134.8 KB
|
|
|
5.2 Join Challenges - without hints.pdf
|
PDF
|
110.4 KB
|
|
|
5.2 Logical Operator Challenges - without hints.pdf
|
PDF
|
138.7 KB
|
|
|
5.2 SELECT Challenges - without hints.pdf
|
PDF
|
92.2 KB
|
|
|
5.3 Join Challenges including hints.pdf
|
PDF
|
112.7 KB
|
|
|
6. Solutions to the GROUP BY Challenges.mp4
|
MP4
|
69.3 MB
|
|
|
6. Solutions to the GROUP BY Challenges.srt
|
SRT
|
14.3 KB
|
|
|
6. Solutions to the Join Challenges.mp4
|
MP4
|
11.7 MB
|
|
|
6. Solutions to the Join Challenges.srt
|
SRT
|
8 KB
|
|
|
6. Solutions to the Logical Operator Challenges.mp4
|
MP4
|
41.5 MB
|
|
|
6. Solutions to the Logical Operator Challenges.srt
|
SRT
|
7 KB
|
|
|
6. Solutions to the SELECT Challenges.mp4
|
MP4
|
41.4 MB
|
|
|
6. Solutions to the SELECT Challenges.srt
|
SRT
|
10.5 KB
|
|
|
6.1 Solutions to the GROUP BY Challenges.sql
|
SQL
|
1.6 KB
|
|
|
6.1 Solutions to the Join Challenges.sql
|
SQL
|
1.2 KB
|
|
|
6.1 Solutions to the Logical Operator Challenges.sql
|
SQL
|
1.1 KB
|
|
|
6.1 Solutions to the SELECT Challenges.sql
|
SQL
|
307.2 B
|
|
|
7. SELECT DISTINCT.mp4
|
MP4
|
3.9 MB
|
|
|
7. SELECT DISTINCT.srt
|
SRT
|
3 KB
|
|
|
8. SELECT DISTINCT Challenges.mp4
|
MP4
|
4.6 MB
|
|
|
8. SELECT DISTINCT Challenges.srt
|
SRT
|
1.5 KB
|
|
|
8.1 SELECT DISTINCT Challenges - including hints.pdf
|
PDF
|
93.4 KB
|
|
|
8.2 SELECT DISTINCT Challenges - without hints.pdf
|
PDF
|
87.2 KB
|
|
|
9. Solutions to the SELECT DISTINCT Challenges.mp4
|
MP4
|
19 MB
|
|
|
9. Solutions to the SELECT DISTINCT Challenges.srt
|
SRT
|
4.3 KB
|
|
|
9.1 Solutions to SELECT DISTINCT Challenges.sql
|
SQL
|
307.2 B
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
