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

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 5.6 GB
  • Uploaded By fcs0310
  • Downloads 1337
  • Last checked 1 year ago
  • Date uploaded 1 year ago
  • Seeders 36
  • Leechers 11

Infohash : B317770FE43DB42B49810E0785094B4F5094BD43

Warning! Use a V𝙿N When Downloading Torrents!
Your IP Address is . Location
Your Internet Provider can see when you download torrents! Hide your IP Address with a V𝙿N
⚠1337x recommends using Trust.Zone V𝙿N to hide your torrenting. It's FREE HIDE ME NOW


TO GET DIRECT DOWNLOAD LINKS OR GOOGLE DRIVE LINKS VISIT OUR WEBSITE
FOR MORE PREMIUM UDEMY COURSES VISIT: https://freecoursesite.com

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

Master SQL in just 15 days from Basics to Pro by working daily on real-life projects

Created by Nikolai Schuler
Published 4/2023
English
English [Auto]

Files:

[FreeCourseSite.com] Udemy - 15 Days of SQL The Complete SQL Masterclass 2023 0. Websites you may like
  • [CourseClub.Me].url (0.1 KB)
  • [FreeCourseSite.com].url (0.1 KB)
  • [GigaCourse.Com].url (0.0 KB)
1. Day 1 - Getting started with SQL!
  • 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)
10. Day 10 - Advanced Views & Data Manipulation
  • 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)
11. Day 11 - Pro Window Functions
  • 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)
12. Day 12 - Pro Grouping sets, rollups, self-joins
  • 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)
13. Day 13 - Pro Course project
  • 1. Project introduction.html (1.5 KB)
  • 2. The challenges.html (11.6 KB)
  • 3. Solutions.html (8.0 KB)
14. Day 14 - Pro Stored procedures, transactions & user-defined functions
  • 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)
15. Day 15 - Pro Indexes, Partitining & Query Optimization
  • 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)
2. Day 2 - Basics Filtering
  • 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)
3. Day 3 - Basics Grouping
  • 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)
4. Day 4 - Intermediate Functions
  • 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)
5. Day 5 - Intermediate Conditional Expressions
  • 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)
6. Day 6 - Intermediate Joins
  • 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)
7. Day 7 - Advanced UNION & Subqueries
  • 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)
8. Day 8 - Advanced Course project
  • 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)
9. Day 9 - Advanced Managing tables & databases
  • 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)

There are currently no comments. Feel free to leave one :)

Code:

  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://tracker.zer0day.to:1337/announce
  • udp://eddie4.nl:6969/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://fasttracker.foreverpirates.co:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://explodie.org:6969/announce
  • udp://open.stealth.si:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://tracker.uw0.xyz:6969/announce
  • udp://tracker.dler.org:6969/announce
  • udp://9.rarbg.to:2710/announce
  • udp://tracker.bitsearch.to:1337/announce
  • udp://tracker.altrosky.nl:6969/announce
  • udp://ben.kerbertools.xyz:6969/announce
  • udp://transkaroo.joustasie.net:6969/announce
  • udp://aarsen.me:6969/announce