Udemy - 15 Days of SQL: The Complete SQL Masterclass 2023 [FCS]

Files:

• [CourseClub.Me].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)

• 1. How to get the most out of the course.mp4 (33.7 MB)
• 10. Installing PostgreSQL & pgAdmin (MacOS).mp4 (38.3 MB)
• 11. Setting up the database.mp4 (27.5 MB)
• 11.1 pagila-master.zip (685.2 KB)
• 12. The Project.mp4 (21.6 MB)
• 13. SELECT.mp4 (38.9 MB)
• 14. Challenge SELECT.mp4 (6.6 MB)
• 15. Solution SELECT.mp4 (25.2 MB)
• 16. ORDER BY.mp4 (37.0 MB)
• 17. Challenge ORDER BY.mp4 (6.4 MB)
• 18. Solution ORDER BY.mp4 (21.0 MB)
• 19. SELECT DISTINCT.mp4 (25.5 MB)
• 2. How this course works.mp4 (25.1 MB)
• 20. Challenge SELECT DISTINCT.mp4 (5.2 MB)
• 21. Solution SELECT DISTINCT.mp4 (14.5 MB)
• 22. LIMIT.mp4 (26.1 MB)
• 23. COUNT().mp4 (21.4 MB)
• 24. Today's challenges.mp4 (31.5 MB)
• 25. Today's summary.mp4 (32.7 MB)
• 25.1 Day 1 - Course slides.pdf (2.0 MB)
• 3. Why learning SQL.mp4 (24.8 MB)
• 4. Let's get started!.html (0.2 KB)
• 5. What is a database.mp4 (19.5 MB)
• 6. Databases.html (0.2 KB)
• 7. Different dialects of SQL.mp4 (13.8 MB)
• 8. Dialects of SQL.html (0.2 KB)
• 9. Installing PostgreSQL & pgAdmin (Windows).mp4 (35.6 MB)

• 1. UPDATE.mp4 (31.4 MB)
• 10. CREATE VIEW.mp4 (37.7 MB)
• 11. Challenge CREATE VIEW.html (0.3 KB)
• 12. Solution CREATE VIEW.html (0.3 KB)
• 13. CREATE MATERIALIZED VIEW.mp4 (31.7 MB)
• 14. Managing views.mp4 (16.1 MB)
• 15. Challenge Managing views.html (0.8 KB)
• 16. Solution Managing views.html (1.0 KB)
• 17. Import & Export.mp4 (63.1 MB)
• 18. Today's slides.html (0.3 KB)
• 18.1 Day 10 - Course slides.pdf (870.7 KB)
• 2. Challenge UPDATE.mp4 (5.2 MB)
• 3. Solution UPDATE.mp4 (24.3 MB)
• 4. DELETE.mp4 (33.6 MB)
• 5. Challenge DELETE.mp4 (4.2 MB)
• 6. Solution DELETE.mp4 (8.8 MB)
• 7. CREATE TABLE AS.mp4 (21.3 MB)
• 8. Challenge CREATE TABLE AS.mp4 (4.0 MB)
• 9. Solution CREATE TABLE AS.mp4 (19.8 MB)

• 1. OVER() with PARTITION BY.mp4 (66.6 MB)
• 10. FIRST_VALUE().mp4 (24.8 MB)
• 11. LEAD & LAG.mp4 (30.9 MB)
• 12. Challenge LEAD & LAG.mp4 (5.8 MB)
• 13. Solution LEAD & LAG.mp4 (32.3 MB)
• 14. Additional challenge.mp4 (4.1 MB)
• 15. Solution Additional Challenge.mp4 (20.2 MB)
• 16. Today's slides.html (0.2 KB)
• 16.1 Day 11 - Course slides.pdf (711.2 KB)
• 2. Challenge OVER() with PARTITION BY.mp4 (9.9 MB)
• 3. Solution OVER() with PARTITION BY.mp4 (29.7 MB)
• 4. OVER() with ORDER BY.mp4 (44.8 MB)
• 5. Challenge OVER() with ORDER BY.mp4 (6.8 MB)
• 6. Solution OVER() with ORDER BY.mp4 (12.5 MB)
• 7. RANK().mp4 (48.6 MB)
• 8. Challenge RANK().mp4 (7.1 MB)
• 9. Solution RANK().mp4 (20.5 MB)

• 1. GROUPING SETS.mp4 (42.1 MB)
• 10. Self joins.mp4 (50.8 MB)
• 10.1 CreateTable.txt (0.4 KB)
• 11. Challenge Self joins.mp4 (5.9 MB)
• 12. Solution Self joins.mp4 (19.3 MB)
• 13. CROSS JOIN.mp4 (26.7 MB)
• 14. NATURAL JOIN.mp4 (33.3 MB)
• 15. Today's slides.html (0.2 KB)
• 15.1 Day 12 - Course slides.pdf (612.8 KB)
• 2. Challenge GROUPING SETS.mp4 (3.2 MB)
• 3. Solution GROUPING SETS.mp4 (11.3 MB)
• 4. ROLLUP.mp4 (48.9 MB)
• 5. Challenge ROLLUP.mp4 (8.2 MB)
• 6. Solution ROLLUP.mp4 (20.8 MB)
• 7. CUBE.mp4 (31.9 MB)
• 8. Challenge CUBE.html (0.4 KB)
• 9. Solution CUBE.html (0.4 KB)

• 1. Project introduction.html (1.5 KB)
• 2. The challenges.html (11.6 KB)
• 3. Solutions.html (8.0 KB)

• 1. User-defined functions.mp4 (37.2 MB)
• 10. Challenge Stored procedures.mp4 (7.5 MB)
• 11. Solution Stored procedure.mp4 (62.2 MB)
• 12. Today's slides.html (0.2 KB)
• 12.1 Day 14 - Course slides.pdf (747.5 KB)
• 2. User-defined functions - Example.mp4 (26.9 MB)
• 3. Challenge User-defined functions.mp4 (3.6 MB)
• 4. Solution.mp4 (30.3 MB)
• 5. Transactions.mp4 (38.7 MB)
• 5.1 TRANSACTIONS.txt (0.3 KB)
• 6. Challenge Transactions.mp4 (3.8 MB)
• 6.1 Challenge_Transactions.txt (2.8 KB)
• 7. Solution Transactions.mp4 (30.1 MB)
• 8. Rollbacks.mp4 (33.1 MB)
• 9. Stored procedures.mp4 (56.4 MB)

• 1. User management.mp4 (19.8 MB)
• 10. Indexes - Guidelines.mp4 (27.0 MB)
• 11. Creating indexes.mp4 (45.7 MB)
• 12. Creating indexes.html (0.2 KB)
• 13. Execution plan & query performance.mp4 (66.4 MB)
• 14. Today's slides.html (0.4 KB)
• 14.1 Day 15 - Course slides.pdf (989.5 KB)
• 2. CREATE USER ROLE.mp4 (47.3 MB)
• 3. GRANT & REVOKE privileges.mp4 (45.6 MB)
• 4. Privileges - Hands-on.mp4 (64.1 MB)
• 5. Challenge Privileges.html (0.6 KB)
• 6. Solution Privileges.html (0.5 KB)
• 7. What are indexes.mp4 (31.8 MB)
• 8. B-Tree index.mp4 (21.1 MB)
• 9. Bitmap index.mp4 (22.5 MB)

• 1. WHERE.mp4 (27.7 MB)
• 10. BETWEEN.mp4 (34.9 MB)
• 11. Challenge BETWEEN.mp4 (4.7 MB)
• 12. Solution BETWEEN.mp4 (17.1 MB)
• 13. IN.mp4 (22.6 MB)
• 14. Challenge IN.mp4 (7.0 MB)
• 15. Solution IN.mp4 (14.5 MB)
• 16. LIKE.mp4 (46.5 MB)
• 17. Challenge LIKE.mp4 (7.2 MB)
• 18. Solution LIKE.mp4 (35.3 MB)
• 19. Comments & Aliases.mp4 (41.8 MB)
• 2. Challenge WHERE.mp4 (5.6 MB)
• 20. Today's summary.mp4 (27.5 MB)
• 20.1 Day 2 - Course slides.pdf (1.1 MB)
• 21. Today's challenges.mp4 (35.3 MB)
• 3. Solution WHERE.mp4 (21.2 MB)
• 4. WHERE operators.mp4 (28.1 MB)
• 5. Challenge WHERE operators.mp4 (7.6 MB)
• 6. Solution WHERE operators.mp4 (13.5 MB)
• 7. WHERE with ANDOR.mp4 (45.2 MB)
• 8. Challenge WHERE with ANDOR.mp4 (8.9 MB)
• 9. Solution WHERE with ANDOR.mp4 (22.2 MB)

• 1. Today's plan.mp4 (8.7 MB)
• 10. HAVING.mp4 (22.9 MB)
• 11. Challenge HAVING.mp4 (17.2 MB)
• 12. Solution HAVING.mp4 (26.7 MB)
• 13. Introducing the second project.mp4 (29.8 MB)
• 13.1 flight_database.zip (21.5 MB)
• 14. Today's summary.mp4 (13.7 MB)
• 14.1 Day 3 - Course slides.pdf (643.7 KB)
• 2. Aggregate functions.mp4 (31.8 MB)
• 3. Challenge Aggregate function.mp4 (10.4 MB)
• 4. GROUP BY.mp4 (31.2 MB)
• 5. Challenge GROUP BY.mp4 (10.1 MB)
• 6. Solution GROUP BY.mp4 (20.1 MB)
• 7. GROUP BY multiple columns.mp4 (21.6 MB)
• 8. Challenge GROUP BY multiple columns.mp4 (16.4 MB)
• 9. Solution GROUP BY multiple columns.mp4 (25.8 MB)

• 1. Today's plan.mp4 (11.5 MB)
• 10. Solution Concatenate.mp4 (12.4 MB)
• 11. POSITION.mp4 (22.4 MB)
• 12. Challenge POSITION.mp4 (7.9 MB)
• 13. Solution POSITION.mp4 (16.3 MB)
• 14. SUBSTRING.mp4 (46.9 MB)
• 15. Challenge SUBSTRING.mp4 (6.8 MB)
• 16. Solution SUBSTRING.mp4 (34.5 MB)
• 17. EXTRACT.mp4 (50.0 MB)
• 18. Challenge EXTRACT.mp4 (8.8 MB)
• 19. Solution EXTRACT.mp4 (32.8 MB)
• 2. LENGTH, LOWER & UPPER.mp4 (36.1 MB)
• 20. TO_CHAR.mp4 (52.4 MB)
• 21. Challenge TO_CHAR.mp4 (6.7 MB)
• 22. Solution TO_CHAR.mp4 (33.0 MB)
• 23. Intervals & Timestamps.mp4 (32.6 MB)
• 24. Challenge Intervals & Timestamps.mp4 (6.7 MB)
• 25. Solution Intervals & Timestamps.mp4 (11.1 MB)
• 26. Today's slides.html (0.2 KB)
• 26.1 Day 4 - Course slides.pdf (743.5 KB)
• 3. Challenge LENGTH, LOWER & UPPER.mp4 (5.8 MB)
• 4. Solution LENGTH, LOWER & UPPER.mp4 (12.3 MB)
• 5. LEFT & RIGHT.mp4 (24.0 MB)
• 6. Challenge LEFT & RIGHT.mp4 (6.1 MB)
• 7. Solution LEFT & RIGHT.mp4 (13.6 MB)
• 8. Concatenate.mp4 (18.1 MB)
• 9. Challenge Concatenate.mp4 (6.8 MB)

• 1. Mathematical functions and operators.mp4 (39.2 MB)
• 10. COALESCE.mp4 (23.0 MB)
• 11. CAST.mp4 (40.9 MB)
• 12. Challenge CAST & COALESCE.mp4 (7.3 MB)
• 13. Solution CAST & COALESCE.mp4 (10.7 MB)
• 14. REPLACE.mp4 (26.1 MB)
• 15. Today's slides.html (0.2 KB)
• 15.1 Day 5 - Course slides.pdf (732.8 KB)
• 2. Challenge Mathematical functions and operators.mp4 (13.8 MB)
• 3. Solution Mathematical functions and operators.mp4 (25.3 MB)
• 4. CASE WHEN - Theory.mp4 (40.7 MB)
• 5. CASE WHEN - Hands-on.mp4 (43.7 MB)
• 6. 3 Challenge CASE WHEN.mp4 (26.3 MB)
• 7. Quick solutions.html (1.6 KB)
• 8. Solution CASE WHEN.mp4 (51.1 MB)
• 9. CASE WHEN & SUM.mp4 (46.3 MB)

• 1. What are joins.mp4 (20.0 MB)
• 10. Solution LEFT OUTER JOIN.mp4 (37.5 MB)
• 11. RIGHT OUTER JOIN.mp4 (30.7 MB)
• 12. Challenge Joins.mp4 (7.2 MB)
• 13. Solution Joins.mp4 (27.8 MB)
• 14. Joins on multiple conditions.mp4 (46.2 MB)
• 15. Solution Joins on multiple conditions.mp4 (13.0 MB)
• 16. Joining multiple tables.mp4 (34.9 MB)
• 17. Joining multiple tables - Practice.mp4 (39.4 MB)
• 18. Challenge Joining multiple tables.mp4 (3.5 MB)
• 19. Solution Joining multiple tables.mp4 (34.3 MB)
• 2. INNER JOIN - Theory.mp4 (67.4 MB)
• 20. More challenges.html (0.5 KB)
• 21. Solutions.html (1.5 KB)
• 22. Today's slides.html (0.2 KB)
• 22.1 Day 6 - Course slides.pdf (1.5 MB)
• 3. INNER JOIN - Practice.mp4 (51.3 MB)
• 4. Challenge INNER JOIN.mp4 (4.7 MB)
• 5. Solution INNER JOIN.mp4 (15.9 MB)
• 6. FULL OUTER JOIN.mp4 (43.7 MB)
• 7. JOIN & WHERE.mp4 (24.8 MB)
• 8. LEFT OUTER JOIN.mp4 (41.2 MB)
• 9. Challenge LEFT OUTER JOIN.mp4 (10.0 MB)

• 1. UNION.mp4 (46.1 MB)
• 10. Solution Subqueries in FROM.mp4 (14.1 MB)
• 11. Subqueries in SELECT.mp4 (25.6 MB)
• 12. Challenge Subqueries in SELECT.mp4 (4.2 MB)
• 13. Solution Subqueries in SELECT.mp4 (10.2 MB)
• 14. Correlated Subqueries in WHERE.mp4 (56.6 MB)
• 15. Challenge Correlated subqueries in WHERE.mp4 (5.9 MB)
• 16. Solution Correlated subqueries in WHERE.mp4 (17.5 MB)
• 17. Correlated Subquery in SELECT.mp4 (28.1 MB)
• 18. More challenges Correlated subqueres.mp4 (15.5 MB)
• 19. Solution More challenges.mp4 (61.9 MB)
• 2. UNION - Practice.mp4 (33.5 MB)
• 20. Today's slides.html (0.3 KB)
• 20.1 Day 7 - Course slides.pdf (1,013.4 KB)
• 3. Subqueries in WHERE.mp4 (38.6 MB)
• 4. Challenge Subqueries in WHERE.mp4 (6.5 MB)
• 5. Solution Subqueries in WHERE.mp4 (29.2 MB)
• 6. More challenges Subqueries in WHERE.mp4 (8.7 MB)
• 7. Solution More challenges.mp4 (37.8 MB)
• 8. Subqueries in FROM.mp4 (22.7 MB)
• 9. Challenge Subqueries in FROM.mp4 (2.7 MB)

• 1. Project Introduction.mp4 (47.2 MB)
• 10. Solution 7.mp4 (18.4 MB)
• 11. Solution 8.mp4 (11.3 MB)
• 12. Solution 9.mp4 (23.2 MB)
• 13. Solution 10.mp4 (25.5 MB)
• 14. Solution 11.mp4 (18.0 MB)
• 15. Solution 12.mp4 (37.0 MB)
• 16. Solution 13.mp4 (52.5 MB)
• 17. Solution 14.mp4 (40.4 MB)
• 2. Challenges.html (5.2 KB)
• 3. Solutions.html (5.2 KB)
• 4. Solution 1.mp4 (7.8 MB)
• 5. Solution 2.mp4 (22.6 MB)
• 6. Solution 3.mp4 (21.3 MB)
• 7. Solution 4.mp4 (9.2 MB)
• 8. Solution 5.mp4 (20.0 MB)
• 9. Solution 6.mp4 (20.9 MB)

• 1. Managing databases & tables.mp4 (21.6 MB)
• 10. CREATE TABLE.mp4 (43.7 MB)
• 11. CREATE TABLE.html (0.2 KB)
• 12. INSERT.mp4 (30.8 MB)
• 13. INSERT.html (0.2 KB)
• 14. ALTER TABLE.mp4 (32.2 MB)
• 15. Challenge ALTER TABLE.mp4 (15.6 MB)
• 16. Solution ALTER TABLE.mp4 (40.1 MB)
• 17. TRUNCATE & DROP TABLE.mp4 (26.3 MB)
• 17.1 DROP & TRUNCATE.txt (0.3 KB)
• 18. CHECK.mp4 (34.1 MB)
• 19. Challenge CHECK.mp4 (12.2 MB)
• 2. CREATE DATABASE.mp4 (27.4 MB)
• 20. Solution CHECK.mp4 (48.7 MB)
• 21. Today's slides.html (0.2 KB)
• 21.1 Day 9 - Course slides.pdf (1.9 MB)
• 3. CREATE & DROP DATABASE.html (0.2 KB)
• 4. Data Types.mp4 (58.1 MB)
• 5. Data Types.html (0.2 KB)
• 6. Constraints.mp4 (29.0 MB)
• 7. Constraints.html (0.2 KB)
• 8. Primary Key & Foreign Key.mp4 (28.6 MB)
• 9. Primary & Foreign Key.html (0.2 KB)