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

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size2.9 GB
  • Uploaded ByLMorningStar
  • Downloads260
  • Last checkedJun. 14th '20
  • Date uploadedJun. 13th '20
  • Seeders 15
  • Leechers15
You must create an Account to download torrent!

Infohash : F868632DAE73855E8B2910CBA1482616E39D71C1

SQL Masterclass: SQL for Data AnalyticsSQL Masterclass: SQL for Data Analytics  



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

For More Paid Udemy Courses Visit:

FreeAllCourse.Com

What you'll learn?

# Knowledge of all the essential SQL commands
# Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
# Become competent in using sorting and filtering commands in SQL
# Master SQL's most popular string, mathematical and date-time functions
# Enhance the performance of your Database by using Views and Indexes
# Increase your efficiency by learning the best practices while writing SQL queries
# Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas
# Solid understanding of SQL

Description

Created by Start-Tech Academy
Last updated 6/2020
Audio: English
Caption: English


Files:

[FreeAllCourse.Com] Udemy - SQL Masterclass SQL for Data Analytics 4. Fundamental SQL statements
  • 14. ALTER.mp4 (125.7 MB)
  • 1. CREATE.mp4 (63.8 MB)
  • 1. CREATE.srt (16.2 KB)
  • 1.1 Lecture_04_create_Queries.pdf (219.3 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 (56.4 MB)
  • 4. INSERT.srt (10.5 KB)
  • 4.1 Lecture_06_INSERT and COPY.pdf (219.2 KB)
  • 5. Import data from File.mp4 (32.6 MB)
  • 5. Import data from File.srt (6.0 KB)
  • 5.1 copytext.txt (0.0 KB)
  • 5.2 copy.csv (0.1 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 (27.1 MB)
  • 7. SELECT statement.srt (4.7 KB)
  • 7.1 Lecture_07_SELECT & DISTINCT.pdf (179.2 KB)
  • 8. SELECT DISTINCT.mp4 (43.2 MB)
  • 8. SELECT DISTINCT.srt (7.3 KB)
  • 9. WHERE.mp4 (27.7 MB)
  • 9. WHERE.srt (4.7 KB)
  • 9.1 Lecture_08_WHERE.pdf (175.6 KB)
  • 10. Logical Operators.mp4 (41.8 MB)
  • 10. Logical Operators.srt (6.8 KB)
  • 10.1 Lecture_09_AND&OR.pdf (176.3 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.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)
  • Verify Files.txt (1.0 KB)
    • 0. Websites you may like
    • [FreeAllCourse.Com].url (0.1 KB)
    1. Introduction
    • 1. Course Overview.mp4 (29.3 MB)
    • 1. Course Overview.srt (7.4 KB)
    • 1.1 IntroV_01.pdf (707.1 KB)
    2. Installation and getting started
    • 1. Installation.mp4 (45.6 MB)
    • 1. Installation.srt (7.3 KB)
    • 1.1 Installing PostgreSQL on Mac.pdf (209.8 KB)
    3. Case Study Demo
    • 1. Course Resources.html (0.1 KB)
    • 1.1 Files_sql.zip (10.0 MB)
    • 2. Case Study Part 1.mp4 (28.0 MB)
    • 2. Case Study Part 1.srt (6.1 KB)
    • 3. Case Study Part 2.mp4 (51.2 MB)
    • 3. Case Study Part 2.srt (8.7 KB)
  • [FreeAllCourse.Com].url (0.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 Supermart_DB_new.zip (297.8 KB)
    • 2. CSV files.html (0.5 KB)
    • 2.1 Product.csv (139.5 KB)
    • 2.2 Customer.csv (64.0 KB)
    • 2.3 Sales.csv (983.7 KB)
    • 3. Exercise 5 Restore and Back-up.mp4 (3.0 MB)
    • 3. 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)
    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 (164.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 (17.8 MB)

    • Code:

      • udp://explodie.org:6969/announce
      • udp://tracker.torrent.eu.org:451/announce
      • udp://tracker.kamigami.org:2710/announce
      • https://tracker.nanoha.org:443/announce
      • udp://retracker.akado-ural.ru:80/announce
      • udp://opentor.org:2710/announce
      • http://h4.trakx.nibba.trade:80/announce
      • udp://xxxtor.com:2710/announce
      • udp://opentracker.i2p.rocks:6969/announce
      • udp://tracker.zerobytes.xyz:1337/announce
      • https://tracker.nitrix.me:443/announce
      • https://t1.leech.ie:443/announce
      • udp://open.stealth.si:80/announce