|
|
1. GROUPING SETS.mp4
|
MP4
|
42.1 MB
|
|
|
1. How to get the most out of the course.mp4
|
MP4
|
33.7 MB
|
|
|
1. Managing databases & tables.mp4
|
MP4
|
21.6 MB
|
|
|
1. Mathematical functions and operators.mp4
|
MP4
|
39.2 MB
|
|
|
1. OVER() with PARTITION BY.mp4
|
MP4
|
66.6 MB
|
|
|
1. Project Introduction.mp4
|
MP4
|
47.2 MB
|
|
|
1. Project introduction.html
|
HTML
|
1.5 KB
|
|
|
1. Today's plan.mp4
|
MP4
|
11.5 MB
|
|
|
1. UNION.mp4
|
MP4
|
46.1 MB
|
|
|
1. UPDATE.mp4
|
MP4
|
31.4 MB
|
|
|
1. User management.mp4
|
MP4
|
19.8 MB
|
|
|
1. User-defined functions.mp4
|
MP4
|
37.2 MB
|
|
|
1. WHERE.mp4
|
MP4
|
27.7 MB
|
|
|
1. What are joins.mp4
|
MP4
|
20 MB
|
|
|
10. BETWEEN.mp4
|
MP4
|
34.9 MB
|
|
|
10. COALESCE.mp4
|
MP4
|
23 MB
|
|
|
10. CREATE TABLE.mp4
|
MP4
|
43.7 MB
|
|
|
10. CREATE VIEW.mp4
|
MP4
|
37.7 MB
|
|
|
10. Challenge Stored procedures.mp4
|
MP4
|
7.5 MB
|
|
|
10. FIRST_VALUE().mp4
|
MP4
|
24.8 MB
|
|
|
10. HAVING.mp4
|
MP4
|
22.9 MB
|
|
|
10. Indexes - Guidelines.mp4
|
MP4
|
27 MB
|
|
|
10. Installing PostgreSQL & pgAdmin (MacOS).mp4
|
MP4
|
38.3 MB
|
|
|
10. Self joins.mp4
|
MP4
|
50.8 MB
|
|
|
10. Solution 7.mp4
|
MP4
|
18.4 MB
|
|
|
10. Solution Concatenate.mp4
|
MP4
|
12.4 MB
|
|
|
10. Solution LEFT OUTER JOIN.mp4
|
MP4
|
37.5 MB
|
|
|
10. Solution Subqueries in FROM.mp4
|
MP4
|
14.1 MB
|
|
|
10.1 CreateTable.txt
|
TXT
|
409.6 B
|
|
|
11. CAST.mp4
|
MP4
|
40.9 MB
|
|
|
11. CREATE TABLE.html
|
HTML
|
204.8 B
|
|
|
11. Challenge BETWEEN.mp4
|
MP4
|
4.7 MB
|
|
|
11. Challenge CREATE VIEW.html
|
HTML
|
307.2 B
|
|
|
11. Challenge HAVING.mp4
|
MP4
|
17.2 MB
|
|
|
11. Challenge Self joins.mp4
|
MP4
|
5.9 MB
|
|
|
11. Creating indexes.mp4
|
MP4
|
45.7 MB
|
|
|
11. LEAD & LAG.mp4
|
MP4
|
30.9 MB
|
|
|
11. POSITION.mp4
|
MP4
|
22.4 MB
|
|
|
11. RIGHT OUTER JOIN.mp4
|
MP4
|
30.7 MB
|
|
|
11. Setting up the database.mp4
|
MP4
|
27.5 MB
|
|
|
11. Solution 8.mp4
|
MP4
|
11.3 MB
|
|
|
11. Solution Stored procedure.mp4
|
MP4
|
62.2 MB
|
|
|
11. Subqueries in SELECT.mp4
|
MP4
|
25.6 MB
|
|
|
11.1 pagila-master.zip
|
ZIP
|
685.2 KB
|
|
|
12. Challenge CAST & COALESCE.mp4
|
MP4
|
7.3 MB
|
|
|
12. Challenge Joins.mp4
|
MP4
|
7.2 MB
|
|
|
12. Challenge LEAD & LAG.mp4
|
MP4
|
5.8 MB
|
|
|
12. Challenge POSITION.mp4
|
MP4
|
7.9 MB
|
|
|
12. Challenge Subqueries in SELECT.mp4
|
MP4
|
4.2 MB
|
|
|
12. Creating indexes.html
|
HTML
|
204.8 B
|
|
|
12. INSERT.mp4
|
MP4
|
30.8 MB
|
|
|
12. Solution 9.mp4
|
MP4
|
23.2 MB
|
|
|
12. Solution BETWEEN.mp4
|
MP4
|
17.1 MB
|
|
|
12. Solution CREATE VIEW.html
|
HTML
|
307.2 B
|
|
|
12. Solution HAVING.mp4
|
MP4
|
26.7 MB
|
|
|
12. Solution Self joins.mp4
|
MP4
|
19.3 MB
|
|
|
12. The Project.mp4
|
MP4
|
21.6 MB
|
|
|
12. Today's slides.html
|
HTML
|
204.8 B
|
|
|
12.1 Day 14 - Course slides.pdf
|
PDF
|
747.5 KB
|
|
|
13. CREATE MATERIALIZED VIEW.mp4
|
MP4
|
31.7 MB
|
|
|
13. CROSS JOIN.mp4
|
MP4
|
26.7 MB
|
|
|
13. Execution plan & query performance.mp4
|
MP4
|
66.4 MB
|
|
|
13. IN.mp4
|
MP4
|
22.6 MB
|
|
|
13. INSERT.html
|
HTML
|
204.8 B
|
|
|
13. Introducing the second project.mp4
|
MP4
|
29.8 MB
|
|
|
13. SELECT.mp4
|
MP4
|
38.9 MB
|
|
|
13. Solution 10.mp4
|
MP4
|
25.5 MB
|
|
|
13. Solution CAST & COALESCE.mp4
|
MP4
|
10.7 MB
|
|
|
13. Solution Joins.mp4
|
MP4
|
27.8 MB
|
|
|
13. Solution LEAD & LAG.mp4
|
MP4
|
32.3 MB
|
|
|
13. Solution POSITION.mp4
|
MP4
|
16.3 MB
|
|
|
13. Solution Subqueries in SELECT.mp4
|
MP4
|
10.2 MB
|
|
|
13.1 flight_database.zip
|
ZIP
|
21.5 MB
|
|
|
14. ALTER TABLE.mp4
|
MP4
|
32.2 MB
|
|
|
14. Additional challenge.mp4
|
MP4
|
4.1 MB
|
|
|
14. Challenge IN.mp4
|
MP4
|
7 MB
|
|
|
14. Challenge SELECT.mp4
|
MP4
|
6.6 MB
|
|
|
14. Correlated Subqueries in WHERE.mp4
|
MP4
|
56.6 MB
|
|
|
14. Joins on multiple conditions.mp4
|
MP4
|
46.2 MB
|
|
|
14. Managing views.mp4
|
MP4
|
16.1 MB
|
|
|
14. NATURAL JOIN.mp4
|
MP4
|
33.3 MB
|
|
|
14. REPLACE.mp4
|
MP4
|
26.1 MB
|
|
|
14. SUBSTRING.mp4
|
MP4
|
46.9 MB
|
|
|
14. Solution 11.mp4
|
MP4
|
18 MB
|
|
|
14. Today's slides.html
|
HTML
|
409.6 B
|
|
|
14. Today's summary.mp4
|
MP4
|
13.7 MB
|
|
|
14.1 Day 15 - Course slides.pdf
|
PDF
|
989.5 KB
|
|
|
14.1 Day 3 - Course slides.pdf
|
PDF
|
643.7 KB
|
|
|
15. Challenge ALTER TABLE.mp4
|
MP4
|
15.6 MB
|
|
|
15. Challenge Correlated subqueries in WHERE.mp4
|
MP4
|
5.9 MB
|
|
|
15. Challenge Managing views.html
|
HTML
|
819.2 B
|
|
|
15. Challenge SUBSTRING.mp4
|
MP4
|
6.8 MB
|
|
|
15. Solution 12.mp4
|
MP4
|
37 MB
|
|
|
15. Solution Additional Challenge.mp4
|
MP4
|
20.2 MB
|
|
|
15. Solution IN.mp4
|
MP4
|
14.5 MB
|
|
|
15. Solution Joins on multiple conditions.mp4
|
MP4
|
13 MB
|
|
|
15. Solution SELECT.mp4
|
MP4
|
25.2 MB
|
|
|
15. Today's slides.html
|
HTML
|
204.8 B
|
|
|
15.1 Day 12 - Course slides.pdf
|
PDF
|
612.8 KB
|
|
|
15.1 Day 5 - Course slides.pdf
|
PDF
|
732.8 KB
|
|
|
16. Joining multiple tables.mp4
|
MP4
|
34.9 MB
|
|
|
16. LIKE.mp4
|
MP4
|
46.5 MB
|
|
|
16. ORDER BY.mp4
|
MP4
|
37 MB
|
|
|
16. Solution 13.mp4
|
MP4
|
52.5 MB
|
|
|
16. Solution ALTER TABLE.mp4
|
MP4
|
40.1 MB
|
|
|
16. Solution Correlated subqueries in WHERE.mp4
|
MP4
|
17.5 MB
|
|
|
16. Solution Managing views.html
|
HTML
|
1 KB
|
|
|
16. Solution SUBSTRING.mp4
|
MP4
|
34.5 MB
|
|
|
16. Today's slides.html
|
HTML
|
204.8 B
|
|
|
16.1 Day 11 - Course slides.pdf
|
PDF
|
711.2 KB
|
|
|
17. Challenge LIKE.mp4
|
MP4
|
7.2 MB
|
|
|
17. Challenge ORDER BY.mp4
|
MP4
|
6.4 MB
|
|
|
17. Correlated Subquery in SELECT.mp4
|
MP4
|
28.1 MB
|
|
|
17. EXTRACT.mp4
|
MP4
|
50 MB
|
|
|
17. Import & Export.mp4
|
MP4
|
63.1 MB
|
|
|
17. Joining multiple tables - Practice.mp4
|
MP4
|
39.4 MB
|
|
|
17. Solution 14.mp4
|
MP4
|
40.4 MB
|
|
|
17. TRUNCATE & DROP TABLE.mp4
|
MP4
|
26.3 MB
|
|
|
17.1 DROP & TRUNCATE.txt
|
TXT
|
307.2 B
|
|
|
18. CHECK.mp4
|
MP4
|
34.1 MB
|
|
|
18. Challenge EXTRACT.mp4
|
MP4
|
8.8 MB
|
|
|
18. Challenge Joining multiple tables.mp4
|
MP4
|
3.5 MB
|
|
|
18. More challenges Correlated subqueres.mp4
|
MP4
|
15.5 MB
|
|
|
18. Solution LIKE.mp4
|
MP4
|
35.3 MB
|
|
|
18. Solution ORDER BY.mp4
|
MP4
|
21 MB
|
|
|
18. Today's slides.html
|
HTML
|
307.2 B
|
|
|
18.1 Day 10 - Course slides.pdf
|
PDF
|
870.7 KB
|
|
|
19. Challenge CHECK.mp4
|
MP4
|
12.2 MB
|
|
|
19. Comments & Aliases.mp4
|
MP4
|
41.8 MB
|
|
|
19. SELECT DISTINCT.mp4
|
MP4
|
25.5 MB
|
|
|
19. Solution EXTRACT.mp4
|
MP4
|
32.8 MB
|
|
|
19. Solution Joining multiple tables.mp4
|
MP4
|
34.3 MB
|
|
|
19. Solution More challenges.mp4
|
MP4
|
61.9 MB
|
|
|
2. Aggregate functions.mp4
|
MP4
|
31.8 MB
|
|
|
2. CREATE DATABASE.mp4
|
MP4
|
27.4 MB
|
|
|
2. CREATE USER ROLE.mp4
|
MP4
|
47.3 MB
|
|
|
2. Challenge GROUPING SETS.mp4
|
MP4
|
3.2 MB
|
|
|
2. Challenge Mathematical functions and operators.mp4
|
MP4
|
13.8 MB
|
|
|
2. Challenge OVER() with PARTITION BY.mp4
|
MP4
|
9.9 MB
|
|
|
2. Challenge UPDATE.mp4
|
MP4
|
5.2 MB
|
|
|
2. Challenge WHERE.mp4
|
MP4
|
5.6 MB
|
|
|
2. Challenges.html
|
HTML
|
5.2 KB
|
|
|
2. How this course works.mp4
|
MP4
|
25.1 MB
|
|
|
2. INNER JOIN - Theory.mp4
|
MP4
|
67.4 MB
|
|
|
2. LENGTH, LOWER & UPPER.mp4
|
MP4
|
36.1 MB
|
|
|
2. The challenges.html
|
HTML
|
11.6 KB
|
|
|
2. UNION - Practice.mp4
|
MP4
|
33.5 MB
|
|
|
2. User-defined functions - Example.mp4
|
MP4
|
26.9 MB
|
|
|
20. Challenge SELECT DISTINCT.mp4
|
MP4
|
5.2 MB
|
|
|
20. More challenges.html
|
HTML
|
512 B
|
|
|
20. Solution CHECK.mp4
|
MP4
|
48.7 MB
|
|
|
20. TO_CHAR.mp4
|
MP4
|
52.4 MB
|
|
|
20. Today's slides.html
|
HTML
|
307.2 B
|
|
|
20. Today's summary.mp4
|
MP4
|
27.5 MB
|
|
|
20.1 Day 2 - Course slides.pdf
|
PDF
|
1.1 MB
|
|
|
21. Challenge TO_CHAR.mp4
|
MP4
|
6.7 MB
|
|
|
21. Solution SELECT DISTINCT.mp4
|
MP4
|
14.5 MB
|
|
|
21. Solutions.html
|
HTML
|
1.5 KB
|
|
|
21. Today's challenges.mp4
|
MP4
|
35.3 MB
|
|
|
21. Today's slides.html
|
HTML
|
204.8 B
|
|
|
21.1 Day 9 - Course slides.pdf
|
PDF
|
1.9 MB
|
|
|
22. LIMIT.mp4
|
MP4
|
26.1 MB
|
|
|
22. Solution TO_CHAR.mp4
|
MP4
|
33 MB
|
|
|
22. Today's slides.html
|
HTML
|
204.8 B
|
|
|
22.1 Day 6 - Course slides.pdf
|
PDF
|
1.5 MB
|
|
|
23. COUNT().mp4
|
MP4
|
21.4 MB
|
|
|
23. Intervals & Timestamps.mp4
|
MP4
|
32.6 MB
|
|
|
24. Challenge Intervals & Timestamps.mp4
|
MP4
|
6.7 MB
|
|
|
24. Today's challenges.mp4
|
MP4
|
31.5 MB
|
|
|
25. Solution Intervals & Timestamps.mp4
|
MP4
|
11.1 MB
|
|
|
25. Today's summary.mp4
|
MP4
|
32.7 MB
|
|
|
25.1 Day 1 - Course slides.pdf
|
PDF
|
2 MB
|
|
|
26. Today's slides.html
|
HTML
|
204.8 B
|
|
|
26.1 Day 4 - Course slides.pdf
|
PDF
|
743.5 KB
|
|
|
3. CREATE & DROP DATABASE.html
|
HTML
|
204.8 B
|
|
|
3. Challenge Aggregate function.mp4
|
MP4
|
10.4 MB
|
|
|
3. Challenge LENGTH, LOWER & UPPER.mp4
|
MP4
|
5.8 MB
|
|
|
3. Challenge User-defined functions.mp4
|
MP4
|
3.6 MB
|
|
|
3. GRANT & REVOKE privileges.mp4
|
MP4
|
45.6 MB
|
|
|
3. INNER JOIN - Practice.mp4
|
MP4
|
51.3 MB
|
|
|
3. Solution GROUPING SETS.mp4
|
MP4
|
11.3 MB
|
|
|
3. Solution Mathematical functions and operators.mp4
|
MP4
|
25.3 MB
|
|
|
3. Solution OVER() with PARTITION BY.mp4
|
MP4
|
29.7 MB
|
|
|
3. Solution UPDATE.mp4
|
MP4
|
24.3 MB
|
|
|
3. Solution WHERE.mp4
|
MP4
|
21.2 MB
|
|
|
3. Solutions.html
|
HTML
|
5.2 KB
|
|
|
3. Subqueries in WHERE.mp4
|
MP4
|
38.6 MB
|
|
|
3. Why learning SQL.mp4
|
MP4
|
24.8 MB
|
|
|
4. CASE WHEN - Theory.mp4
|
MP4
|
40.7 MB
|
|
|
4. Challenge INNER JOIN.mp4
|
MP4
|
4.7 MB
|
|
|
4. Challenge Subqueries in WHERE.mp4
|
MP4
|
6.5 MB
|
|
|
4. DELETE.mp4
|
MP4
|
33.6 MB
|
|
|
4. Data Types.mp4
|
MP4
|
58.1 MB
|
|
|
4. GROUP BY.mp4
|
MP4
|
31.2 MB
|
|
|
4. Let's get started!.html
|
HTML
|
204.8 B
|
|
|
4. OVER() with ORDER BY.mp4
|
MP4
|
44.8 MB
|
|
|
4. Privileges - Hands-on.mp4
|
MP4
|
64.1 MB
|
|
|
4. ROLLUP.mp4
|
MP4
|
48.9 MB
|
|
|
4. Solution 1.mp4
|
MP4
|
7.8 MB
|
|
|
4. Solution LENGTH, LOWER & UPPER.mp4
|
MP4
|
12.3 MB
|
|
|
4. Solution.mp4
|
MP4
|
30.3 MB
|
|
|
4. WHERE operators.mp4
|
MP4
|
28.1 MB
|
|
|
5. CASE WHEN - Hands-on.mp4
|
MP4
|
43.7 MB
|
|
|
5. Challenge DELETE.mp4
|
MP4
|
4.2 MB
|
|
|
5. Challenge GROUP BY.mp4
|
MP4
|
10.1 MB
|
|
|
5. Challenge OVER() with ORDER BY.mp4
|
MP4
|
6.8 MB
|
|
|
5. Challenge Privileges.html
|
HTML
|
614.4 B
|
|
|
5. Challenge ROLLUP.mp4
|
MP4
|
8.2 MB
|
|
|
5. Challenge WHERE operators.mp4
|
MP4
|
7.6 MB
|
|
|
5. Data Types.html
|
HTML
|
204.8 B
|
|
|
5. LEFT & RIGHT.mp4
|
MP4
|
24 MB
|
|
|
5. Solution 2.mp4
|
MP4
|
22.6 MB
|
|
|
5. Solution INNER JOIN.mp4
|
MP4
|
15.9 MB
|
|
|
5. Solution Subqueries in WHERE.mp4
|
MP4
|
29.2 MB
|
|
|
5. Transactions.mp4
|
MP4
|
38.7 MB
|
|
|
5. What is a database.mp4
|
MP4
|
19.5 MB
|
|
|
5.1 TRANSACTIONS.txt
|
TXT
|
307.2 B
|
|
|
6. 3 Challenge CASE WHEN.mp4
|
MP4
|
26.3 MB
|
|
|
6. Challenge LEFT & RIGHT.mp4
|
MP4
|
6.1 MB
|
|
|
6. Challenge Transactions.mp4
|
MP4
|
3.8 MB
|
|
|
6. Constraints.mp4
|
MP4
|
29 MB
|
|
|
6. Databases.html
|
HTML
|
204.8 B
|
|
|
6. FULL OUTER JOIN.mp4
|
MP4
|
43.7 MB
|
|
|
6. More challenges Subqueries in WHERE.mp4
|
MP4
|
8.7 MB
|
|
|
6. Solution 3.mp4
|
MP4
|
21.3 MB
|
|
|
6. Solution DELETE.mp4
|
MP4
|
8.8 MB
|
|
|
6. Solution GROUP BY.mp4
|
MP4
|
20.1 MB
|
|
|
6. Solution OVER() with ORDER BY.mp4
|
MP4
|
12.5 MB
|
|
|
6. Solution Privileges.html
|
HTML
|
512 B
|
|
|
6. Solution ROLLUP.mp4
|
MP4
|
20.8 MB
|
|
|
6. Solution WHERE operators.mp4
|
MP4
|
13.5 MB
|
|
|
6.1 Challenge_Transactions.txt
|
TXT
|
2.8 KB
|
|
|
7. CREATE TABLE AS.mp4
|
MP4
|
21.3 MB
|
|
|
7. CUBE.mp4
|
MP4
|
31.9 MB
|
|
|
7. Constraints.html
|
HTML
|
204.8 B
|
|
|
7. Different dialects of SQL.mp4
|
MP4
|
13.8 MB
|
|
|
7. GROUP BY multiple columns.mp4
|
MP4
|
21.6 MB
|
|
|
7. JOIN & WHERE.mp4
|
MP4
|
24.8 MB
|
|
|
7. Quick solutions.html
|
HTML
|
1.6 KB
|
|
|
7. RANK().mp4
|
MP4
|
48.6 MB
|
|
|
7. Solution 4.mp4
|
MP4
|
9.2 MB
|
|
|
7. Solution LEFT & RIGHT.mp4
|
MP4
|
13.6 MB
|
|
|
7. Solution More challenges.mp4
|
MP4
|
37.8 MB
|
|
|
7. Solution Transactions.mp4
|
MP4
|
30.1 MB
|
|
|
7. WHERE with ANDOR.mp4
|
MP4
|
45.2 MB
|
|
|
7. What are indexes.mp4
|
MP4
|
31.8 MB
|
|
|
8. B-Tree index.mp4
|
MP4
|
21.1 MB
|
|
|
8. Challenge CREATE TABLE AS.mp4
|
MP4
|
4 MB
|
|
|
8. Challenge CUBE.html
|
HTML
|
409.6 B
|
|
|
8. Challenge GROUP BY multiple columns.mp4
|
MP4
|
16.4 MB
|
|
|
8. Challenge RANK().mp4
|
MP4
|
7.1 MB
|
|
|
8. Challenge WHERE with ANDOR.mp4
|
MP4
|
8.9 MB
|
|
|
8. Concatenate.mp4
|
MP4
|
18.1 MB
|
|
|
8. Dialects of SQL.html
|
HTML
|
204.8 B
|
|
|
8. LEFT OUTER JOIN.mp4
|
MP4
|
41.2 MB
|
|
|
8. Primary Key & Foreign Key.mp4
|
MP4
|
28.6 MB
|
|
|
8. Rollbacks.mp4
|
MP4
|
33.1 MB
|
|
|
8. Solution 5.mp4
|
MP4
|
20 MB
|
|
|
8. Solution CASE WHEN.mp4
|
MP4
|
51.1 MB
|
|
|
8. Subqueries in FROM.mp4
|
MP4
|
22.7 MB
|
|
|
9. Bitmap index.mp4
|
MP4
|
22.5 MB
|
|
|
9. CASE WHEN & SUM.mp4
|
MP4
|
46.3 MB
|
|
|
9. Challenge Concatenate.mp4
|
MP4
|
6.8 MB
|
|
|
9. Challenge LEFT OUTER JOIN.mp4
|
MP4
|
10 MB
|
|
|
9. Challenge Subqueries in FROM.mp4
|
MP4
|
2.7 MB
|
|
|
9. Installing PostgreSQL & pgAdmin (Windows).mp4
|
MP4
|
35.6 MB
|
|
|
9. Primary & Foreign Key.html
|
HTML
|
204.8 B
|
|
|
9. Solution 6.mp4
|
MP4
|
20.9 MB
|
|
|
9. Solution CREATE TABLE AS.mp4
|
MP4
|
19.8 MB
|
|
|
9. Solution CUBE.html
|
HTML
|
409.6 B
|
|
|
9. Solution GROUP BY multiple columns.mp4
|
MP4
|
25.8 MB
|
|
|
9. Solution RANK().mp4
|
MP4
|
20.5 MB
|
|
|
9. Solution WHERE with ANDOR.mp4
|
MP4
|
22.2 MB
|
|
|
9. Stored procedures.mp4
|
MP4
|
56.4 MB
|
|
|
[CourseClub.Me].url
|
URL
|
102.4 B
|
|
|
[FreeCourseSite.com].url
|
URL
|
102.4 B
|
|
|
[GigaCourse.Com].url
|
URL
|
0 B
|