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

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size5.6 GB
  • Uploaded Byfcs0310
  • Downloads142
  • Last checkedApr. 26th '23
  • Date uploadedApr. 25th '23
  • Seeders 41
  • Leechers25

Infohash : B317770FE43DB42B49810E0785094B4F5094BD43

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)
  • 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