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