|
|
001 CASE Clause in SQL.en.srt
|
SRT
|
4.5 KB
|
|
|
001 CASE Clause in SQL.mp4
|
MP4
|
9.1 MB
|
|
|
001 COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.en.srt
|
SRT
|
4.9 KB
|
|
|
001 COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.mp4
|
MP4
|
25.9 MB
|
|
|
001 Challenge(1).html
|
HTML
|
1.1 KB
|
|
|
001 Course Intro.en.srt
|
SRT
|
5.2 KB
|
|
|
001 Course Intro.mp4
|
MP4
|
52.1 MB
|
|
|
001 Final Exam Quiz 1.html
|
HTML
|
1 KB
|
|
|
001 GROUPING SETS(), ROLLUP(), CUBE().en.srt
|
SRT
|
5 KB
|
|
|
001 GROUPING SETS(), ROLLUP(), CUBE().mp4
|
MP4
|
50.7 MB
|
|
|
001 INNER JOIN.en.srt
|
SRT
|
6.8 KB
|
|
|
001 INNER JOIN.mp4
|
MP4
|
53 MB
|
|
|
001 LIMIT & ORDER BY.en.srt
|
SRT
|
8 KB
|
|
|
001 LIMIT & ORDER BY.mp4
|
MP4
|
51.6 MB
|
|
|
001 Math Functions.en.srt
|
SRT
|
4.2 KB
|
|
|
001 Math Functions.mp4
|
MP4
|
39.9 MB
|
|
|
001 Overview of Time Functions in PostgreSQL.en.srt
|
SRT
|
2.2 KB
|
|
|
001 Overview of Time Functions in PostgreSQL.mp4
|
MP4
|
30.5 MB
|
|
|
001 PostgreSQL POSITION Function.en.srt
|
SRT
|
3.1 KB
|
|
|
001 PostgreSQL POSITION Function.mp4
|
MP4
|
19.4 MB
|
|
|
001 SQL Database Overview Part 1.en.srt
|
SRT
|
2.7 KB
|
|
|
001 SQL Database Overview Part 1.mp4
|
MP4
|
8.7 MB
|
|
|
001 SQL PostgreSQL Down and install.en.srt
|
SRT
|
3.2 KB
|
|
|
001 SQL PostgreSQL Down and install.mp4
|
MP4
|
21.4 MB
|
|
|
001 Select Statement.en.srt
|
SRT
|
6.2 KB
|
|
|
001 Select Statement.mp4
|
MP4
|
36.8 MB
|
|
|
001 Sub-queries.en.srt
|
SRT
|
6 KB
|
|
|
001 Sub-queries.mp4
|
MP4
|
38.8 MB
|
|
|
001 Where Clause.en.srt
|
SRT
|
7.3 KB
|
|
|
001 Where Clause.mp4
|
MP4
|
49.6 MB
|
|
|
002 FETCH vs LIMIT.en.srt
|
SRT
|
2.8 KB
|
|
|
002 FETCH vs LIMIT.mp4
|
MP4
|
22.5 MB
|
|
|
002 Joins Types Overview.en.srt
|
SRT
|
10.7 KB
|
|
|
002 Joins Types Overview.mp4
|
MP4
|
41.6 MB
|
|
|
002 NULLIF() Function in SQL.en.srt
|
SRT
|
4 KB
|
|
|
002 NULLIF() Function in SQL.mp4
|
MP4
|
24.4 MB
|
|
|
002 Operators used with Where Clause.en.srt
|
SRT
|
4.6 KB
|
|
|
002 Operators used with Where Clause.mp4
|
MP4
|
31.9 MB
|
|
|
002 PostgreSQL Database creation.en.srt
|
SRT
|
1.4 KB
|
|
|
002 PostgreSQL Database creation.mp4
|
MP4
|
6.7 MB
|
|
|
002 SELECT Statement + INTO & SELECT Statement + INTO + IN.en.srt
|
SRT
|
4 KB
|
|
|
002 SELECT Statement + INTO & SELECT Statement + INTO + IN.mp4
|
MP4
|
35.8 MB
|
|
|
002 SQL Database Overview Part 2.en.srt
|
SRT
|
4.7 KB
|
|
|
002 SQL Database Overview Part 2.mp4
|
MP4
|
6.2 MB
|
|
|
002 SQL Sub-query + EXISTS, ANY OR ALL.en.srt
|
SRT
|
9.2 KB
|
|
|
002 SQL Sub-query + EXISTS, ANY OR ALL.mp4
|
MP4
|
90.3 MB
|
|
|
002 STRPOS() & REPLACE() in PostgreSQL.en.srt
|
SRT
|
4.1 KB
|
|
|
002 STRPOS() & REPLACE() in PostgreSQL.mp4
|
MP4
|
35.2 MB
|
|
|
002 SUM( ) Function.en.srt
|
SRT
|
1 KB
|
|
|
002 SUM( ) Function.mp4
|
MP4
|
6.2 MB
|
|
|
002 Select Challenge Solution.en.srt
|
SRT
|
2.8 KB
|
|
|
002 Select Challenge Solution.mp4
|
MP4
|
18.4 MB
|
|
|
002 Solution.html
|
HTML
|
1.8 KB
|
|
|
002 TIMESTAMP EXTRACT().en.srt
|
SRT
|
3 KB
|
|
|
002 TIMESTAMP EXTRACT().mp4
|
MP4
|
25.4 MB
|
|
|
002 Window Functions OVER().en.srt
|
SRT
|
3 KB
|
|
|
002 Window Functions OVER().mp4
|
MP4
|
25.8 MB
|
|
|
003 COALESCE() Function in SQL.en.srt
|
SRT
|
2.7 KB
|
|
|
003 COALESCE() Function in SQL.mp4
|
MP4
|
24.3 MB
|
|
|
003 Challenge(2).html
|
HTML
|
1.4 KB
|
|
|
003 Common Table Expression.en.srt
|
SRT
|
8.5 KB
|
|
|
003 Common Table Expression.mp4
|
MP4
|
61 MB
|
|
|
003 DATE_TRUNC() & DATE_PART().en.srt
|
SRT
|
7.7 KB
|
|
|
003 DATE_TRUNC() & DATE_PART().mp4
|
MP4
|
38.7 MB
|
|
|
003 Final Exam Quiz 2.html
|
HTML
|
1 KB
|
|
|
003 LEFT OUTER JOIN.en.srt
|
SRT
|
4.1 KB
|
|
|
003 LEFT OUTER JOIN.mp4
|
MP4
|
27.7 MB
|
|
|
003 MIN( ) , MAX( ) & AVG( ) Functions.en.srt
|
SRT
|
2.3 KB
|
|
|
003 MIN( ) , MAX( ) & AVG( ) Functions.mp4
|
MP4
|
10.9 MB
|
|
|
003 NOT IN.en.srt
|
SRT
|
4.1 KB
|
|
|
003 NOT IN.mp4
|
MP4
|
28.5 MB
|
|
|
003 PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT_PART() Functions.en.srt
|
SRT
|
5.6 KB
|
|
|
003 PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT_PART() Functions.mp4
|
MP4
|
40.2 MB
|
|
|
003 SQL Data Types.en.srt
|
SRT
|
1.3 KB
|
|
|
003 SQL Data Types.mp4
|
MP4
|
11 MB
|
|
|
003 SQL Restore.en.srt
|
SRT
|
1.4 KB
|
|
|
003 SQL Restore.mp4
|
MP4
|
10.5 MB
|
|
|
003 Select Statement For all Airlines Database Tables.en.srt
|
SRT
|
1.8 KB
|
|
|
003 Select Statement For all Airlines Database Tables.mp4
|
MP4
|
29.9 MB
|
|
|
003 VIEW().en.srt
|
SRT
|
4.6 KB
|
|
|
003 VIEW().mp4
|
MP4
|
26.9 MB
|
|
|
003 Where Clause + AND & Where Clause + OR.en.srt
|
SRT
|
3.5 KB
|
|
|
003 Where Clause + AND & Where Clause + OR.mp4
|
MP4
|
17.2 MB
|
|
|
003 Window Functions RANK() + OVER() & NTILE() + OVER().en.srt
|
SRT
|
5.1 KB
|
|
|
003 Window Functions RANK() + OVER() & NTILE() + OVER().mp4
|
MP4
|
68.8 MB
|
|
|
004 Deep understanding of LEFT JOIN.en.srt
|
SRT
|
3.4 KB
|
|
|
004 Deep understanding of LEFT JOIN.mp4
|
MP4
|
22.7 MB
|
|
|
004 Distinct.en.srt
|
SRT
|
2.1 KB
|
|
|
004 Distinct.mp4
|
MP4
|
11.7 MB
|
|
|
004 Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( ).en.srt
|
SRT
|
3.5 KB
|
|
|
004 Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( ).mp4
|
MP4
|
19.6 MB
|
|
|
004 GROUP BY & HAVING.en.srt
|
SRT
|
2.3 KB
|
|
|
004 GROUP BY & HAVING.mp4
|
MP4
|
14.5 MB
|
|
|
004 ISNULL & IS NOT NULL.en.srt
|
SRT
|
2.8 KB
|
|
|
004 ISNULL & IS NOT NULL.mp4
|
MP4
|
22 MB
|
|
|
004 PostgreSQL CONCAT Function.en.srt
|
SRT
|
3.3 KB
|
|
|
004 PostgreSQL CONCAT Function.mp4
|
MP4
|
9.4 MB
|
|
|
004 Solution.html
|
HTML
|
1.2 KB
|
|
|
004 Where Clause + LIKE.en.srt
|
SRT
|
5.5 KB
|
|
|
004 Where Clause + LIKE.mp4
|
MP4
|
24.9 MB
|
|
|
004 Window Functions OVER() + LEAD().en.srt
|
SRT
|
5.6 KB
|
|
|
004 Window Functions OVER() + LEAD().mp4
|
MP4
|
43.5 MB
|
|
|
005 (Where Clause + BETWEEN & IN) & AS.en.srt
|
SRT
|
5.5 KB
|
|
|
005 (Where Clause + BETWEEN & IN) & AS.mp4
|
MP4
|
41.6 MB
|
|
|
005 CAST.en.srt
|
SRT
|
4.4 KB
|
|
|
005 CAST.mp4
|
MP4
|
30.7 MB
|
|
|
005 Challenge(3).html
|
HTML
|
1 KB
|
|
|
005 Final Exam Quiz 3.html
|
HTML
|
921.6 B
|
|
|
005 PostgreSQL LOWER(), UPPER() & INITCAP() Functions.en.srt
|
SRT
|
3.5 KB
|
|
|
005 PostgreSQL LOWER(), UPPER() & INITCAP() Functions.mp4
|
MP4
|
38 MB
|
|
|
005 RIGHT OUTER JOIN.en.srt
|
SRT
|
3.2 KB
|
|
|
005 RIGHT OUTER JOIN.mp4
|
MP4
|
20.6 MB
|
|
|
005 Window Functions OVER() + LAG().en.srt
|
SRT
|
4.2 KB
|
|
|
005 Window Functions OVER() + LAG().mp4
|
MP4
|
30.6 MB
|
|
|
006 FULL OUTER JOIN.en.srt
|
SRT
|
5.5 KB
|
|
|
006 FULL OUTER JOIN.mp4
|
MP4
|
38 MB
|
|
|
006 Solution.html
|
HTML
|
1.2 KB
|
|
|
007 CROSS JOIN.en.srt
|
SRT
|
2.3 KB
|
|
|
007 CROSS JOIN.mp4
|
MP4
|
18.5 MB
|
|
|
007 Challenge(4).html
|
HTML
|
1.5 KB
|
|
|
007 Final Exam Quiz 4.html
|
HTML
|
1 KB
|
|
|
008 Solution.html
|
HTML
|
2.5 KB
|
|
|
008 UNION, UNION ALL, INTERSECT & EXCEPT.en.srt
|
SRT
|
6.1 KB
|
|
|
008 UNION, UNION ALL, INTERSECT & EXCEPT.mp4
|
MP4
|
36.4 MB
|
|
|
009 Challenge(5).html
|
HTML
|
1.3 KB
|
|
|
009 Final Exam Quiz 5.html
|
HTML
|
1 KB
|
|
|
009 SELF JOIN.en.srt
|
SRT
|
2.7 KB
|
|
|
009 SELF JOIN.mp4
|
MP4
|
18.2 MB
|
|
|
010 Solution.html
|
HTML
|
1.5 KB
|
|
|
010 USING.en.srt
|
SRT
|
2.3 KB
|
|
|
010 USING.mp4
|
MP4
|
21.9 MB
|
|
|
011 Challenge(6).html
|
HTML
|
1.1 KB
|
|
|
011 Final Exam Quiz 6.html
|
HTML
|
1 KB
|
|
|
011 NATURAL JOIN.en.srt
|
SRT
|
1.9 KB
|
|
|
011 NATURAL JOIN.mp4
|
MP4
|
14.9 MB
|
|
|
012 Solution.html
|
HTML
|
1.3 KB
|
|
|
013 Challenge(7).html
|
HTML
|
1 KB
|
|
|
014 Solution.html
|
HTML
|
1.6 KB
|
|
|
015 Challenge(8).html
|
HTML
|
1.4 KB
|
|
|
016 Solution.html
|
HTML
|
2.5 KB
|
|
|
017 Challenge(9).html
|
HTML
|
1 KB
|
|
|
018 Solution.html
|
HTML
|
1.1 KB
|
|
|
019 Challenge(10).html
|
HTML
|
1.2 KB
|
|
|
020 Solution.html
|
HTML
|
1.4 KB
|
|
|
021 Challenge(11).html
|
HTML
|
1.2 KB
|
|
|
022 Solution.html
|
HTML
|
2 KB
|
|
|
023 Challenge(12).html
|
HTML
|
921.6 B
|
|
|
024 Solution.html
|
HTML
|
1.6 KB
|
|
|
025 Challenge(13).html
|
HTML
|
1.2 KB
|
|
|
026 Solution.html
|
HTML
|
1.5 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
