Udemy - SQL Masterclass: SQL for Data Analytics [FCS]

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 3.8 GB
  • Uploaded By fcs0310
  • Downloads 471
  • Last checked 1 year ago
  • Date uploaded 1 year ago
  • Seeders 14
  • Leechers 1

Infohash : 070BF60AAF1C84F3669DD01A44AB5044C2C26EDF

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


Udemy - SQL Masterclass: SQL for Data Analytics [FCS]

SQL course covering basic to advanced SQL topics for SQL Database ( PostgreSQL ). Elucidates SQL Database for beginners

Created by Start-Tech Academy
Last updated 12/2022
English
English


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

Files:

[FreeCourseSite.com] Udemy - SQL Masterclass SQL for Data Analytics 0. Websites you may like
  • [CourseClub.Me].url (0.1 KB)
  • [FreeCourseSite.com].url (0.1 KB)
  • [GigaCourse.Com].url (0.0 KB)
1. Introduction
  • 1. Introduction.mp4 (29.7 MB)
  • 1. Introduction.srt (4.9 KB)
10. Group By Commands
  • 1. GROUP BY.mp4 (93.3 MB)
  • 1. GROUP BY.srt (13.8 KB)
  • 1.1 Lecture_22_group by.pdf (174.6 KB)
  • 2. HAVING.mp4 (37.9 MB)
  • 2. HAVING.srt (5.4 KB)
  • 2.1 Lecture_23_HAVING.pdf (166.5 KB)
  • 3. Exercise 9 Group By.mp4 (6.2 MB)
  • 3. Exercise 9 Group By.srt (1.8 KB)
  • 4. Quiz.html (0.2 KB)
11. Conditional Statement
  • 1. CASE WHEN.mp4 (28.5 MB)
  • 1. CASE WHEN.srt (6.6 KB)
  • 1.1 Lecture_CASE.pdf (160.0 KB)
12. JOINS
  • 1. Introduction to Joins.mp4 (7.9 MB)
  • 1. Introduction to Joins.srt (3.1 KB)
  • 1.1 Lecture_24_Joins_Query.txt (0.4 KB)
  • 10. Except.mp4 (12.7 MB)
  • 10. Except.srt (3.5 KB)
  • 10.1 Lecture_29_EXCEPT.pdf (173.9 KB)
  • 11. Union.mp4 (15.1 MB)
  • 11. Union.srt (3.5 KB)
  • 11.1 Lecture_30_UNION.pdf (166.9 KB)
  • 12. Exercise 10 Joins.mp4 (6.9 MB)
  • 12. Exercise 10 Joins.srt (1.7 KB)
  • 13. Quiz.html (0.2 KB)
  • 2. Concepts of Joining and Combining Data.mp4 (59.8 MB)
  • 2. Concepts of Joining and Combining Data.srt (13.4 KB)
  • 3. Preparing the data.mp4 (13.9 MB)
  • 3. Preparing the data.srt (2.3 KB)
  • 3.1 M3_T1_V3 Joins_Query.txt (0.4 KB)
  • 4. Inner Join.mp4 (47.2 MB)
  • 4. Inner Join.srt (8.0 KB)
  • 4.1 Lecture_24_INNER join.pdf (214.2 KB)
  • 5. Left Join.mp4 (36.8 MB)
  • 5. Left Join.srt (8.4 KB)
  • 5.1 Lecture_25_LEFT join.pdf (219.0 KB)
  • 6. Right Join.mp4 (36.0 MB)
  • 6. Right Join.srt (6.6 KB)
  • 6.1 Lecture_26_RIGHT join.pdf (221.8 KB)
  • 7. Full Outer Join.mp4 (32.1 MB)
  • 7. Full Outer Join.srt (4.9 KB)
  • 7.1 Lecture_27_OUTER join.pdf (219.1 KB)
  • 8. Cross Join.mp4 (18.8 MB)
  • 8. Cross Join.srt (5.3 KB)
  • 8.1 Lecture_28_Cross join.pdf (186.7 KB)
  • 9. Intersect and Intersect ALL.mp4 (24.7 MB)
  • 9. Intersect and Intersect ALL.srt (7.6 KB)
13. Subqueries
  • 1. Subqueries.mp4 (103.8 MB)
  • 1. Subqueries.srt (19.4 KB)
  • 1.1 Lecture_31_SUBQUERY.pdf (207.5 KB)
  • 2. Exercise 11 Subqueries.mp4 (5.1 MB)
  • 2. Exercise 11 Subqueries.srt (2.0 KB)
14. Views and Indexes
  • 1. VIEWS.mp4 (42.5 MB)
  • 1. VIEWS.srt (9.7 KB)
  • 1.1 Lecture_32_VIEWS.pdf (220.7 KB)
  • 2. INDEX.mp4 (40.3 MB)
  • 2. INDEX.srt (9.9 KB)
  • 2.1 Lecture_33_INDEX.pdf (201.6 KB)
  • 3. Exercise 12 Views.mp4 (3.2 MB)
  • 3. Exercise 12 Views.srt (1.2 KB)
15. String Functions
  • 1. LENGTH.mp4 (18.6 MB)
  • 1. LENGTH.srt (4.6 KB)
  • 1.1 Lecture_34_STRING functions.pdf (209.5 KB)
  • 2. UPPER LOWER.mp4 (11.6 MB)
  • 2. UPPER LOWER.srt (3.4 KB)
  • 3. REPLACE.mp4 (25.3 MB)
  • 3. REPLACE.srt (5.5 KB)
  • 4. TRIM, LTRIM, RTRIM.mp4 (50.0 MB)
  • 4. TRIM, LTRIM, RTRIM.srt (9.6 KB)
  • 5. CONCATENATION.mp4 (16.9 MB)
  • 5. CONCATENATION.srt (3.8 KB)
  • 6. SUBSTRING.mp4 (42.3 MB)
  • 6. SUBSTRING.srt (7.4 KB)
  • 7. LIST AGGREGATION.mp4 (33.1 MB)
  • 7. LIST AGGREGATION.srt (6.7 KB)
  • 8. Exercise 13 String Functions.mp4 (16.5 MB)
  • 8. Exercise 13 String Functions.srt (3.9 KB)
16. Mathematical Functions
  • 1. CEIL & FLOOR.mp4 (21.0 MB)
  • 1. CEIL & FLOOR.srt (4.8 KB)
  • 1.1 Lecture_35_MATH functions.pdf (192.9 KB)
  • 2. RANDOM.mp4 (31.4 MB)
  • 2. RANDOM.srt (6.6 KB)
  • 3. SETSEED.mp4 (24.8 MB)
  • 3. SETSEED.srt (4.5 KB)
  • 4. ROUND.mp4 (16.8 MB)
  • 4. ROUND.srt (3.2 KB)
  • 5. POWER.mp4 (12.1 MB)
  • 5. POWER.srt (3.1 KB)
  • 6. Exercise 14 Mathematical Functions.mp4 (10.3 MB)
  • 6. Exercise 14 Mathematical Functions.srt (2.5 KB)
17. Date-Time Functions
  • 1. CURRENT DATE & TIME.mp4 (32.3 MB)
  • 1. CURRENT DATE & TIME.srt (6.3 KB)
  • 1.1 Lecture_36_DATETIME functions.pdf (232.4 KB)
  • 2. AGE.mp4 (26.6 MB)
  • 2. AGE.srt (4.2 KB)
  • 3. EXTRACT.mp4 (58.7 MB)
  • 3. EXTRACT.srt (10.3 KB)
  • 4. Exercise 15 Date-time functions.mp4 (5.7 MB)
  • 4. Exercise 15 Date-time functions.srt (1.9 KB)
18. PATTERN (STRING) MATCHING
  • 1. PATTERN MATCHING BASICS.mp4 (40.9 MB)
  • 1. PATTERN MATCHING BASICS.srt (11.2 KB)
  • 1.1 Lecture_Pattern_Matching.pdf (238.9 KB)
  • 2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4 (103.1 MB)
  • 2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt (18.5 KB)
  • 2.1 User_table.txt (0.2 KB)
  • 3. Exercise 16 Pattern Matching.mp4 (8.3 MB)
  • 3. Exercise 16 Pattern Matching.srt (2.7 KB)
19. Window Functions
  • 1. Introduction to Window functions.mp4 (57.7 MB)
  • 1. Introduction to Window functions.srt (10.3 KB)
  • 1.1 Windows Function PPT.pdf (616.7 KB)
  • 10. LAG and LEAD.mp4 (70.6 MB)
  • 10. LAG and LEAD.srt (8.5 KB)
  • 2. Introduction to Row number.mp4 (37.5 MB)
  • 2. Introduction to Row number.srt (6.0 KB)
  • 3. Implementing Row number in SQL.mp4 (174.2 MB)
  • 3. Implementing Row number in SQL.srt (19.2 KB)
  • 4. RANK and DENSERANK.mp4 (54.7 MB)
  • 4. RANK and DENSERANK.srt (7.6 KB)
  • 5. NTILE function.mp4 (66.6 MB)
  • 5. NTILE function.srt (7.0 KB)
  • 6. AVERAGE function.mp4 (58.9 MB)
  • 6. AVERAGE function.srt (8.0 KB)
  • 7. COUNT.mp4 (31.6 MB)
  • 7. COUNT.srt (4.0 KB)
  • 8. SUM TOTAL.mp4 (87.4 MB)
  • 8. SUM TOTAL.srt (10.8 KB)
  • 9. RUNNING TOTAL.mp4 (64.2 MB)
  • 9. RUNNING TOTAL.srt (7.2 KB)
2. Installation and getting started
  • 1. Installing PostgreSQL and pgAdmin in your PC.mp4 (68.1 MB)
  • 1. Installing PostgreSQL and pgAdmin in your PC.srt (13.0 KB)
  • 1.1 00 Debugging PostgreSQL installation issues.pdf (253.4 KB)
  • 1.2 Installing+PostgreSQL+on+Mac.pdf (209.8 KB)
  • 2. This is a milestone!.mp4 (20.7 MB)
  • 2. This is a milestone!.srt (3.9 KB)
  • 3. If pgAdmin is not opening....html (1.6 KB)
  • 4. Course Resources.html (0.4 KB)
20. COALESCE function
  • 1. COALESCE function.mp4 (42.6 MB)
  • 1. COALESCE function.srt (6.1 KB)
  • 1.1 Windows Function PPT.pdf (616.7 KB)
21. Data Type conversion functions
  • 1. Converting Numbers Date to String.mp4 (73.2 MB)
  • 1. Converting Numbers Date to String.srt (13.1 KB)
  • 1.1 Lecture_37_Conversion functions.pdf (219.7 KB)
  • 2. Converting String to Numbers Date.mp4 (39.0 MB)
  • 2. Converting String to Numbers Date.srt (6.4 KB)
22. User Access Control Functions
  • 1. User Access Control.mp4 (80.5 MB)
  • 1. User Access Control.srt (16.2 KB)
  • 1.1 Lecture_38_ACCESS control.pdf (207.9 KB)
23. Nail that Interview!
  • 1. Tablespace.mp4 (36.3 MB)
  • 1. Tablespace.srt (7.1 KB)
  • 1.1 Lecture_TABLESPACE.pdf (188.7 KB)
  • 2. PRIMARY KEY & FOREIGN KEY.mp4 (25.4 MB)
  • 2. PRIMARY KEY & FOREIGN KEY.srt (8.6 KB)
  • 2.1 Lecture_5_Keys.pdf (234.6 KB)
  • 3. ACID compliance.mp4 (42.7 MB)
  • 3. ACID compliance.srt (10.2 KB)
  • 3.1 Lecture_ACID.pdf (190.7 KB)
  • 4. Truncate.mp4 (21.1 MB)
  • 4. Truncate.srt (5.3 KB)
  • 4.1 Lecture_TRUNCATE.pdf (160.5 KB)
  • 5. Practice Test 1.html (0.2 KB)
  • 6. SQL Quiz.html (0.2 KB)
24. Performance tuning tips
  • 1. TIP 1 (EXPLAIN).mp4 (25.5 MB)
  • 1. TIP 1 (EXPLAIN).srt (4.2 KB)
  • 1.1 Lecture_Performance_Tuning.pdf (285.0 KB)
  • 2. TIP 2.mp4 (5.8 MB)
  • 2. TIP 2.srt (1.8 KB)
  • 3. TIP 3.mp4 (14.3 MB)
  • 3. TIP 3.srt (4.1 KB)
  • 4. TIP 4 (VACCUM).mp4 (2.9 MB)
  • 4. TIP 4 (VACCUM).srt (0.8 KB)
  • 5. TIP 5.mp4 (11.5 MB)
  • 5. TIP 5.srt (3.4 KB)
  • 6. TIP 6 (STRING FUNCTIONS).mp4 (13.7 MB)
  • 6. TIP 6 (STRING FUNCTIONS).srt (3.4 KB)
  • 7. TIP 7 (JOINS).mp4 (10.8 MB)
  • 7. TIP 7 (JOINS).srt (2.8 KB)
  • 8. TIP 8 (SCHEMAS).mp4 (32.0 MB)
  • 8. TIP 8 (SCHEMAS).srt (6.3 KB)
25. Final Section Database Basics
  • 1. What is SQL.mp4 (8.7 MB)
  • 1. What is SQL.srt (2.3 KB)
  • 2. Tables and DBMS.mp4 (14.7 MB)
  • 2. Tables and DBMS.srt (3.6 KB)
  • 3. Types of SQL commands.mp4 (22.1 MB)
  • 3. Types of SQL commands.srt (5.6 KB)
  • 4. PostgreSQL.mp4 (14.1 MB)
  • 4. PostgreSQL.srt (3.4 KB)
  • 5. The final milestone!.mp4 (11.9 MB)
  • 5. The final milestone!.srt (1.8 KB)
  • 6. Bonus Lecture.html (2.3 KB)
3. Case Study Demo
  • 1. Case Study Part 1 - Business problems.mp4 (37.8 MB)
  • 1. Case Study Part 1 - Business problems.srt (5.4 KB)
  • 2. Case Study Part 2 - How SQL is Used.mp4 (58.9 MB)
  • 2. Case Study Part 2 - How SQL is Used.srt (7.5 KB)
4. Fundamental SQL statements
  • 1. CREATE.mp4 (91.1 MB)
  • 1. CREATE.srt (14.5 KB)
  • 10. Logical Operators.mp4 (50.5 MB)
  • 10. Logical Operators.srt (6.0 KB)
  • 11. Exercise 3 SELECT & WHERE.mp4 (7.2 MB)
  • 11. Exercise 3 SELECT & WHERE.srt (2.0 KB)
  • 12. UPDATE.mp4 (37.7 MB)
  • 12. UPDATE.srt (5.6 KB)
  • 12.1 Lecture_10_UPDATEDelete.pdf (211.0 KB)
  • 13. DELETE.mp4 (29.2 MB)
  • 13. DELETE.srt (5.4 KB)
  • 14. ALTER.mp4 (125.7 MB)
  • 14. ALTER.srt (19.4 KB)
  • 14.1 Lecture_11_ALTER.pdf (201.7 KB)
  • 15. Exercise 4 Updating Table.mp4 (3.9 MB)
  • 15. Exercise 4 Updating Table.srt (1.5 KB)
  • 16. Fundamental SQL statements.html (0.2 KB)
  • 2. Exercise 1 Create DB and Table.mp4 (5.9 MB)
  • 2. Exercise 1 Create DB and Table.srt (2.6 KB)
  • 3. Solutions to all Exercises.html (0.1 KB)
  • 3.1 Solution.pdf (733.9 KB)
  • 4. INSERT.mp4 (73.1 MB)
  • 4. INSERT.srt (9.6 KB)
  • 5. Import data from File.mp4 (42.0 MB)
  • 5. Import data from File.srt (5.5 KB)
  • 6. Exercise 2 Inserting and Importing.mp4 (4.6 MB)
  • 6. Exercise 2 Inserting and Importing.srt (1.2 KB)
  • 6.1 Student.csv (0.1 KB)
  • 7. SELECT statement.mp4 (31.8 MB)
  • 7. SELECT statement.srt (4.6 KB)
  • 8. SELECT DISTINCT.mp4 (46.2 MB)
  • 8. SELECT DISTINCT.srt (6.1 KB)
  • 9. WHERE.mp4 (32.6 MB)
  • 9. WHERE.srt (4.1 KB)
5. Restore and Back-up
  • 1. Restore and Back-up.mp4 (72.1 MB)
  • 1. Restore and Back-up.srt (9.8 KB)
  • 1.1 BackupFiles.zip (585.8 KB)
  • 1.2 Supermart_DB.tar (1.2 MB)
  • 2. Debugging restoration issues.mp4 (50.2 MB)
  • 2. Debugging restoration issues.srt (9.8 KB)
  • 3. Creating DB using CSV files.mp4 (35.5 MB)
  • 3. Creating DB using CSV files.srt (6.4 KB)
  • 4. Debugging summary and Code for CSV files.html (2.5 KB)
  • 4.1 Customer.csv (64.0 KB)
  • 4.2 Product.csv (139.6 KB)
  • 4.3 Sales.csv (983.7 KB)
  • 5. Exercise 5 Restore and Back-up.mp4 (3.0 MB)
  • 5. Exercise 5 Restore and Back-up.srt (1.3 KB)
6. Selection commands Filtering
  • 1. IN.mp4 (29.4 MB)
  • 1. IN.srt (5.3 KB)
  • 1.1 Lecture_12_IN_12.pdf (157.4 KB)
  • 2. BETWEEN.mp4 (49.7 MB)
  • 2. BETWEEN.srt (6.5 KB)
  • 2.1 Lecture_13_BETWEEN.pdf (187.6 KB)
  • 3. LIKE.mp4 (61.2 MB)
  • 3. LIKE.srt (12.3 KB)
  • 3.1 Lecture_14_LIKE.pdf (173.7 KB)
  • 4. Exercise 6 In, Like & Between.mp4 (5.3 MB)
  • 4. Exercise 6 In, Like & Between.srt (1.0 KB)
7. Selection commands Ordering
  • 1. Side Lecture Commenting in SQL.mp4 (12.3 MB)
  • 1. Side Lecture Commenting in SQL.srt (2.0 KB)
  • 2. ORDER BY.mp4 (71.4 MB)
  • 2. ORDER BY.srt (10.4 KB)
  • 2.1 Lecture_15_ORDER BY.pdf (180.1 KB)
  • 3. LIMIT.mp4 (29.6 MB)
  • 3. LIMIT.srt (5.1 KB)
  • 3.1 Lecture_16_LIMIT.pdf (162.1 KB)
  • 4. Exercise 7 Sorting.mp4 (3.2 MB)
  • 4. Exercise 7 Sorting.srt (1.1 KB)
8. Alias
  • 1. AS.mp4 (25.6 MB)
  • 1. AS.srt (4.9 KB)
  • 1.1 Lecture_17_AS.pdf (151.7 KB)
  • 1.2 Lecture_17_AS.pdf (151.7 KB)
9. Aggregate Commands
  • 1. COUNT.mp4 (38.4 MB)
  • 1. COUNT.srt (6.8 KB)
  • 1.1 Lecture_18_count.pdf (158.2 KB)
  • 2. SUM.mp4 (21.1 MB)
  • 2. SUM.srt (3.8 KB)
  • 2.1 Lecture_19_SUM.pdf (162.9 KB)
  • 3. AVERAGE.mp4 (17.5 MB)
  • 3. AVERAGE.srt (3.5 KB)
  • 3.1 Lecture_20_AVG.pdf (157.5 KB)
  • 4. MIN & MAX.mp4 (32.5 MB)
  • 4. MIN & MAX.srt (4.8 KB)
  • 4.1 Lecture_21_MIN&MAX.pdf (164.1 KB)
  • 5. Exercise 8 Aggregate functions.mp4 (6.4 MB)
  • 5. Exercise 8 Aggregate functions.srt (2.0 KB)
  • 6. Quiz.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