|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 1. 2024-01-30_07-17-50-21a899f2574db3ff4baf37d9f163de3b.JPG |
1.89MB |
| 1. 2024-06-04_10-51-42-bc9ad906edace8d58aac839f7e56ed5d.png |
11.68KB |
| 1. Bonus.html |
6.93KB |
| 1. GROUPING SETS.mp4 |
45.25MB |
| 1. GROUPING SETS.vtt |
7.20KB |
| 1. Managing databases & tables.mp4 |
22.82MB |
| 1. Managing databases & tables.vtt |
4.29KB |
| 1. Mathematical functions and operators.mp4 |
41.79MB |
| 1. Mathematical functions and operators.vtt |
7.30KB |
| 1. OVER() with PARTITION BY.mp4 |
70.86MB |
| 1. OVER() with PARTITION BY.vtt |
10.48KB |
| 1. Project introduction.html |
1.50KB |
| 1. Project Introduction.mp4 |
49.90MB |
| 1. Project Introduction.vtt |
8.70KB |
| 1. Today's plan.mp4 |
9.43MB |
| 1. Today's plan.mp4 |
12.46MB |
| 1. Today's plan.vtt |
1.57KB |
| 1. Today's plan.vtt |
1.82KB |
| 1. UNION.mp4 |
48.45MB |
| 1. UNION.vtt |
7.33KB |
| 1. UPDATE.mp4 |
33.66MB |
| 1. UPDATE.vtt |
5.52KB |
| 1. User-defined functions.mp4 |
39.29MB |
| 1. User-defined functions.vtt |
8.03KB |
| 1. User management.mp4 |
20.73MB |
| 1. User management.vtt |
4.35KB |
| 1. Welcome!.mp4 |
20.44MB |
| 1. Welcome!.vtt |
3.68KB |
| 1. What are joins.mp4 |
21.15MB |
| 1. What are joins.vtt |
3.78KB |
| 1. WHERE.mp4 |
29.73MB |
| 1. WHERE.vtt |
6.13KB |
| 1. Why an extra day.html |
1.65KB |
| 10.14 GROUP BY multiple columns.html |
4.44KB |
| 10.17 Concatenate.html |
6.30KB |
| 10. 2022-08-09_08-58-09-0c0e6114b042ff98a9e83a6e10f82d8e.png |
18.46KB |
| 10.2 Dialects of SQL.html |
17.05KB |
| 10.8 WHERE with ANDOR.html |
4.44KB |
| 10. Challenge CUBE.html |
391B |
| 10. Challenge Stored procedures.mp4 |
8.00MB |
| 10. Challenge Stored procedures.vtt |
1.64KB |
| 10. CREATE TABLE.mp4 |
46.56MB |
| 10. CREATE TABLE.vtt |
8.63KB |
| 10. CREATE VIEW.mp4 |
40.05MB |
| 10. CREATE VIEW.vtt |
6.65KB |
| 10. FIRST_VALUE().mp4 |
26.59MB |
| 10. FIRST_VALUE().vtt |
3.65KB |
| 10. Indexes - Guidelines.mp4 |
28.32MB |
| 10. Indexes - Guidelines.vtt |
6.16KB |
| 10. Recursive CTEs - Hierarchical Data.mp4 |
54.60MB |
| 10. Recursive CTEs - Hierarchical Data.vtt |
9.03KB |
| 10. Solution 7.mp4 |
19.73MB |
| 10. Solution 7.vtt |
3.28KB |
| 10. Solution CASE WHEN.mp4 |
54.50MB |
| 10. Solution CASE WHEN.vtt |
8.43KB |
| 10. Solution LEFT OUTER JOIN.mp4 |
40.17MB |
| 10. Solution LEFT OUTER JOIN.vtt |
6.94KB |
| 10. Solution Subqueries in FROM.mp4 |
15.12MB |
| 10. Solution Subqueries in FROM.vtt |
2.39KB |
| 11.1 Assignment-CREATE TABLE.html |
3.53KB |
| 11. CASE WHEN & SUM.mp4 |
49.83MB |
| 11. CASE WHEN & SUM.vtt |
7.97KB |
| 11. Challenge Concatenate.mp4 |
7.21MB |
| 11. Challenge Concatenate.vtt |
1.36KB |
| 11. Challenge CREATE VIEW.html |
295B |
| 11. Challenge GROUP BY multiple columns.mp4 |
17.61MB |
| 11. Challenge GROUP BY multiple columns.vtt |
3.15KB |
| 11. Challenge WHERE with ANDOR.mp4 |
9.35MB |
| 11. Challenge WHERE with ANDOR.vtt |
1.79KB |
| 11. Creating indexes.mp4 |
48.72MB |
| 11. Creating indexes.vtt |
9.02KB |
| 11. Installing PostgreSQL & pgAdmin (Windows).mp4 |
11.28MB |
| 11. Installing PostgreSQL & pgAdmin (Windows).vtt |
8.45KB |
| 11. LEAD & LAG.mp4 |
33.15MB |
| 11. LEAD & LAG.vtt |
4.59KB |
| 11. Recursive CTEs - Termination Condition.mp4 |
43.19MB |
| 11. Recursive CTEs - Termination Condition.vtt |
6.16KB |
| 11. RIGHT OUTER JOIN.mp4 |
32.60MB |
| 11. RIGHT OUTER JOIN.vtt |
4.70KB |
| 11. Solution 8.mp4 |
12.05MB |
| 11. Solution 8.vtt |
2.20KB |
| 11. Solution CUBE.html |
483B |
| 11. Solution Stored procedure.mp4 |
29.66MB |
| 11. Solution Stored procedure.vtt |
9.90KB |
| 11. Subqueries in SELECT.mp4 |
27.36MB |
| 11. Subqueries in SELECT.vtt |
3.99KB |
| 12. 2022-09-07_12-34-53-bb78b2cd840131afea3195bf697ca8d0.png |
57.63KB |
| 12. 2022-09-07_12-34-54-47e1ca5d3ee08b5851605849314610d7.png |
108.19KB |
| 12. 2022-09-07_12-34-54-f40c284ed636467884ba52a6ee9bbf2f.png |
145.25KB |
| 12.20 CASE WHEN & SUM.html |
4.75KB |
| 12.3 Assignment-Creating indexes.html |
3.16KB |
| 12. Challenge 3 Recursive CTE.html |
1.53KB |
| 12. Challenge Joins.mp4 |
7.66MB |
| 12. Challenge Joins.vtt |
1.88KB |
| 12. Challenge LEAD & LAG.mp4 |
6.12MB |
| 12. Challenge LEAD & LAG.vtt |
1.38KB |
| 12. Challenge Subqueries in SELECT.mp4 |
4.40MB |
| 12. Challenge Subqueries in SELECT.vtt |
966B |
| 12. Common problems Set binary paths.html |
843B |
| 12. CreateTable.txt |
380B |
| 12. Day 14 - Course slides.pdf |
737.46KB |
| 12. INSERT.mp4 |
32.52MB |
| 12. INSERT.vtt |
5.83KB |
| 12. Self joins.mp4 |
54.24MB |
| 12. Self joins.vtt |
9.22KB |
| 12. Solution 9.mp4 |
24.93MB |
| 12. Solution 9.vtt |
4.42KB |
| 12. Solution Concatenate.mp4 |
13.29MB |
| 12. Solution Concatenate.vtt |
2.59KB |
| 12. Solution CREATE VIEW.html |
317B |
| 12. Solution GROUP BY multiple columns.mp4 |
27.86MB |
| 12. Solution GROUP BY multiple columns.vtt |
4.15KB |
| 12. Solution WHERE with ANDOR.mp4 |
23.83MB |
| 12. Solution WHERE with ANDOR.vtt |
3.65KB |
| 12. Today's slides.html |
254B |
| 13. 2022-09-07_11-07-05-c83708a81bbc36ecd09c1bbf0156166f.png |
34.58KB |
| 13.2 Assignment-INSERT.html |
3.55KB |
| 13. Challenge Self joins.mp4 |
6.19MB |
| 13. Challenge Self joins.vtt |
1.36KB |
| 13. COALESCE.mp4 |
24.39MB |
| 13. COALESCE.vtt |
4.61KB |
| 13. CREATE MATERIALIZED VIEW.mp4 |
33.81MB |
| 13. CREATE MATERIALIZED VIEW.vtt |
5.23KB |
| 13. execution_plan_query_performance.txt |
522B |
| 13. Execution plan & query performance.mp4 |
71.26MB |
| 13. Execution plan & query performance.vtt |
11.61KB |
| 13. HAVING.mp4 |
24.39MB |
| 13. HAVING.vtt |
4.14KB |
| 13. Installing PostgreSQL & pgAdmin (MacOS).mp4 |
40.06MB |
| 13. Installing PostgreSQL & pgAdmin (MacOS).vtt |
5.35KB |
| 13. POSITION.mp4 |
24.09MB |
| 13. POSITION.vtt |
3.86KB |
| 13. Quick note on time zones.html |
685B |
| 13. Solution 10.mp4 |
27.38MB |
| 13. Solution 10.vtt |
4.79KB |
| 13. Solution 3 Recursive CTE.html |
857B |
| 13. Solution Joins.mp4 |
29.68MB |
| 13. Solution Joins.vtt |
4.04KB |
| 13. Solution LEAD & LAG.mp4 |
34.38MB |
| 13. Solution LEAD & LAG.vtt |
4.48KB |
| 13. Solution Subqueries in SELECT.mp4 |
11.00MB |
| 13. Solution Subqueries in SELECT.vtt |
1.68KB |
| 14.15 HAVING.html |
4.26KB |
| 14.21 COALESCE.html |
4.67KB |
| 14. ALTER TABLE.mp4 |
18.92MB |
| 14. ALTER TABLE.vtt |
6.18KB |
| 14. BETWEEN.mp4 |
37.46MB |
| 14. BETWEEN.vtt |
5.27KB |
| 14. Challenge POSITION.mp4 |
8.33MB |
| 14. Challenge POSITION.vtt |
1.53KB |
| 14. Correlated Subqueries in WHERE.mp4 |
60.39MB |
| 14. Correlated Subqueries in WHERE.vtt |
8.43KB |
| 14. Day 11 - Course slides.pdf |
711.22KB |
| 14. Day 15 - Course slides.pdf |
989.47KB |
| 14. Joins on multiple conditions.mp4 |
49.28MB |
| 14. Joins on multiple conditions.vtt |
7.46KB |
| 14. Managing views.mp4 |
16.95MB |
| 14. Managing views.vtt |
3.41KB |
| 14. pagila-master.zip |
685.17KB |
| 14. Setting up the database.mp4 |
29.52MB |
| 14. Setting up the database.vtt |
6.91KB |
| 14. Solution 11.mp4 |
19.35MB |
| 14. Solution 11.vtt |
3.31KB |
| 14. Solution Self joins.mp4 |
20.70MB |
| 14. Solution Self joins.vtt |
3.64KB |
| 14. Today's slides.html |
220B |
| 14. Today's slides.html |
422B |
| 15. 2022-09-07_13-19-43-87939fa943016dfbe8f793fe1eccec7f.png |
4.92KB |
| 15.9 BETWEEN.html |
4.18KB |
| 15. CAST.mp4 |
43.66MB |
| 15. CAST.vtt |
7.06KB |
| 15. Challenge ALTER TABLE.mp4 |
16.65MB |
| 15. Challenge ALTER TABLE.vtt |
2.37KB |
| 15. Challenge Correlated subqueries in WHERE.mp4 |
6.19MB |
| 15. Challenge Correlated subqueries in WHERE.vtt |
1.42KB |
| 15. Challenge HAVING.mp4 |
18.28MB |
| 15. Challenge HAVING.vtt |
3.38KB |
| 15. Challenge Managing views.html |
830B |
| 15. Common problems Slow performance.html |
881B |
| 15. CROSS JOIN.mp4 |
28.45MB |
| 15. CROSS JOIN.vtt |
5.42KB |
| 15. Solution 12.mp4 |
39.65MB |
| 15. Solution 12.vtt |
6.05KB |
| 15. Solution Joins on multiple conditions.mp4 |
13.99MB |
| 15. Solution Joins on multiple conditions.vtt |
2.03KB |
| 15. Solution POSITION.mp4 |
17.47MB |
| 15. Solution POSITION.vtt |
2.94KB |
| 16. Challenge BETWEEN.mp4 |
4.97MB |
| 16. Challenge BETWEEN.vtt |
970B |
| 16. Challenge CAST & COALESCE.mp4 |
7.83MB |
| 16. Challenge CAST & COALESCE.vtt |
1.20KB |
| 16. Joining multiple tables.mp4 |
36.97MB |
| 16. Joining multiple tables.vtt |
5.83KB |
| 16. NATURAL JOIN.mp4 |
35.22MB |
| 16. NATURAL JOIN.vtt |
6.48KB |
| 16. Solution 13.mp4 |
55.78MB |
| 16. Solution 13.vtt |
8.67KB |
| 16. Solution ALTER TABLE.mp4 |
42.70MB |
| 16. Solution ALTER TABLE.vtt |
6.01KB |
| 16. Solution Correlated subqueries in WHERE.mp4 |
18.74MB |
| 16. Solution Correlated subqueries in WHERE.vtt |
3.03KB |
| 16. Solution HAVING.mp4 |
28.71MB |
| 16. Solution HAVING.vtt |
4.60KB |
| 16. Solution Managing views.html |
1.10KB |
| 16. SUBSTRING.mp4 |
49.98MB |
| 16. SUBSTRING.vtt |
8.29KB |
| 16. The Project.mp4 |
22.72MB |
| 16. The Project.vtt |
2.98KB |
| 17. Challenge SUBSTRING.mp4 |
7.21MB |
| 17. Challenge SUBSTRING.vtt |
1.46KB |
| 17. Correlated Subquery in SELECT.mp4 |
30.10MB |
| 17. Correlated Subquery in SELECT.vtt |
4.04KB |
| 17. Create table.txt |
185B |
| 17. Day 12 - Course slides.pdf |
612.81KB |
| 17. DROP & TRUNCATE.txt |
297B |
| 17. ER_diagram_flights_db.png |
120.03KB |
| 17. Fact_sales.csv |
71.92KB |
| 17. flight_database.zip |
21.49MB |
| 17. Import & Export.mp4 |
67.51MB |
| 17. Import & Export.vtt |
9.95KB |
| 17. Introducing the second project.mp4 |
53.22MB |
| 17. Introducing the second project.vtt |
10.12KB |
| 17. Joining multiple tables - Practice.mp4 |
42.25MB |
| 17. Joining multiple tables - Practice.vtt |
5.71KB |
| 17. SELECT.mp4 |
41.03MB |
| 17. SELECT.vtt |
7.90KB |
| 17. Solution 14.mp4 |
43.00MB |
| 17. Solution 14.vtt |
6.77KB |
| 17. Solution BETWEEN.mp4 |
18.49MB |
| 17. Solution BETWEEN.vtt |
3.17KB |
| 17. Solution CAST & COALESCE.mp4 |
11.50MB |
| 17. Solution CAST & COALESCE.vtt |
1.48KB |
| 17. Today's slides.html |
265B |
| 17. TRUNCATE & DROP TABLE.mp4 |
27.94MB |
| 17. TRUNCATE & DROP TABLE.vtt |
5.53KB |
| 18.2 SELECT.html |
3.96KB |
| 18. Challenge Joining multiple tables.mp4 |
3.76MB |
| 18. Challenge Joining multiple tables.vtt |
972B |
| 18. CHECK.mp4 |
36.03MB |
| 18. CHECK.vtt |
6.25KB |
| 18. Day 10 - Course slides.pdf |
870.69KB |
| 18. IN.mp4 |
24.44MB |
| 18. IN.vtt |
4.01KB |
| 18. More challenges Correlated subqueres.mp4 |
16.44MB |
| 18. More challenges Correlated subqueres.vtt |
3.86KB |
| 18. Note for Mac users.html |
1.38KB |
| 18. REPLACE.mp4 |
27.95MB |
| 18. REPLACE.vtt |
4.48KB |
| 18. Solution SUBSTRING.mp4 |
37.15MB |
| 18. Solution SUBSTRING.vtt |
6.77KB |
| 18. Today's slides.html |
324B |
| 19.10 IN operator.html |
4.13KB |
| 19. 2022-09-07_12-34-53-bb78b2cd840131afea3195bf697ca8d0.png |
57.63KB |
| 19. 2022-09-07_12-34-54-47e1ca5d3ee08b5851605849314610d7.png |
108.19KB |
| 19. 2022-09-07_12-34-54-f40c284ed636467884ba52a6ee9bbf2f.png |
109.20KB |
| 19. 2022-09-07_13-34-16-83c120d05b6098b20fd4fb5dfb4cf3ae.png |
16.37KB |
| 19. 2023-01-31_10-38-37-1859562130e2741dc2e211f525fac2cd.png |
10.57KB |
| 19. 2023-01-31_10-38-37-23459267be87bc20d358592f88bf352a.png |
6.77KB |
| 19. 2023-01-31_10-38-37-a411ee5247b6632ddfb1b3da53c01260.png |
107.80KB |
| 19. 2023-01-31_10-38-37-c8c2d4a3e9d240953b0585f660bf5ed7.png |
187.39KB |
| 19. 2023-01-31_10-38-37-f733bcd44e44ef1d146fa360213c636c.png |
11.26KB |
| 19. 2023-01-31_10-38-38-393c5817c6c2e54ca675401a577ff453.png |
22.02KB |
| 19. 2023-01-31_10-38-38-4c4330adbefe30a33a830eaf96a80297.png |
21.90KB |
| 19. Challenge CHECK.mp4 |
12.98MB |
| 19. Challenge CHECK.vtt |
2.28KB |
| 19. Challenge SELECT.mp4 |
6.89MB |
| 19. Challenge SELECT.vtt |
1.65KB |
| 19. Day 5 - Course slides.pdf |
732.78KB |
| 19. EXTRACT.mp4 |
53.34MB |
| 19. EXTRACT.vtt |
9.18KB |
| 19. flights_db.tar |
99.10MB |
| 19. Important Problems & solutions of setting up the database.html |
5.30KB |
| 19. Solution Joining multiple tables.mp4 |
36.76MB |
| 19. Solution Joining multiple tables.vtt |
4.98KB |
| 19. Solution More challenges.mp4 |
66.33MB |
| 19. Solution More challenges.vtt |
7.96KB |
| 19. Today's slides.html |
234B |
| 2.18 Mathematical functions and operators.html |
4.41KB |
| 2. 2022-08-10_14-06-45-028cd4a57cda9324639786daf3ae607d.png |
11.90KB |
| 2. 2022-08-10_14-06-45-9481317717076af04727664bc6344aec.png |
11.18KB |
| 2. 2022-08-10_14-06-45-ba2470af10baa81827a89a554c5f57c0.png |
4.63KB |
| 2. 2022-08-10_14-06-45-ee080b7812d315118f52b676dfbfac4b.png |
21.08KB |
| 2. 2022-08-10_14-06-46-32f81b87932bc2494dfa2409327905ec.png |
25.90KB |
| 2. 2022-08-10_14-06-46-64c69bb4a9cabf9cc434a4e754dc7b93.png |
12.85KB |
| 2. 2022-08-10_14-06-46-8a896f85dd6552df023234ecbc02897b.png |
13.34KB |
| 2. 2022-08-10_14-06-46-ee4c62ade30194de367965d239f4229e.png |
17.38KB |
| 2. 2024-09-06_13-23-35-39d73910d47148cf287bb323b5c49df2.png |
14.51KB |
| 2.6 WHERE.html |
4.39KB |
| 2. Aggregate functions.mp4 |
33.66MB |
| 2. Aggregate functions.vtt |
6.96KB |
| 2. Challenge GROUPING SETS.mp4 |
3.43MB |
| 2. Challenge GROUPING SETS.vtt |
703B |
| 2. Challenge OVER() with PARTITION BY.mp4 |
10.49MB |
| 2. Challenge OVER() with PARTITION BY.vtt |
2.00KB |
| 2. Challenges.html |
5.66KB |
| 2. Challenge UPDATE.mp4 |
5.47MB |
| 2. Challenge UPDATE.vtt |
1.21KB |
| 2. Common Table Expressions (CTEs) - First Example.mp4 |
48.22MB |
| 2. Common Table Expressions (CTEs) - First Example.vtt |
7.86KB |
| 2. CREATE DATABASE.mp4 |
29.22MB |
| 2. CREATE DATABASE.vtt |
6.83KB |
| 2. CREATE USER ROLE.mp4 |
50.34MB |
| 2. CREATE USER ROLE.vtt |
9.82KB |
| 2. How to get the most out of the course.mp4 |
35.66MB |
| 2. How to get the most out of the course.vtt |
6.46KB |
| 2. INNER JOIN - Theory.mp4 |
71.31MB |
| 2. INNER JOIN - Theory.vtt |
12.09KB |
| 2. LENGTH, LOWER & UPPER.mp4 |
38.92MB |
| 2. LENGTH, LOWER & UPPER.vtt |
5.40KB |
| 2. The challenges.html |
11.22KB |
| 2. UNION - Practice.mp4 |
36.03MB |
| 2. UNION - Practice.vtt |
6.21KB |
| 2. User-defined functions - Example.mp4 |
29.08MB |
| 2. User-defined functions - Example.vtt |
6.43KB |
| 20. Challenge EXTRACT.mp4 |
9.46MB |
| 20. Challenge EXTRACT.vtt |
1.93KB |
| 20. Challenge IN.mp4 |
7.44MB |
| 20. Challenge IN.vtt |
1.53KB |
| 20. Day+3+-+Course+slides.pdf |
595.75KB |
| 20. Day 3 - Course slides.pdf |
643.66KB |
| 20. Day 7 - Course slides.pdf |
1013.38KB |
| 20. More challenges.html |
531B |
| 20. Solution CHECK.mp4 |
52.13MB |
| 20. Solution CHECK.vtt |
8.40KB |
| 20. Solution SELECT.mp4 |
27.21MB |
| 20. Solution SELECT.vtt |
4.86KB |
| 20. Today's slides.html |
370B |
| 20. Today's summary.mp4 |
14.47MB |
| 20. Today's summary.vtt |
2.89KB |
| 21. Day 9 - Course slides.pdf |
1.90MB |
| 21. ORDER BY.mp4 |
39.54MB |
| 21. ORDER BY.vtt |
6.80KB |
| 21. Solution EXTRACT.mp4 |
35.21MB |
| 21. Solution EXTRACT.vtt |
6.13KB |
| 21. Solution IN.mp4 |
15.67MB |
| 21. Solution IN.vtt |
2.73KB |
| 21. Solutions.html |
1.56KB |
| 21. Today's slides.html |
231B |
| 22.3 SELECT & ORDER BY.html |
3.95KB |
| 22. Day 6 - Course slides.pdf |
1.52MB |
| 22. LIKE.mp4 |
49.58MB |
| 22. LIKE.vtt |
7.82KB |
| 22. TO_CHAR.mp4 |
56.03MB |
| 22. TO_CHAR.vtt |
7.56KB |
| 22. Today's slides.html |
229B |
| 23.11 LIKE.html |
4.24KB |
| 23. Challenge ORDER BY.mp4 |
6.78MB |
| 23. Challenge ORDER BY.vtt |
1.43KB |
| 23. Challenge TO_CHAR.mp4 |
7.06MB |
| 23. Challenge TO_CHAR.vtt |
1.75KB |
| 24. Challenge LIKE.mp4 |
7.60MB |
| 24. Challenge LIKE.vtt |
1.75KB |
| 24. Solution ORDER BY.mp4 |
22.92MB |
| 24. Solution ORDER BY.vtt |
4.17KB |
| 24. Solution TO_CHAR.mp4 |
35.03MB |
| 24. Solution TO_CHAR.vtt |
5.05KB |
| 25. Intervals & Timestamps.mp4 |
35.06MB |
| 25. Intervals & Timestamps.vtt |
5.37KB |
| 25. SELECT DISTINCT.mp4 |
27.07MB |
| 25. SELECT DISTINCT.vtt |
4.78KB |
| 25. Solution LIKE.mp4 |
37.93MB |
| 25. Solution LIKE.vtt |
6.03KB |
| 26. Challenge Intervals & Timestamps.mp4 |
7.17MB |
| 26. Challenge Intervals & Timestamps.vtt |
1.46KB |
| 26. Challenge SELECT DISTINCT.mp4 |
5.48MB |
| 26. Challenge SELECT DISTINCT.vtt |
1.15KB |
| 26. Comments & Aliases.mp4 |
44.73MB |
| 26. Comments & Aliases.vtt |
8.13KB |
| 27. Day 2 - Course slides.pdf |
1.07MB |
| 27. Solution Intervals & Timestamps.mp4 |
11.92MB |
| 27. Solution Intervals & Timestamps.vtt |
1.68KB |
| 27. Solution SELECT DISTINCT.mp4 |
15.62MB |
| 27. Solution SELECT DISTINCT.vtt |
3.19KB |
| 27. Today's summary.mp4 |
29.15MB |
| 27. Today's summary.vtt |
5.68KB |
| 28. Day 4 - Course slides.pdf |
743.50KB |
| 28. LIMIT.mp4 |
27.83MB |
| 28. LIMIT.vtt |
4.55KB |
| 28. Today's challenges.mp4 |
37.52MB |
| 28. Today's challenges.vtt |
7.02KB |
| 28. Today's slides.html |
213B |
| 29.4 SELECT DISTINCT & LIMIT.html |
4.28KB |
| 29. Introducing Role Plays.html |
1.22KB |
| 3.12 Aggregate functions.html |
4.51KB |
| 3.16 LENGTH, LOWER & UPPER.html |
4.34KB |
| 3.22 CREATE & DROP DATABASE.html |
3.88KB |
| 3. Challenge Mathematical functions and operators.mp4 |
14.64MB |
| 3. Challenge Mathematical functions and operators.vtt |
2.30KB |
| 3. Challenge User-defined functions.mp4 |
3.81MB |
| 3. Challenge User-defined functions.vtt |
959B |
| 3. Challenge WHERE.mp4 |
5.87MB |
| 3. Challenge WHERE.vtt |
1.53KB |
| 3. Common Table Expressions - More Complex Example.mp4 |
49.00MB |
| 3. Common Table Expressions - More Complex Example.vtt |
7.34KB |
| 3. GRANT & REVOKE privileges.mp4 |
48.28MB |
| 3. GRANT & REVOKE privileges.vtt |
9.28KB |
| 3. How this course works.mp4 |
26.56MB |
| 3. How this course works.vtt |
4.80KB |
| 3. INNER JOIN - Practice.mp4 |
55.18MB |
| 3. INNER JOIN - Practice.vtt |
7.24KB |
| 3. Solution GROUPING SETS.mp4 |
12.13MB |
| 3. Solution GROUPING SETS.vtt |
2.03KB |
| 3. Solution OVER() with PARTITION BY.mp4 |
31.80MB |
| 3. Solution OVER() with PARTITION BY.vtt |
4.67KB |
| 3. Solutions.html |
5.26KB |
| 3. Solutions.html |
8.09KB |
| 3. Solution UPDATE.mp4 |
26.01MB |
| 3. Solution UPDATE.vtt |
3.79KB |
| 3. Subqueries in WHERE.mp4 |
41.32MB |
| 3. Subqueries in WHERE.vtt |
6.17KB |
| 30. COUNT().mp4 |
22.69MB |
| 30. COUNT().vtt |
5.08KB |
| 31.5 COUNT().html |
4.19KB |
| 32. Today's challenges.mp4 |
33.30MB |
| 32. Today's challenges.vtt |
7.30KB |
| 33. Day 1 - Course slides.pdf |
2.01MB |
| 33. Today's summary.mp4 |
34.35MB |
| 33. Today's summary.vtt |
5.84KB |
| 4. Additional challenge.mp4 |
4.37MB |
| 4. Additional challenge.vtt |
1.02KB |
| 4. Challenge 1 Create a simple CTE.html |
1.17KB |
| 4. Challenge Aggregate function.mp4 |
11.03MB |
| 4. Challenge Aggregate function.vtt |
2.43KB |
| 4. Challenge INNER JOIN.mp4 |
2.78MB |
| 4. Challenge INNER JOIN.vtt |
1.45KB |
| 4. Challenge LENGTH, LOWER & UPPER.mp4 |
6.16MB |
| 4. Challenge LENGTH, LOWER & UPPER.vtt |
1.33KB |
| 4. Challenge Subqueries in WHERE.mp4 |
6.80MB |
| 4. Challenge Subqueries in WHERE.vtt |
2.06KB |
| 4. Data Types.mp4 |
61.44MB |
| 4. Data Types.vtt |
11.33KB |
| 4. DELETE.mp4 |
35.73MB |
| 4. DELETE.vtt |
5.59KB |
| 4. OVER() with ORDER BY.mp4 |
48.11MB |
| 4. OVER() with ORDER BY.vtt |
6.89KB |
| 4. privileges.txt |
802B |
| 4. Privileges - Hands-on.mp4 |
68.61MB |
| 4. Privileges - Hands-on.vtt |
11.57KB |
| 4. Solution.mp4 |
32.65MB |
| 4. Solution.vtt |
6.71KB |
| 4. Solution 1.mp4 |
8.36MB |
| 4. Solution 1.vtt |
1.95KB |
| 4. Solution Mathematical functions and operators.mp4 |
27.13MB |
| 4. Solution Mathematical functions and operators.vtt |
4.34KB |
| 4. Solution WHERE.mp4 |
22.93MB |
| 4. Why learning SQL.mp4 |
26.14MB |
| 4. Why learning SQL.vtt |
5.02KB |
| 5. 2023-01-25_13-27-59-e7d43bf66057db438a7ecf26be68fc13.png |
17.31KB |
| 5. 2024-04-25_17-55-25-a0412a72cd4af374756faecf074b5312.png |
7.37KB |
| 5.3 Data Types.html |
19.12KB |
| 5. All slides.pdf |
10.11MB |
| 5. CASE WHEN - Theory.mp4 |
43.24MB |
| 5. CASE WHEN - Theory.vtt |
8.47KB |
| 5. Challenge DELETE.mp4 |
4.48MB |
| 5. Challenge DELETE.vtt |
740B |
| 5. Challenge OVER() with ORDER BY.mp4 |
7.28MB |
| 5. Challenge OVER() with ORDER BY.vtt |
1.57KB |
| 5. Challenge Privileges.html |
613B |
| 5. GROUP BY.mp4 |
33.25MB |
| 5. GROUP BY.vtt |
6.17KB |
| 5. Let the Joruney Begin!.html |
1.88KB |
| 5. Solution 1 Create a simple CTE.html |
1.09KB |
| 5. Solution 2.mp4 |
24.15MB |
| 5. Solution 2.vtt |
3.66KB |
| 5. Solution Additional Challenge.mp4 |
21.58MB |
| 5. Solution Additional Challenge.vtt |
3.13KB |
| 5. Solution INNER JOIN.html |
2.02KB |
| 5. Solution LENGTH, LOWER & UPPER.mp4 |
13.28MB |
| 5. Solution LENGTH, LOWER & UPPER.vtt |
2.21KB |
| 5. Solution Subqueries in WHERE.mp4 |
31.26MB |
| 5. Solution Subqueries in WHERE.vtt |
5.05KB |
| 5. Transactions.mp4 |
41.28MB |
| 5. TRANSACTIONS.txt |
271B |
| 5. Transactions.vtt |
7.41KB |
| 5. WHERE operators.mp4 |
29.90MB |
| 5. WHERE operators.vtt |
5.30KB |
| 6.13 GROUP BY.html |
4.65KB |
| 6.1 Let's get started!.html |
4.30KB |
| 6.7 WHERE operators.html |
4.36KB |
| 6. CASE WHEN - Hands-on.mp4 |
46.86MB |
| 6. CASE WHEN - Hands-on.vtt |
7.88KB |
| 6. Challenge_Transactions.txt |
2.84KB |
| 6. Challenge Transactions.mp4 |
4.05MB |
| 6. Challenge Transactions.vtt |
982B |
| 6. Common Table Expressions - Using Multiple CTEs.mp4 |
81.15MB |
| 6. Common Table Expressions - Using Multiple CTEs.vtt |
12.13KB |
| 6. Constraints.mp4 |
30.76MB |
| 6. Constraints.vtt |
5.76KB |
| 6. FULL OUTER JOIN.mp4 |
46.35MB |
| 6. FULL OUTER JOIN.vtt |
7.57KB |
| 6. LEFT & RIGHT.mp4 |
25.84MB |
| 6. LEFT & RIGHT.vtt |
4.58KB |
| 6. More challenges Subqueries in WHERE.mp4 |
9.18MB |
| 6. More challenges Subqueries in WHERE.vtt |
2.14KB |
| 6. ROLLUP.mp4 |
52.19MB |
| 6. ROLLUP.vtt |
9.40KB |
| 6. Solution 3.mp4 |
22.71MB |
| 6. Solution 3.vtt |
4.02KB |
| 6. Solution DELETE.mp4 |
9.41MB |
| 6. Solution DELETE.vtt |
1.65KB |
| 6. Solution OVER() with ORDER BY.mp4 |
13.43MB |
| 6. Solution OVER() with ORDER BY.vtt |
2.54KB |
| 6. Solution Privileges.html |
562B |
| 7.19 CASE WHEN.html |
5.07KB |
| 7.4 Constraints.html |
16.90KB |
| 7. Challenge 2 Using Multiple CTEs.html |
1.75KB |
| 7. Challenge GROUP BY.mp4 |
10.70MB |
| 7. Challenge GROUP BY.vtt |
2.05KB |
| 7. Challenge LEFT & RIGHT.mp4 |
6.46MB |
| 7. Challenge LEFT & RIGHT.vtt |
1.34KB |
| 7. Challenge ROLLUP.mp4 |
8.65MB |
| 7. Challenge ROLLUP.vtt |
2.16KB |
| 7. Challenge WHERE operators.mp4 |
8.10MB |
| 7. Challenge WHERE operators.vtt |
1.87KB |
| 7. CREATE TABLE AS.mp4 |
22.74MB |
| 7. CREATE TABLE AS.vtt |
3.90KB |
| 7. JOIN & WHERE.mp4 |
26.52MB |
| 7. JOIN & WHERE.vtt |
4.05KB |
| 7. RANK().mp4 |
51.87MB |
| 7. RANK().vtt |
7.75KB |
| 7. Solution 4.mp4 |
9.87MB |
| 7. Solution 4.vtt |
1.77KB |
| 7. Solution More challenges.mp4 |
40.37MB |
| 7. Solution More challenges.vtt |
6.05KB |
| 7. Solution Transactions.mp4 |
32.18MB |
| 7. Solution Transactions.vtt |
4.15KB |
| 7. What are indexes.mp4 |
33.45MB |
| 7. What are indexes.vtt |
6.51KB |
| 7. What is a database.mp4 |
20.44MB |
| 7. What is a database.vtt |
3.23KB |
| 8.1 Databases.html |
16.14KB |
| 8. 3 Challenge CASE WHEN.mp4 |
11.80MB |
| 8. 3 Challenge CASE WHEN.vtt |
5.56KB |
| 8. B-Tree index.mp4 |
22.27MB |
| 8. B-Tree index.vtt |
4.84KB |
| 8. Challenge CREATE TABLE AS.mp4 |
4.30MB |
| 8. Challenge CREATE TABLE AS.vtt |
1.02KB |
| 8. Challenge RANK().mp4 |
7.48MB |
| 8. Challenge RANK().vtt |
1.34KB |
| 8. LEFT OUTER JOIN.mp4 |
43.95MB |
| 8. LEFT OUTER JOIN.vtt |
6.29KB |
| 8. Primary Key & Foreign Key.mp4 |
30.07MB |
| 8. Primary Key & Foreign Key.vtt |
4.57KB |
| 8. Rollbacks.mp4 |
35.18MB |
| 8. Rollbacks.vtt |
6.19KB |
| 8. Solution 2 Using Multiple CTEs.html |
4.01KB |
| 8. Solution 5.mp4 |
21.49MB |
| 8. Solution 5.vtt |
2.96KB |
| 8. Solution GROUP BY.mp4 |
21.67MB |
| 8. Solution GROUP BY.vtt |
4.20KB |
| 8. Solution LEFT & RIGHT.mp4 |
14.63MB |
| 8. Solution LEFT & RIGHT.vtt |
2.34KB |
| 8. Solution ROLLUP.mp4 |
22.29MB |
| 8. Solution ROLLUP.vtt |
4.04KB |
| 8. Solution WHERE operators.mp4 |
14.51MB |
| 8. Solution WHERE operators.vtt |
2.66KB |
| 8. Subqueries in FROM.mp4 |
24.45MB |
| 8. Subqueries in FROM.vtt |
4.18KB |
| 9.5 Primary & Foreign Key.html |
17.11KB |
| 9. Bitmap index.mp4 |
23.75MB |
| 9. Bitmap index.vtt |
4.53KB |
| 9. Challenge LEFT OUTER JOIN.mp4 |
10.65MB |
| 9. Challenge LEFT OUTER JOIN.vtt |
2.63KB |
| 9. Challenge Subqueries in FROM.mp4 |
2.89MB |
| 9. Challenge Subqueries in FROM.vtt |
719B |
| 9. Concatenate.mp4 |
19.44MB |
| 9. Concatenate.vtt |
3.32KB |
| 9. CUBE.mp4 |
34.18MB |
| 9. CUBE.vtt |
5.65KB |
| 9. Different dialects of SQL.mp4 |
14.58MB |
| 9. Different dialects of SQL.vtt |
2.77KB |
| 9. GROUP BY multiple columns.mp4 |
23.30MB |
| 9. GROUP BY multiple columns.vtt |
3.66KB |
| 9. Recursive CTEs - Concept.mp4 |
35.05MB |
| 9. Recursive CTEs - Concept.vtt |
6.17KB |
| 9. Solution 6.mp4 |
22.38MB |
| 9. Solution 6.vtt |
3.17KB |
| 9. Solution CREATE TABLE AS.mp4 |
21.32MB |
| 9. Solution CREATE TABLE AS.vtt |
3.70KB |
| 9. Solution RANK().mp4 |
21.95MB |
| 9. Solution RANK().vtt |
3.17KB |
| 9. Solutions.html |
1.69KB |
| 9. Stored procedures.mp4 |
60.20MB |
| 9. Stored procedures.vtt |
11.17KB |
| 9. WHERE with ANDOR.mp4 |
48.18MB |
| 9. WHERE with ANDOR.vtt |
7.77KB |