Udemy - 15 Days of SQL The Complete SQL Masterclass 2025 (7.2025)

Creation Time	July 16, 2025, 6:30 a.m.
Last Access Time	July 18, 2025, 8:47 p.m.
File Size	6.4 GB
Keywords	15 Complete of Masterclass - Days Udemy 2025 7 SQL The
Total Requests	11
Total Files	586
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

03. Day 3 - Basics Grouping/19. flights_db.tar 99.1 MB
16. Extra Day CTEs (Common Table Expressions)/6. Common Table Expressions - Using Multiple CTEs.mp4 81.1 MB
06. Day 6 - Intermediate Joins/2. INNER JOIN - Theory.mp4 71.3 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. Execution plan & query performance.mp4 71.3 MB
11. Day 11 - Pro Window Functions/1. OVER() with PARTITION BY.mp4 70.9 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. Privileges - Hands-on.mp4 68.6 MB
10. Day 10 - Advanced Views & Data Manipulation/17. Import & Export.mp4 67.5 MB
07. Day 7 - Advanced UNION & Subqueries/19. Solution More challenges.mp4 66.3 MB
09. Day 9 - Advanced Managing tables & databases/4. Data Types.mp4 61.4 MB
07. Day 7 - Advanced UNION & Subqueries/14. Correlated Subqueries in WHERE.mp4 60.4 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/9. Stored procedures.mp4 60.2 MB
04. Day 4 - Intermediate Functions/22. TO_CHAR.mp4 56.0 MB
08. Day 8 - Advanced Course project/16. Solution 13.mp4 55.8 MB
06. Day 6 - Intermediate Joins/3. INNER JOIN - Practice.mp4 55.2 MB
16. Extra Day CTEs (Common Table Expressions)/10. Recursive CTEs - Hierarchical Data.mp4 54.6 MB
05. Day 5 - Intermediate Conditional Expressions/10. Solution CASE WHEN.mp4 54.5 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/12. Self joins.mp4 54.2 MB
04. Day 4 - Intermediate Functions/19. EXTRACT.mp4 53.3 MB
03. Day 3 - Basics Grouping/17. Introducing the second project.mp4 53.2 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/6. ROLLUP.mp4 52.2 MB
09. Day 9 - Advanced Managing tables & databases/20. Solution CHECK.mp4 52.1 MB
11. Day 11 - Pro Window Functions/7. RANK().mp4 51.9 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/2. CREATE USER ROLE.mp4 50.3 MB
04. Day 4 - Intermediate Functions/16. SUBSTRING.mp4 50.0 MB
08. Day 8 - Advanced Course project/1. Project Introduction.mp4 49.9 MB
05. Day 5 - Intermediate Conditional Expressions/11. CASE WHEN & SUM.mp4 49.8 MB
02. Day 2 - Basics Filtering/22. LIKE.mp4 49.6 MB
06. Day 6 - Intermediate Joins/14. Joins on multiple conditions.mp4 49.3 MB
16. Extra Day CTEs (Common Table Expressions)/3. Common Table Expressions - More Complex Example.mp4 49.0 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/11. Creating indexes.mp4 48.7 MB
07. Day 7 - Advanced UNION & Subqueries/1. UNION.mp4 48.4 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/3. GRANT & REVOKE privileges.mp4 48.3 MB
16. Extra Day CTEs (Common Table Expressions)/2. Common Table Expressions (CTEs) - First Example.mp4 48.2 MB
02. Day 2 - Basics Filtering/9. WHERE with ANDOR.mp4 48.2 MB
11. Day 11 - Pro Window Functions/4. OVER() with ORDER BY.mp4 48.1 MB
05. Day 5 - Intermediate Conditional Expressions/6. CASE WHEN - Hands-on.mp4 46.9 MB
09. Day 9 - Advanced Managing tables & databases/10. CREATE TABLE.mp4 46.6 MB
06. Day 6 - Intermediate Joins/6. FULL OUTER JOIN.mp4 46.4 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/1. GROUPING SETS.mp4 45.3 MB
02. Day 2 - Basics Filtering/26. Comments & Aliases.mp4 44.7 MB
06. Day 6 - Intermediate Joins/8. LEFT OUTER JOIN.mp4 44.0 MB
05. Day 5 - Intermediate Conditional Expressions/15. CAST.mp4 43.7 MB
05. Day 5 - Intermediate Conditional Expressions/5. CASE WHEN - Theory.mp4 43.2 MB
16. Extra Day CTEs (Common Table Expressions)/11. Recursive CTEs - Termination Condition.mp4 43.2 MB
08. Day 8 - Advanced Course project/17. Solution 14.mp4 43.0 MB
09. Day 9 - Advanced Managing tables & databases/16. Solution ALTER TABLE.mp4 42.7 MB
06. Day 6 - Intermediate Joins/17. Joining multiple tables - Practice.mp4 42.3 MB
05. Day 5 - Intermediate Conditional Expressions/1. Mathematical functions and operators.mp4 41.8 MB
07. Day 7 - Advanced UNION & Subqueries/3. Subqueries in WHERE.mp4 41.3 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. Transactions.mp4 41.3 MB
01. Day 1 - Getting started with SQL!/17. SELECT.mp4 41.0 MB
07. Day 7 - Advanced UNION & Subqueries/7. Solution More challenges.mp4 40.4 MB
06. Day 6 - Intermediate Joins/10. Solution LEFT OUTER JOIN.mp4 40.2 MB
01. Day 1 - Getting started with SQL!/13. Installing PostgreSQL & pgAdmin (MacOS).mp4 40.1 MB
10. Day 10 - Advanced Views & Data Manipulation/10. CREATE VIEW.mp4 40.0 MB
08. Day 8 - Advanced Course project/15. Solution 12.mp4 39.7 MB
01. Day 1 - Getting started with SQL!/21. ORDER BY.mp4 39.5 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/1. User-defined functions.mp4 39.3 MB
04. Day 4 - Intermediate Functions/2. LENGTH, LOWER & UPPER.mp4 38.9 MB
02. Day 2 - Basics Filtering/25. Solution LIKE.mp4 37.9 MB
02. Day 2 - Basics Filtering/28. Today's challenges.mp4 37.5 MB
02. Day 2 - Basics Filtering/14. BETWEEN.mp4 37.5 MB
04. Day 4 - Intermediate Functions/18. Solution SUBSTRING.mp4 37.2 MB
06. Day 6 - Intermediate Joins/16. Joining multiple tables.mp4 37.0 MB
06. Day 6 - Intermediate Joins/19. Solution Joining multiple tables.mp4 36.8 MB
09. Day 9 - Advanced Managing tables & databases/18. CHECK.mp4 36.0 MB
07. Day 7 - Advanced UNION & Subqueries/2. UNION - Practice.mp4 36.0 MB
10. Day 10 - Advanced Views & Data Manipulation/4. DELETE.mp4 35.7 MB
01. Day 1 - Getting started with SQL!/2. How to get the most out of the course.mp4 35.7 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/16. NATURAL JOIN.mp4 35.2 MB
04. Day 4 - Intermediate Functions/21. Solution EXTRACT.mp4 35.2 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/8. Rollbacks.mp4 35.2 MB
04. Day 4 - Intermediate Functions/25. Intervals & Timestamps.mp4 35.1 MB
16. Extra Day CTEs (Common Table Expressions)/9. Recursive CTEs - Concept.mp4 35.0 MB
04. Day 4 - Intermediate Functions/24. Solution TO_CHAR.mp4 35.0 MB
11. Day 11 - Pro Window Functions/13. Solution LEAD & LAG.mp4 34.4 MB
01. Day 1 - Getting started with SQL!/33. Today's summary.mp4 34.3 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/9. CUBE.mp4 34.2 MB
10. Day 10 - Advanced Views & Data Manipulation/13. CREATE MATERIALIZED VIEW.mp4 33.8 MB
10. Day 10 - Advanced Views & Data Manipulation/1. UPDATE.mp4 33.7 MB
03. Day 3 - Basics Grouping/2. Aggregate functions.mp4 33.7 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/7. What are indexes.mp4 33.5 MB
01. Day 1 - Getting started with SQL!/32. Today's challenges.mp4 33.3 MB
03. Day 3 - Basics Grouping/5. GROUP BY.mp4 33.3 MB
11. Day 11 - Pro Window Functions/11. LEAD & LAG.mp4 33.2 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/4. Solution.mp4 32.6 MB
06. Day 6 - Intermediate Joins/11. RIGHT OUTER JOIN.mp4 32.6 MB
09. Day 9 - Advanced Managing tables & databases/12. INSERT.mp4 32.5 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/7. Solution Transactions.mp4 32.2 MB
11. Day 11 - Pro Window Functions/3. Solution OVER() with PARTITION BY.mp4 31.8 MB
07. Day 7 - Advanced UNION & Subqueries/5. Solution Subqueries in WHERE.mp4 31.3 MB
09. Day 9 - Advanced Managing tables & databases/6. Constraints.mp4 30.8 MB
07. Day 7 - Advanced UNION & Subqueries/17. Correlated Subquery in SELECT.mp4 30.1 MB
09. Day 9 - Advanced Managing tables & databases/8. Primary Key & Foreign Key.mp4 30.1 MB
02. Day 2 - Basics Filtering/5. WHERE operators.mp4 29.9 MB
02. Day 2 - Basics Filtering/1. WHERE.mp4 29.7 MB
06. Day 6 - Intermediate Joins/13. Solution Joins.mp4 29.7 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/11. Solution Stored procedure.mp4 29.7 MB
01. Day 1 - Getting started with SQL!/14. Setting up the database.mp4 29.5 MB
09. Day 9 - Advanced Managing tables & databases/2. CREATE DATABASE.mp4 29.2 MB
02. Day 2 - Basics Filtering/27. Today's summary.mp4 29.2 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/2. User-defined functions - Example.mp4 29.1 MB
03. Day 3 - Basics Grouping/16. Solution HAVING.mp4 28.7 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/15. CROSS JOIN.mp4 28.4 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/10. Indexes - Guidelines.mp4 28.3 MB
05. Day 5 - Intermediate Conditional Expressions/18. REPLACE.mp4 27.9 MB
09. Day 9 - Advanced Managing tables & databases/17. TRUNCATE & DROP TABLE.mp4 27.9 MB
03. Day 3 - Basics Grouping/12. Solution GROUP BY multiple columns.mp4 27.9 MB
01. Day 1 - Getting started with SQL!/28. LIMIT.mp4 27.8 MB
08. Day 8 - Advanced Course project/13. Solution 10.mp4 27.4 MB
07. Day 7 - Advanced UNION & Subqueries/11. Subqueries in SELECT.mp4 27.4 MB
01. Day 1 - Getting started with SQL!/20. Solution SELECT.mp4 27.2 MB
05. Day 5 - Intermediate Conditional Expressions/4. Solution Mathematical functions and operators.mp4 27.1 MB
01. Day 1 - Getting started with SQL!/25. SELECT DISTINCT.mp4 27.1 MB
11. Day 11 - Pro Window Functions/10. FIRST_VALUE().mp4 26.6 MB
01. Day 1 - Getting started with SQL!/3. How this course works.mp4 26.6 MB
06. Day 6 - Intermediate Joins/7. JOIN & WHERE.mp4 26.5 MB
01. Day 1 - Getting started with SQL!/4. Why learning SQL.mp4 26.1 MB
10. Day 10 - Advanced Views & Data Manipulation/3. Solution UPDATE.mp4 26.0 MB
04. Day 4 - Intermediate Functions/6. LEFT & RIGHT.mp4 25.8 MB
08. Day 8 - Advanced Course project/12. Solution 9.mp4 24.9 MB
07. Day 7 - Advanced UNION & Subqueries/8. Subqueries in FROM.mp4 24.5 MB
02. Day 2 - Basics Filtering/18. IN.mp4 24.4 MB
03. Day 3 - Basics Grouping/13. HAVING.mp4 24.4 MB
05. Day 5 - Intermediate Conditional Expressions/13. COALESCE.mp4 24.4 MB
08. Day 8 - Advanced Course project/5. Solution 2.mp4 24.1 MB
04. Day 4 - Intermediate Functions/13. POSITION.mp4 24.1 MB
02. Day 2 - Basics Filtering/12. Solution WHERE with ANDOR.mp4 23.8 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/9. Bitmap index.mp4 23.7 MB
03. Day 3 - Basics Grouping/9. GROUP BY multiple columns.mp4 23.3 MB
02. Day 2 - Basics Filtering/4. Solution WHERE.mp4 22.9 MB
01. Day 1 - Getting started with SQL!/24. Solution ORDER BY.mp4 22.9 MB
09. Day 9 - Advanced Managing tables & databases/1. Managing databases & tables.mp4 22.8 MB
10. Day 10 - Advanced Views & Data Manipulation/7. CREATE TABLE AS.mp4 22.7 MB
01. Day 1 - Getting started with SQL!/16. The Project.mp4 22.7 MB
08. Day 8 - Advanced Course project/6. Solution 3.mp4 22.7 MB
01. Day 1 - Getting started with SQL!/30. COUNT().mp4 22.7 MB
08. Day 8 - Advanced Course project/9. Solution 6.mp4 22.4 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/8. Solution ROLLUP.mp4 22.3 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/8. B-Tree index.mp4 22.3 MB
11. Day 11 - Pro Window Functions/9. Solution RANK().mp4 22.0 MB
03. Day 3 - Basics Grouping/8. Solution GROUP BY.mp4 21.7 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/5. Solution Additional Challenge.mp4 21.6 MB
03. Day 3 - Basics Grouping/17. flight_database.zip 21.5 MB
08. Day 8 - Advanced Course project/8. Solution 5.mp4 21.5 MB
10. Day 10 - Advanced Views & Data Manipulation/9. Solution CREATE TABLE AS.mp4 21.3 MB
06. Day 6 - Intermediate Joins/1. What are joins.mp4 21.1 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/1. User management.mp4 20.7 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/14. Solution Self joins.mp4 20.7 MB
01. Day 1 - Getting started with SQL!/7. What is a database.mp4 20.4 MB
01. Day 1 - Getting started with SQL!/1. Welcome!.mp4 20.4 MB
08. Day 8 - Advanced Course project/10. Solution 7.mp4 19.7 MB
04. Day 4 - Intermediate Functions/9. Concatenate.mp4 19.4 MB
08. Day 8 - Advanced Course project/14. Solution 11.mp4 19.4 MB
09. Day 9 - Advanced Managing tables & databases/14. ALTER TABLE.mp4 18.9 MB
07. Day 7 - Advanced UNION & Subqueries/16. Solution Correlated subqueries in WHERE.mp4 18.7 MB
02. Day 2 - Basics Filtering/17. Solution BETWEEN.mp4 18.5 MB
03. Day 3 - Basics Grouping/15. Challenge HAVING.mp4 18.3 MB
03. Day 3 - Basics Grouping/11. Challenge GROUP BY multiple columns.mp4 17.6 MB
04. Day 4 - Intermediate Functions/15. Solution POSITION.mp4 17.5 MB
10. Day 10 - Advanced Views & Data Manipulation/14. Managing views.mp4 17.0 MB
09. Day 9 - Advanced Managing tables & databases/15. Challenge ALTER TABLE.mp4 16.7 MB
07. Day 7 - Advanced UNION & Subqueries/18. More challenges Correlated subqueres.mp4 16.4 MB
02. Day 2 - Basics Filtering/21. Solution IN.mp4 15.7 MB
01. Day 1 - Getting started with SQL!/27. Solution SELECT DISTINCT.mp4 15.6 MB
07. Day 7 - Advanced UNION & Subqueries/10. Solution Subqueries in FROM.mp4 15.1 MB
05. Day 5 - Intermediate Conditional Expressions/3. Challenge Mathematical functions and operators.mp4 14.6 MB
04. Day 4 - Intermediate Functions/8. Solution LEFT & RIGHT.mp4 14.6 MB
01. Day 1 - Getting started with SQL!/9. Different dialects of SQL.mp4 14.6 MB
02. Day 2 - Basics Filtering/8. Solution WHERE operators.mp4 14.5 MB
03. Day 3 - Basics Grouping/20. Today's summary.mp4 14.5 MB
06. Day 6 - Intermediate Joins/15. Solution Joins on multiple conditions.mp4 14.0 MB
11. Day 11 - Pro Window Functions/6. Solution OVER() with ORDER BY.mp4 13.4 MB
04. Day 4 - Intermediate Functions/12. Solution Concatenate.mp4 13.3 MB
04. Day 4 - Intermediate Functions/5. Solution LENGTH, LOWER & UPPER.mp4 13.3 MB
09. Day 9 - Advanced Managing tables & databases/19. Challenge CHECK.mp4 13.0 MB
04. Day 4 - Intermediate Functions/1. Today's plan.mp4 12.5 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/3. Solution GROUPING SETS.mp4 12.1 MB
08. Day 8 - Advanced Course project/11. Solution 8.mp4 12.1 MB
04. Day 4 - Intermediate Functions/27. Solution Intervals & Timestamps.mp4 11.9 MB
05. Day 5 - Intermediate Conditional Expressions/8. 3 Challenge CASE WHEN.mp4 11.8 MB
05. Day 5 - Intermediate Conditional Expressions/17. Solution CAST & COALESCE.mp4 11.5 MB
01. Day 1 - Getting started with SQL!/11. Installing PostgreSQL & pgAdmin (Windows).mp4 11.3 MB
03. Day 3 - Basics Grouping/4. Challenge Aggregate function.mp4 11.0 MB
07. Day 7 - Advanced UNION & Subqueries/13. Solution Subqueries in SELECT.mp4 11.0 MB
03. Day 3 - Basics Grouping/7. Challenge GROUP BY.mp4 10.7 MB
06. Day 6 - Intermediate Joins/9. Challenge LEFT OUTER JOIN.mp4 10.6 MB
11. Day 11 - Pro Window Functions/2. Challenge OVER() with PARTITION BY.mp4 10.5 MB
01. Day 1 - Getting started with SQL!/5. All slides.pdf 10.1 MB
08. Day 8 - Advanced Course project/7. Solution 4.mp4 9.9 MB
04. Day 4 - Intermediate Functions/20. Challenge EXTRACT.mp4 9.5 MB
03. Day 3 - Basics Grouping/1. Today's plan.mp4 9.4 MB
10. Day 10 - Advanced Views & Data Manipulation/6. Solution DELETE.mp4 9.4 MB
02. Day 2 - Basics Filtering/11. Challenge WHERE with ANDOR.mp4 9.3 MB
07. Day 7 - Advanced UNION & Subqueries/6. More challenges Subqueries in WHERE.mp4 9.2 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/7. Challenge ROLLUP.mp4 8.7 MB
08. Day 8 - Advanced Course project/4. Solution 1.mp4 8.4 MB
04. Day 4 - Intermediate Functions/14. Challenge POSITION.mp4 8.3 MB
02. Day 2 - Basics Filtering/7. Challenge WHERE operators.mp4 8.1 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/10. Challenge Stored procedures.mp4 8.0 MB
05. Day 5 - Intermediate Conditional Expressions/16. Challenge CAST & COALESCE.mp4 7.8 MB
06. Day 6 - Intermediate Joins/12. Challenge Joins.mp4 7.7 MB
02. Day 2 - Basics Filtering/24. Challenge LIKE.mp4 7.6 MB
11. Day 11 - Pro Window Functions/8. Challenge RANK().mp4 7.5 MB
02. Day 2 - Basics Filtering/20. Challenge IN.mp4 7.4 MB
11. Day 11 - Pro Window Functions/5. Challenge OVER() with ORDER BY.mp4 7.3 MB
04. Day 4 - Intermediate Functions/11. Challenge Concatenate.mp4 7.2 MB
04. Day 4 - Intermediate Functions/17. Challenge SUBSTRING.mp4 7.2 MB
04. Day 4 - Intermediate Functions/26. Challenge Intervals & Timestamps.mp4 7.2 MB
04. Day 4 - Intermediate Functions/23. Challenge TO_CHAR.mp4 7.1 MB
01. Day 1 - Getting started with SQL!/19. Challenge SELECT.mp4 6.9 MB
07. Day 7 - Advanced UNION & Subqueries/4. Challenge Subqueries in WHERE.mp4 6.8 MB
01. Day 1 - Getting started with SQL!/23. Challenge ORDER BY.mp4 6.8 MB
04. Day 4 - Intermediate Functions/7. Challenge LEFT & RIGHT.mp4 6.5 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/13. Challenge Self joins.mp4 6.2 MB
07. Day 7 - Advanced UNION & Subqueries/15. Challenge Correlated subqueries in WHERE.mp4 6.2 MB
04. Day 4 - Intermediate Functions/4. Challenge LENGTH, LOWER & UPPER.mp4 6.2 MB
11. Day 11 - Pro Window Functions/12. Challenge LEAD & LAG.mp4 6.1 MB
02. Day 2 - Basics Filtering/3. Challenge WHERE.mp4 5.9 MB
01. Day 1 - Getting started with SQL!/26. Challenge SELECT DISTINCT.mp4 5.5 MB
10. Day 10 - Advanced Views & Data Manipulation/2. Challenge UPDATE.mp4 5.5 MB
02. Day 2 - Basics Filtering/16. Challenge BETWEEN.mp4 5.0 MB
10. Day 10 - Advanced Views & Data Manipulation/5. Challenge DELETE.mp4 4.5 MB
07. Day 7 - Advanced UNION & Subqueries/12. Challenge Subqueries in SELECT.mp4 4.4 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/4. Additional challenge.mp4 4.4 MB
10. Day 10 - Advanced Views & Data Manipulation/8. Challenge CREATE TABLE AS.mp4 4.3 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge Transactions.mp4 4.0 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/3. Challenge User-defined functions.mp4 3.8 MB
06. Day 6 - Intermediate Joins/18. Challenge Joining multiple tables.mp4 3.8 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/2. Challenge GROUPING SETS.mp4 3.4 MB
07. Day 7 - Advanced UNION & Subqueries/9. Challenge Subqueries in FROM.mp4 2.9 MB
06. Day 6 - Intermediate Joins/4. Challenge INNER JOIN.mp4 2.8 MB
01. Day 1 - Getting started with SQL!/33. Day 1 - Course slides.pdf 2.0 MB
09. Day 9 - Advanced Managing tables & databases/21. Day 9 - Course slides.pdf 1.9 MB
17. Bonus/1. 2024-01-30_07-17-50-21a899f2574db3ff4baf37d9f163de3b.JPG 1.9 MB
06. Day 6 - Intermediate Joins/22. Day 6 - Course slides.pdf 1.5 MB
02. Day 2 - Basics Filtering/27. Day 2 - Course slides.pdf 1.1 MB
07. Day 7 - Advanced UNION & Subqueries/20. Day 7 - Course slides.pdf 1013.4 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/14. Day 15 - Course slides.pdf 989.5 KB
10. Day 10 - Advanced Views & Data Manipulation/18. Day 10 - Course slides.pdf 870.7 KB
04. Day 4 - Intermediate Functions/28. Day 4 - Course slides.pdf 743.5 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/12. Day 14 - Course slides.pdf 737.5 KB
05. Day 5 - Intermediate Conditional Expressions/19. Day 5 - Course slides.pdf 732.8 KB
11. Day 11 - Pro Window Functions/14. Day 11 - Course slides.pdf 711.2 KB
01. Day 1 - Getting started with SQL!/14. pagila-master.zip 685.2 KB
03. Day 3 - Basics Grouping/20. Day 3 - Course slides.pdf 643.7 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/17. Day 12 - Course slides.pdf 612.8 KB
03. Day 3 - Basics Grouping/20. Day+3+-+Course+slides.pdf 595.8 KB
03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-c8c2d4a3e9d240953b0585f660bf5ed7.png 187.4 KB
01. Day 1 - Getting started with SQL!/12. 2022-09-07_12-34-54-f40c284ed636467884ba52a6ee9bbf2f.png 145.3 KB
03. Day 3 - Basics Grouping/17. ER_diagram_flights_db.png 120.0 KB
03. Day 3 - Basics Grouping/19. 2022-09-07_12-34-54-f40c284ed636467884ba52a6ee9bbf2f.png 109.2 KB
01. Day 1 - Getting started with SQL!/12. 2022-09-07_12-34-54-47e1ca5d3ee08b5851605849314610d7.png 108.2 KB
03. Day 3 - Basics Grouping/19. 2022-09-07_12-34-54-47e1ca5d3ee08b5851605849314610d7.png 108.2 KB
03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-a411ee5247b6632ddfb1b3da53c01260.png 107.8 KB
10. Day 10 - Advanced Views & Data Manipulation/17. Fact_sales.csv 71.9 KB
01. Day 1 - Getting started with SQL!/12. 2022-09-07_12-34-53-bb78b2cd840131afea3195bf697ca8d0.png 57.6 KB
03. Day 3 - Basics Grouping/19. 2022-09-07_12-34-53-bb78b2cd840131afea3195bf697ca8d0.png 57.6 KB
02. Day 2 - Basics Filtering/13. 2022-09-07_11-07-05-c83708a81bbc36ecd09c1bbf0156166f.png 34.6 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-32f81b87932bc2494dfa2409327905ec.png 25.9 KB
03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-38-393c5817c6c2e54ca675401a577ff453.png 22.0 KB
03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-38-4c4330adbefe30a33a830eaf96a80297.png 21.9 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-ee080b7812d315118f52b676dfbfac4b.png 21.1 KB
09. Day 9 - Advanced Managing tables & databases/5.3 Data Types.html 19.1 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/10. 2022-08-09_08-58-09-0c0e6114b042ff98a9e83a6e10f82d8e.png 18.5 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-ee4c62ade30194de367965d239f4229e.png 17.4 KB
01. Day 1 - Getting started with SQL!/5. 2023-01-25_13-27-59-e7d43bf66057db438a7ecf26be68fc13.png 17.3 KB
09. Day 9 - Advanced Managing tables & databases/9.5 Primary & Foreign Key.html 17.1 KB
01. Day 1 - Getting started with SQL!/10.2 Dialects of SQL.html 17.1 KB
09. Day 9 - Advanced Managing tables & databases/7.4 Constraints.html 16.9 KB
03. Day 3 - Basics Grouping/19. 2022-09-07_13-34-16-83c120d05b6098b20fd4fb5dfb4cf3ae.png 16.4 KB
01. Day 1 - Getting started with SQL!/8.1 Databases.html 16.1 KB
13. Day 13 - Pro Course project/2. 2024-09-06_13-23-35-39d73910d47148cf287bb323b5c49df2.png 14.5 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-8a896f85dd6552df023234ecbc02897b.png 13.3 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-64c69bb4a9cabf9cc434a4e754dc7b93.png 12.8 KB
16. Extra Day CTEs (Common Table Expressions)/6. Common Table Expressions - Using Multiple CTEs.vtt 12.1 KB
06. Day 6 - Intermediate Joins/2. INNER JOIN - Theory.vtt 12.1 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-028cd4a57cda9324639786daf3ae607d.png 11.9 KB
16. Extra Day CTEs (Common Table Expressions)/1. 2024-06-04_10-51-42-bc9ad906edace8d58aac839f7e56ed5d.png 11.7 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. Execution plan & query performance.vtt 11.6 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. Privileges - Hands-on.vtt 11.6 KB
09. Day 9 - Advanced Managing tables & databases/4. Data Types.vtt 11.3 KB
03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-f733bcd44e44ef1d146fa360213c636c.png 11.3 KB
13. Day 13 - Pro Course project/2. The challenges.html 11.2 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-9481317717076af04727664bc6344aec.png 11.2 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/9. Stored procedures.vtt 11.2 KB
03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-1859562130e2741dc2e211f525fac2cd.png 10.6 KB
11. Day 11 - Pro Window Functions/1. OVER() with PARTITION BY.vtt 10.5 KB
03. Day 3 - Basics Grouping/17. Introducing the second project.vtt 10.1 KB
10. Day 10 - Advanced Views & Data Manipulation/17. Import & Export.vtt 9.9 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/11. Solution Stored procedure.vtt 9.9 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/2. CREATE USER ROLE.vtt 9.8 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/6. ROLLUP.vtt 9.4 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/3. GRANT & REVOKE privileges.vtt 9.3 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/12. Self joins.vtt 9.2 KB
04. Day 4 - Intermediate Functions/19. EXTRACT.vtt 9.2 KB
16. Extra Day CTEs (Common Table Expressions)/10. Recursive CTEs - Hierarchical Data.vtt 9.0 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/11. Creating indexes.vtt 9.0 KB
08. Day 8 - Advanced Course project/1. Project Introduction.vtt 8.7 KB
08. Day 8 - Advanced Course project/16. Solution 13.vtt 8.7 KB
09. Day 9 - Advanced Managing tables & databases/10. CREATE TABLE.vtt 8.6 KB
05. Day 5 - Intermediate Conditional Expressions/5. CASE WHEN - Theory.vtt 8.5 KB
01. Day 1 - Getting started with SQL!/11. Installing PostgreSQL & pgAdmin (Windows).vtt 8.4 KB
07. Day 7 - Advanced UNION & Subqueries/14. Correlated Subqueries in WHERE.vtt 8.4 KB
05. Day 5 - Intermediate Conditional Expressions/10. Solution CASE WHEN.vtt 8.4 KB
09. Day 9 - Advanced Managing tables & databases/20. Solution CHECK.vtt 8.4 KB
04. Day 4 - Intermediate Functions/16. SUBSTRING.vtt 8.3 KB
02. Day 2 - Basics Filtering/26. Comments & Aliases.vtt 8.1 KB
13. Day 13 - Pro Course project/3. Solutions.html 8.1 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/1. User-defined functions.vtt 8.0 KB
05. Day 5 - Intermediate Conditional Expressions/11. CASE WHEN & SUM.vtt 8.0 KB
07. Day 7 - Advanced UNION & Subqueries/19. Solution More challenges.vtt 8.0 KB
01. Day 1 - Getting started with SQL!/17. SELECT.vtt 7.9 KB
05. Day 5 - Intermediate Conditional Expressions/6. CASE WHEN - Hands-on.vtt 7.9 KB
16. Extra Day CTEs (Common Table Expressions)/2. Common Table Expressions (CTEs) - First Example.vtt 7.9 KB
02. Day 2 - Basics Filtering/22. LIKE.vtt 7.8 KB
02. Day 2 - Basics Filtering/9. WHERE with ANDOR.vtt 7.8 KB
11. Day 11 - Pro Window Functions/7. RANK().vtt 7.7 KB
06. Day 6 - Intermediate Joins/6. FULL OUTER JOIN.vtt 7.6 KB
04. Day 4 - Intermediate Functions/22. TO_CHAR.vtt 7.6 KB
06. Day 6 - Intermediate Joins/14. Joins on multiple conditions.vtt 7.5 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. Transactions.vtt 7.4 KB
06. Day 6 - Intermediate Joins/5. 2024-04-25_17-55-25-a0412a72cd4af374756faecf074b5312.png 7.4 KB
16. Extra Day CTEs (Common Table Expressions)/3. Common Table Expressions - More Complex Example.vtt 7.3 KB
07. Day 7 - Advanced UNION & Subqueries/1. UNION.vtt 7.3 KB
01. Day 1 - Getting started with SQL!/32. Today's challenges.vtt 7.3 KB
05. Day 5 - Intermediate Conditional Expressions/1. Mathematical functions and operators.vtt 7.3 KB
06. Day 6 - Intermediate Joins/3. INNER JOIN - Practice.vtt 7.2 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/1. GROUPING SETS.vtt 7.2 KB
05. Day 5 - Intermediate Conditional Expressions/15. CAST.vtt 7.1 KB
02. Day 2 - Basics Filtering/28. Today's challenges.vtt 7.0 KB
03. Day 3 - Basics Grouping/2. Aggregate functions.vtt 7.0 KB
06. Day 6 - Intermediate Joins/10. Solution LEFT OUTER JOIN.vtt 6.9 KB
17. Bonus/1. Bonus.html 6.9 KB
01. Day 1 - Getting started with SQL!/14. Setting up the database.vtt 6.9 KB
11. Day 11 - Pro Window Functions/4. OVER() with ORDER BY.vtt 6.9 KB
09. Day 9 - Advanced Managing tables & databases/2. CREATE DATABASE.vtt 6.8 KB
01. Day 1 - Getting started with SQL!/21. ORDER BY.vtt 6.8 KB
08. Day 8 - Advanced Course project/17. Solution 14.vtt 6.8 KB
03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-23459267be87bc20d358592f88bf352a.png 6.8 KB
04. Day 4 - Intermediate Functions/18. Solution SUBSTRING.vtt 6.8 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/4. Solution.vtt 6.7 KB
10. Day 10 - Advanced Views & Data Manipulation/10. CREATE VIEW.vtt 6.7 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/7. What are indexes.vtt 6.5 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/16. NATURAL JOIN.vtt 6.5 KB
01. Day 1 - Getting started with SQL!/2. How to get the most out of the course.vtt 6.5 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/2. User-defined functions - Example.vtt 6.4 KB
04. Day 4 - Intermediate Functions/10.17 Concatenate.html 6.3 KB
06. Day 6 - Intermediate Joins/8. LEFT OUTER JOIN.vtt 6.3 KB
09. Day 9 - Advanced Managing tables & databases/18. CHECK.vtt 6.2 KB
07. Day 7 - Advanced UNION & Subqueries/2. UNION - Practice.vtt 6.2 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/8. Rollbacks.vtt 6.2 KB
09. Day 9 - Advanced Managing tables & databases/14. ALTER TABLE.vtt 6.2 KB
07. Day 7 - Advanced UNION & Subqueries/3. Subqueries in WHERE.vtt 6.2 KB
03. Day 3 - Basics Grouping/5. GROUP BY.vtt 6.2 KB
16. Extra Day CTEs (Common Table Expressions)/9. Recursive CTEs - Concept.vtt 6.2 KB
16. Extra Day CTEs (Common Table Expressions)/11. Recursive CTEs - Termination Condition.vtt 6.2 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/10. Indexes - Guidelines.vtt 6.2 KB
02. Day 2 - Basics Filtering/1. WHERE.vtt 6.1 KB
04. Day 4 - Intermediate Functions/21. Solution EXTRACT.vtt 6.1 KB
07. Day 7 - Advanced UNION & Subqueries/7. Solution More challenges.vtt 6.0 KB
08. Day 8 - Advanced Course project/15. Solution 12.vtt 6.0 KB
02. Day 2 - Basics Filtering/25. Solution LIKE.vtt 6.0 KB
09. Day 9 - Advanced Managing tables & databases/16. Solution ALTER TABLE.vtt 6.0 KB
01. Day 1 - Getting started with SQL!/33. Today's summary.vtt 5.8 KB
06. Day 6 - Intermediate Joins/16. Joining multiple tables.vtt 5.8 KB
09. Day 9 - Advanced Managing tables & databases/12. INSERT.vtt 5.8 KB
09. Day 9 - Advanced Managing tables & databases/6. Constraints.vtt 5.8 KB
06. Day 6 - Intermediate Joins/17. Joining multiple tables - Practice.vtt 5.7 KB
02. Day 2 - Basics Filtering/27. Today's summary.vtt 5.7 KB
08. Day 8 - Advanced Course project/2. Challenges.html 5.7 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/9. CUBE.vtt 5.7 KB
10. Day 10 - Advanced Views & Data Manipulation/4. DELETE.vtt 5.6 KB
05. Day 5 - Intermediate Conditional Expressions/8. 3 Challenge CASE WHEN.vtt 5.6 KB
09. Day 9 - Advanced Managing tables & databases/17. TRUNCATE & DROP TABLE.vtt 5.5 KB
10. Day 10 - Advanced Views & Data Manipulation/1. UPDATE.vtt 5.5 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/15. CROSS JOIN.vtt 5.4 KB
04. Day 4 - Intermediate Functions/2. LENGTH, LOWER & UPPER.vtt 5.4 KB
04. Day 4 - Intermediate Functions/25. Intervals & Timestamps.vtt 5.4 KB
01. Day 1 - Getting started with SQL!/13. Installing PostgreSQL & pgAdmin (MacOS).vtt 5.4 KB
02. Day 2 - Basics Filtering/5. WHERE operators.vtt 5.3 KB
03. Day 3 - Basics Grouping/19. Important Problems & solutions of setting up the database.html 5.3 KB
02. Day 2 - Basics Filtering/14. BETWEEN.vtt 5.3 KB
08. Day 8 - Advanced Course project/3. Solutions.html 5.3 KB
10. Day 10 - Advanced Views & Data Manipulation/13. CREATE MATERIALIZED VIEW.vtt 5.2 KB
01. Day 1 - Getting started with SQL!/30. COUNT().vtt 5.1 KB
05. Day 5 - Intermediate Conditional Expressions/7.19 CASE WHEN.html 5.1 KB
04. Day 4 - Intermediate Functions/24. Solution TO_CHAR.vtt 5.0 KB
07. Day 7 - Advanced UNION & Subqueries/5. Solution Subqueries in WHERE.vtt 5.0 KB
01. Day 1 - Getting started with SQL!/4. Why learning SQL.vtt 5.0 KB
06. Day 6 - Intermediate Joins/19. Solution Joining multiple tables.vtt 5.0 KB
01. Day 1 - Getting started with SQL!/15. 2022-09-07_13-19-43-87939fa943016dfbe8f793fe1eccec7f.png 4.9 KB
01. Day 1 - Getting started with SQL!/20. Solution SELECT.vtt 4.9 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/8. B-Tree index.vtt 4.8 KB
01. Day 1 - Getting started with SQL!/3. How this course works.vtt 4.8 KB
08. Day 8 - Advanced Course project/13. Solution 10.vtt 4.8 KB
01. Day 1 - Getting started with SQL!/25. SELECT DISTINCT.vtt 4.8 KB
05. Day 5 - Intermediate Conditional Expressions/12.20 CASE WHEN & SUM.html 4.7 KB
06. Day 6 - Intermediate Joins/11. RIGHT OUTER JOIN.vtt 4.7 KB
11. Day 11 - Pro Window Functions/3. Solution OVER() with PARTITION BY.vtt 4.7 KB
05. Day 5 - Intermediate Conditional Expressions/14.21 COALESCE.html 4.7 KB
03. Day 3 - Basics Grouping/6.13 GROUP BY.html 4.7 KB
13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-ba2470af10baa81827a89a554c5f57c0.png 4.6 KB
05. Day 5 - Intermediate Conditional Expressions/13. COALESCE.vtt 4.6 KB
03. Day 3 - Basics Grouping/16. Solution HAVING.vtt 4.6 KB
11. Day 11 - Pro Window Functions/11. LEAD & LAG.vtt 4.6 KB
04. Day 4 - Intermediate Functions/6. LEFT & RIGHT.vtt 4.6 KB
09. Day 9 - Advanced Managing tables & databases/8. Primary Key & Foreign Key.vtt 4.6 KB
01. Day 1 - Getting started with SQL!/28. LIMIT.vtt 4.6 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/9. Bitmap index.vtt 4.5 KB
03. Day 3 - Basics Grouping/3.12 Aggregate functions.html 4.5 KB
05. Day 5 - Intermediate Conditional Expressions/18. REPLACE.vtt 4.5 KB
11. Day 11 - Pro Window Functions/13. Solution LEAD & LAG.vtt 4.5 KB
03. Day 3 - Basics Grouping/10.14 GROUP BY multiple columns.html 4.4 KB
02. Day 2 - Basics Filtering/10.8 WHERE with ANDOR.html 4.4 KB
08. Day 8 - Advanced Course project/12. Solution 9.vtt 4.4 KB
05. Day 5 - Intermediate Conditional Expressions/2.18 Mathematical functions and operators.html 4.4 KB
02. Day 2 - Basics Filtering/2.6 WHERE.html 4.4 KB
02. Day 2 - Basics Filtering/6.7 WHERE operators.html 4.4 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/1. User management.vtt 4.4 KB
04. Day 4 - Intermediate Functions/3.16 LENGTH, LOWER & UPPER.html 4.3 KB
05. Day 5 - Intermediate Conditional Expressions/4. Solution Mathematical functions and operators.vtt 4.3 KB
01. Day 1 - Getting started with SQL!/6.1 Let's get started!.html 4.3 KB
09. Day 9 - Advanced Managing tables & databases/1. Managing databases & tables.vtt 4.3 KB
01. Day 1 - Getting started with SQL!/29.4 SELECT DISTINCT & LIMIT.html 4.3 KB
03. Day 3 - Basics Grouping/14.15 HAVING.html 4.3 KB
02. Day 2 - Basics Filtering/23.11 LIKE.html 4.2 KB
03. Day 3 - Basics Grouping/8. Solution GROUP BY.vtt 4.2 KB
01. Day 1 - Getting started with SQL!/31.5 COUNT().html 4.2 KB
02. Day 2 - Basics Filtering/15.9 BETWEEN.html 4.2 KB
07. Day 7 - Advanced UNION & Subqueries/8. Subqueries in FROM.vtt 4.2 KB
01. Day 1 - Getting started with SQL!/24. Solution ORDER BY.vtt 4.2 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/7. Solution Transactions.vtt 4.1 KB
03. Day 3 - Basics Grouping/12. Solution GROUP BY multiple columns.vtt 4.1 KB
03. Day 3 - Basics Grouping/13. HAVING.vtt 4.1 KB
02. Day 2 - Basics Filtering/19.10 IN operator.html 4.1 KB
06. Day 6 - Intermediate Joins/7. JOIN & WHERE.vtt 4.0 KB
07. Day 7 - Advanced UNION & Subqueries/17. Correlated Subquery in SELECT.vtt 4.0 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/8. Solution ROLLUP.vtt 4.0 KB
06. Day 6 - Intermediate Joins/13. Solution Joins.vtt 4.0 KB
08. Day 8 - Advanced Course project/6. Solution 3.vtt 4.0 KB
02. Day 2 - Basics Filtering/18. IN.vtt 4.0 KB
16. Extra Day CTEs (Common Table Expressions)/8. Solution 2 Using Multiple CTEs.html 4.0 KB
07. Day 7 - Advanced UNION & Subqueries/11. Subqueries in SELECT.vtt 4.0 KB
01. Day 1 - Getting started with SQL!/18.2 SELECT.html 4.0 KB
01. Day 1 - Getting started with SQL!/22.3 SELECT & ORDER BY.html 4.0 KB
10. Day 10 - Advanced Views & Data Manipulation/7. CREATE TABLE AS.vtt 3.9 KB
09. Day 9 - Advanced Managing tables & databases/3.22 CREATE & DROP DATABASE.html 3.9 KB
04. Day 4 - Intermediate Functions/13. POSITION.vtt 3.9 KB
07. Day 7 - Advanced UNION & Subqueries/18. More challenges Correlated subqueres.vtt 3.9 KB
10. Day 10 - Advanced Views & Data Manipulation/3. Solution UPDATE.vtt 3.8 KB
06. Day 6 - Intermediate Joins/1. What are joins.vtt 3.8 KB
10. Day 10 - Advanced Views & Data Manipulation/9. Solution CREATE TABLE AS.vtt 3.7 KB
01. Day 1 - Getting started with SQL!/1. Welcome!.vtt 3.7 KB
03. Day 3 - Basics Grouping/9. GROUP BY multiple columns.vtt 3.7 KB
08. Day 8 - Advanced Course project/5. Solution 2.vtt 3.7 KB
11. Day 11 - Pro Window Functions/10. FIRST_VALUE().vtt 3.7 KB
02. Day 2 - Basics Filtering/12. Solution WHERE with ANDOR.vtt 3.6 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/14. Solution Self joins.vtt 3.6 KB
09. Day 9 - Advanced Managing tables & databases/13.2 Assignment-INSERT.html 3.6 KB
09. Day 9 - Advanced Managing tables & databases/11.1 Assignment-CREATE TABLE.html 3.5 KB
10. Day 10 - Advanced Views & Data Manipulation/14. Managing views.vtt 3.4 KB
03. Day 3 - Basics Grouping/15. Challenge HAVING.vtt 3.4 KB
04. Day 4 - Intermediate Functions/9. Concatenate.vtt 3.3 KB
08. Day 8 - Advanced Course project/14. Solution 11.vtt 3.3 KB
08. Day 8 - Advanced Course project/10. Solution 7.vtt 3.3 KB
01. Day 1 - Getting started with SQL!/7. What is a database.vtt 3.2 KB
01. Day 1 - Getting started with SQL!/27. Solution SELECT DISTINCT.vtt 3.2 KB
08. Day 8 - Advanced Course project/9. Solution 6.vtt 3.2 KB
02. Day 2 - Basics Filtering/17. Solution BETWEEN.vtt 3.2 KB
11. Day 11 - Pro Window Functions/9. Solution RANK().vtt 3.2 KB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/12.3 Assignment-Creating indexes.html 3.2 KB
03. Day 3 - Basics Grouping/11. Challenge GROUP BY multiple columns.vtt 3.2 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/5. Solution Additional Challenge.vtt 3.1 KB
07. Day 7 - Advanced UNION & Subqueries/16. Solution Correlated subqueries in WHERE.vtt 3.0 KB
01. Day 1 - Getting started with SQL!/16. The Project.vtt 3.0 KB
08. Day 8 - Advanced Course project/8. Solution 5.vtt 3.0 KB
04. Day 4 - Intermediate Functions/15. Solution POSITION.vtt 2.9 KB
03. Day 3 - Basics Grouping/20. Today's summary.vtt 2.9 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge_Transactions.txt 2.8 KB
01. Day 1 - Getting started with SQL!/9. Different dialects of SQL.vtt 2.8 KB
02. Day 2 - Basics Filtering/21. Solution IN.vtt 2.7 KB
02. Day 2 - Basics Filtering/8. Solution WHERE operators.vtt 2.7 KB
06. Day 6 - Intermediate Joins/9. Challenge LEFT OUTER JOIN.vtt 2.6 KB
04. Day 4 - Intermediate Functions/12. Solution Concatenate.vtt 2.6 KB
11. Day 11 - Pro Window Functions/6. Solution OVER() with ORDER BY.vtt 2.5 KB
03. Day 3 - Basics Grouping/4. Challenge Aggregate function.vtt 2.4 KB
07. Day 7 - Advanced UNION & Subqueries/10. Solution Subqueries in FROM.vtt 2.4 KB
09. Day 9 - Advanced Managing tables & databases/15. Challenge ALTER TABLE.vtt 2.4 KB
04. Day 4 - Intermediate Functions/8. Solution LEFT & RIGHT.vtt 2.3 KB
05. Day 5 - Intermediate Conditional Expressions/3. Challenge Mathematical functions and operators.vtt 2.3 KB
09. Day 9 - Advanced Managing tables & databases/19. Challenge CHECK.vtt 2.3 KB
04. Day 4 - Intermediate Functions/5. Solution LENGTH, LOWER & UPPER.vtt 2.2 KB
08. Day 8 - Advanced Course project/11. Solution 8.vtt 2.2 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/7. Challenge ROLLUP.vtt 2.2 KB
07. Day 7 - Advanced UNION & Subqueries/6. More challenges Subqueries in WHERE.vtt 2.1 KB
07. Day 7 - Advanced UNION & Subqueries/4. Challenge Subqueries in WHERE.vtt 2.1 KB
03. Day 3 - Basics Grouping/7. Challenge GROUP BY.vtt 2.1 KB
06. Day 6 - Intermediate Joins/15. Solution Joins on multiple conditions.vtt 2.0 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/3. Solution GROUPING SETS.vtt 2.0 KB
06. Day 6 - Intermediate Joins/5. Solution INNER JOIN.html 2.0 KB
11. Day 11 - Pro Window Functions/2. Challenge OVER() with PARTITION BY.vtt 2.0 KB
08. Day 8 - Advanced Course project/4. Solution 1.vtt 2.0 KB
04. Day 4 - Intermediate Functions/20. Challenge EXTRACT.vtt 1.9 KB
01. Day 1 - Getting started with SQL!/5. Let the Joruney Begin!.html 1.9 KB
06. Day 6 - Intermediate Joins/12. Challenge Joins.vtt 1.9 KB
02. Day 2 - Basics Filtering/7. Challenge WHERE operators.vtt 1.9 KB
04. Day 4 - Intermediate Functions/1. Today's plan.vtt 1.8 KB
02. Day 2 - Basics Filtering/11. Challenge WHERE with ANDOR.vtt 1.8 KB
08. Day 8 - Advanced Course project/7. Solution 4.vtt 1.8 KB
02. Day 2 - Basics Filtering/24. Challenge LIKE.vtt 1.8 KB
16. Extra Day CTEs (Common Table Expressions)/7. Challenge 2 Using Multiple CTEs.html 1.7 KB
04. Day 4 - Intermediate Functions/23. Challenge TO_CHAR.vtt 1.7 KB
05. Day 5 - Intermediate Conditional Expressions/9. Solutions.html 1.7 KB
07. Day 7 - Advanced UNION & Subqueries/13. Solution Subqueries in SELECT.vtt 1.7 KB
04. Day 4 - Intermediate Functions/27. Solution Intervals & Timestamps.vtt 1.7 KB
10. Day 10 - Advanced Views & Data Manipulation/6. Solution DELETE.vtt 1.7 KB
01. Day 1 - Getting started with SQL!/19. Challenge SELECT.vtt 1.6 KB
16. Extra Day CTEs (Common Table Expressions)/1. Why an extra day.html 1.6 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/10. Challenge Stored procedures.vtt 1.6 KB
03. Day 3 - Basics Grouping/1. Today's plan.vtt 1.6 KB
11. Day 11 - Pro Window Functions/5. Challenge OVER() with ORDER BY.vtt 1.6 KB
06. Day 6 - Intermediate Joins/21. Solutions.html 1.6 KB
16. Extra Day CTEs (Common Table Expressions)/12. Challenge 3 Recursive CTE.html 1.5 KB
02. Day 2 - Basics Filtering/3. Challenge WHERE.vtt 1.5 KB
04. Day 4 - Intermediate Functions/14. Challenge POSITION.vtt 1.5 KB
02. Day 2 - Basics Filtering/20. Challenge IN.vtt 1.5 KB
13. Day 13 - Pro Course project/1. Project introduction.html 1.5 KB
05. Day 5 - Intermediate Conditional Expressions/17. Solution CAST & COALESCE.vtt 1.5 KB
04. Day 4 - Intermediate Functions/17. Challenge SUBSTRING.vtt 1.5 KB
04. Day 4 - Intermediate Functions/26. Challenge Intervals & Timestamps.vtt 1.5 KB
06. Day 6 - Intermediate Joins/4. Challenge INNER JOIN.vtt 1.4 KB
01. Day 1 - Getting started with SQL!/23. Challenge ORDER BY.vtt 1.4 KB
07. Day 7 - Advanced UNION & Subqueries/15. Challenge Correlated subqueries in WHERE.vtt 1.4 KB
11. Day 11 - Pro Window Functions/12. Challenge LEAD & LAG.vtt 1.4 KB
03. Day 3 - Basics Grouping/18. Note for Mac users.html 1.4 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/13. Challenge Self joins.vtt 1.4 KB
04. Day 4 - Intermediate Functions/11. Challenge Concatenate.vtt 1.4 KB
11. Day 11 - Pro Window Functions/8. Challenge RANK().vtt 1.3 KB
04. Day 4 - Intermediate Functions/7. Challenge LEFT & RIGHT.vtt 1.3 KB
04. Day 4 - Intermediate Functions/4. Challenge LENGTH, LOWER & UPPER.vtt 1.3 KB
02. Day 2 - Basics Filtering/29. Introducing Role Plays.html 1.2 KB
10. Day 10 - Advanced Views & Data Manipulation/2. Challenge UPDATE.vtt 1.2 KB
05. Day 5 - Intermediate Conditional Expressions/16. Challenge CAST & COALESCE.vtt 1.2 KB
16. Extra Day CTEs (Common Table Expressions)/4. Challenge 1 Create a simple CTE.html 1.2 KB
01. Day 1 - Getting started with SQL!/26. Challenge SELECT DISTINCT.vtt 1.2 KB
10. Day 10 - Advanced Views & Data Manipulation/16. Solution Managing views.html 1.1 KB
16. Extra Day CTEs (Common Table Expressions)/5. Solution 1 Create a simple CTE.html 1.1 KB
12. Day 12 - Pro Grouping sets, rollups, self-joins/4. Additional challenge.vtt 1.0 KB
10. Day 10 - Advanced Views & Data Manipulation/8. Challenge CREATE TABLE AS.vtt 1.0 KB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge Transactions.vtt 982 bytes
06. Day 6 - Intermediate Joins/18. Challenge Joining multiple tables.vtt 972 bytes
02. Day 2 - Basics Filtering/16. Challenge BETWEEN.vtt 970 bytes
07. Day 7 - Advanced UNION & Subqueries/12. Challenge Subqueries in SELECT.vtt 966 bytes
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/3. Challenge User-defined functions.vtt 959 bytes
01. Day 1 - Getting started with SQL!/15. Common problems Slow performance.html 881 bytes
16. Extra Day CTEs (Common Table Expressions)/13. Solution 3 Recursive CTE.html 857 bytes
01. Day 1 - Getting started with SQL!/12. Common problems Set binary paths.html 843 bytes
10. Day 10 - Advanced Views & Data Manipulation/15. Challenge Managing views.html 830 bytes
15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. privileges.txt 802 bytes
10. Day 10 - Advanced Views & Data Manipulation/5. Challenge DELETE.vtt 740 bytes
07. Day 7 - Advanced UNION & Subqueries/9. Challenge Subqueries in FROM.vtt 719 bytes
12. Day 12 - Pro Grouping sets, rollups, self-joins/2. Challenge GROUPING SETS.vtt 703 bytes
02. Day 2 - Basics Filtering/13. Quick note on time zones.html 685 bytes
15. Day 15 - Pro Indexes, Partitining & Query Optimization/5. Challenge Privileges.html 613 bytes
15. Day 15 - Pro Indexes, Partitining & Query Optimization/6. Solution Privileges.html 562 bytes
06. Day 6 - Intermediate Joins/20. More challenges.html 531 bytes
15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. execution_plan_query_performance.txt 522 bytes
12. Day 12 - Pro Grouping sets, rollups, self-joins/11. Solution CUBE.html 483 bytes
15. Day 15 - Pro Indexes, Partitining & Query Optimization/14. Today's slides.html 422 bytes
12. Day 12 - Pro Grouping sets, rollups, self-joins/10. Challenge CUBE.html 391 bytes
12. Day 12 - Pro Grouping sets, rollups, self-joins/12. CreateTable.txt 380 bytes
07. Day 7 - Advanced UNION & Subqueries/20. Today's slides.html 370 bytes
10. Day 10 - Advanced Views & Data Manipulation/18. Today's slides.html 324 bytes
10. Day 10 - Advanced Views & Data Manipulation/12. Solution CREATE VIEW.html 317 bytes
09. Day 9 - Advanced Managing tables & databases/17. DROP & TRUNCATE.txt 297 bytes
10. Day 10 - Advanced Views & Data Manipulation/11. Challenge CREATE VIEW.html 295 bytes
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. TRANSACTIONS.txt 271 bytes
12. Day 12 - Pro Grouping sets, rollups, self-joins/17. Today's slides.html 265 bytes
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/12. Today's slides.html 254 bytes
05. Day 5 - Intermediate Conditional Expressions/19. Today's slides.html 234 bytes
09. Day 9 - Advanced Managing tables & databases/21. Today's slides.html 231 bytes
06. Day 6 - Intermediate Joins/22. Today's slides.html 229 bytes
11. Day 11 - Pro Window Functions/14. Today's slides.html 220 bytes
04. Day 4 - Intermediate Functions/28. Today's slides.html 213 bytes
10. Day 10 - Advanced Views & Data Manipulation/17. Create table.txt 185 bytes

Udemy - 15 Days of SQL The Complete SQL Masterclass 2025 (7.2025)

File List

Download Torrent

Related Resources

Copyright Infringement