Udemy - SQL Masterclass: SQL For Data Analytics [TP]

Files:

• 1. Course Overview.mp4 (29.3 MB)
• 1. Course Overview.vtt (6.2 KB)
• 1.1 IntroV_01.pdf.pdf (707.1 KB)

• 1. GROUP BY.mp4 (93.3 MB)
• 1. GROUP BY.vtt (11.3 KB)
• 1.1 Lecture_22_group by.pdf.pdf (164.6 KB)
• 2. HAVING.mp4 (37.9 MB)
• 2. HAVING.vtt (4.4 KB)
• 2.1 Lecture_23_HAVING.pdf.pdf (166.5 KB)
• 3. Exercise 9 Group By.mp4 (6.2 MB)
• 3. Exercise 9 Group By.vtt (1.5 KB)
• 4. Quiz 2.html (0.2 KB)

• 1. CASE WHEN.mp4 (28.5 MB)
• 1. CASE WHEN.vtt (5.4 KB)
• 1.1 Lecture_CASE.pdf.pdf (160.0 KB)

• 1. Introduction to Joins.mp4 (17.8 MB)
• 1. Introduction to Joins.vtt (3.0 KB)
• 1.1 Lecture_24_Joins_Query.txt.txt (0.4 KB)
• 10. Joins.html (0.2 KB)
• 2. Inner Join.mp4 (59.3 MB)
• 2. Inner Join.vtt (8.3 KB)
• 2.1 Lecture_24_INNER join.pdf.pdf (214.2 KB)
• 3. Left Join.mp4 (50.4 MB)
• 3. Left Join.vtt (8.3 KB)
• 3.1 Lecture_25_LEFT join.pdf.pdf (219.0 KB)
• 4. Right Join.mp4 (48.6 MB)
• 4. Right Join.vtt (6.3 KB)
• 4.1 Lecture_26_RIGHT join.pdf.pdf (221.8 KB)
• 5. Full Outer Join.mp4 (39.3 MB)
• 5. Full Outer Join.vtt (4.4 KB)
• 5.1 Lecture_27_OUTER join.pdf.pdf (219.1 KB)
• 6. Cross Join.mp4 (25.9 MB)
• 6. Cross Join.vtt (5.1 KB)
• 6.1 Lecture_28_Cross join.pdf.pdf (186.7 KB)
• 7. Except.mp4 (17.3 MB)
• 7. Except.vtt (3.4 KB)
• 7.1 Lecture_29_EXCEPT.pdf.pdf (173.9 KB)
• 8. Union.mp4 (19.7 MB)
• 8. Union.vtt (3.6 KB)
• 8.1 Lecture_30_UNION.pdf.pdf (166.9 KB)
• 9. Exercise 10 Joins.mp4 (6.9 MB)
• 9. Exercise 10 Joins.vtt (1.4 KB)

• 1. Subqueries.mp4 (103.8 MB)
• 1. Subqueries.vtt (16.0 KB)
• 1.1 Lecture_31_SUBQUERY.pdf.pdf (207.5 KB)
• 2. Exercise 11 Subqueries.mp4 (5.1 MB)
• 2. Exercise 11 Subqueries.vtt (1.6 KB)

• 1. VIEWS.mp4 (42.5 MB)
• 1. VIEWS.vtt (7.9 KB)
• 1.1 Lecture_32_VIEWS.pdf.pdf (220.7 KB)
• 2. INDEX.mp4 (40.3 MB)
• 2. INDEX.vtt (8.2 KB)
• 2.1 Lecture_33_INDEX.pdf.pdf (201.6 KB)
• 3. Exercise 12 Views.mp4 (3.2 MB)
• 3. Exercise 12 Views.vtt (1.0 KB)

• 1. LENGTH.mp4 (18.6 MB)
• 1. LENGTH.vtt (3.8 KB)
• 1.1 Lecture_34_STRING functions.pdf.pdf (209.5 KB)
• 2. UPPER LOWER.mp4 (11.6 MB)
• 2. UPPER LOWER.vtt (2.8 KB)
• 3. REPLACE.mp4 (25.2 MB)
• 3. REPLACE.vtt (4.6 KB)
• 4. TRIM, LTRIM, RTRIM.mp4 (50.0 MB)
• 4. TRIM, LTRIM, RTRIM.vtt (7.9 KB)
• 5. CONCATENATION.mp4 (16.9 MB)
• 5. CONCATENATION.vtt (3.1 KB)
• 6. SUBSTRING.mp4 (42.3 MB)
• 6. SUBSTRING.vtt (6.1 KB)
• 7. LIST AGGREGATION.mp4 (33.1 MB)
• 7. LIST AGGREGATION.vtt (5.5 KB)
• 8. Exercise 13 String Functions.mp4 (16.5 MB)
• 8. Exercise 13 String Functions.vtt (3.2 KB)

• 1. CEIL & FLOOR.mp4 (21.0 MB)
• 1. CEIL & FLOOR.vtt (3.9 KB)
• 1.1 Lecture_35_MATH functions.pdf.pdf (192.9 KB)
• 2. RANDOM.mp4 (31.4 MB)
• 2. RANDOM.vtt (5.4 KB)
• 3. SETSEED.mp4 (24.8 MB)
• 3. SETSEED.vtt (3.8 KB)
• 4. ROUND.mp4 (16.7 MB)
• 4. ROUND.vtt (2.6 KB)
• 5. POWER.mp4 (12.1 MB)
• 5. POWER.vtt (2.5 KB)
• 6. Exercise 14 Mathematical Functions.mp4 (10.3 MB)
• 6. Exercise 14 Mathematical Functions.vtt (2.1 KB)

• 1. CURRENT DATE & TIME.mp4 (32.3 MB)
• 1. CURRENT DATE & TIME.vtt (5.2 KB)
• 1.1 Lecture_36_DATETIME functions.pdf.pdf (232.4 KB)
• 2. AGE.mp4 (26.6 MB)
• 2. AGE.vtt (3.4 KB)
• 3. EXTRACT.mp4 (58.6 MB)
• 3. EXTRACT.vtt (8.3 KB)
• 4. Exercise 15 Date-time functions.mp4 (5.7 MB)
• 4. Exercise 15 Date-time functions.vtt (1.6 KB)

• 1. PATTERN MATCHING BASICS.mp4 (40.9 MB)
• 1. PATTERN MATCHING BASICS.vtt (9.4 KB)
• 1.1 Lecture_Pattern_Matching.pdf.pdf (238.9 KB)
• 2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4 (103.1 MB)
• 2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).vtt (15.3 KB)
• 2.1 User_table.txt.txt (0.2 KB)
• 3. Exercise 16 Pattern Matching.mp4 (8.3 MB)
• 3. Exercise 16 Pattern Matching.vtt (2.3 KB)

• 1. Converting Numbers Date to String.mp4 (73.2 MB)
• 1. Converting Numbers Date to String.vtt (10.7 KB)
• 1.1 Lecture_37_Conversion functions.pdf.pdf (219.7 KB)
• 2. Converting String to Numbers Date.mp4 (39.0 MB)
• 2. Converting String to Numbers Date.vtt (5.2 KB)

• 1. Installation.mp4 (45.6 MB)
• 1. Installation.vtt (6.2 KB)
• 1.1 Installing PostgreSQL on Mac.pdf.pdf (209.8 KB)

• 1. User Access Control.mp4 (80.5 MB)
• 1. User Access Control.vtt (13.4 KB)
• 1.1 Lecture_38_ACCESS control.pdf.pdf (207.9 KB)

• 1. Tablespace.mp4 (36.3 MB)
• 1. Tablespace.vtt (5.9 KB)
• 1.1 Lecture_TABLESPACE.pdf.pdf (188.7 KB)
• 2. PRIMARY KEY & FOREIGN KEY.mp4 (25.4 MB)
• 2. PRIMARY KEY & FOREIGN KEY.vtt (7.0 KB)
• 2.1 Lecture_5_Keys.pdf.pdf (234.6 KB)
• 3. ACID compliance.mp4 (42.7 MB)
• 3. ACID compliance.vtt (8.3 KB)
• 3.1 Lecture_ACID.pdf.pdf (190.7 KB)
• 4. Truncate.mp4 (21.1 MB)
• 4. Truncate.vtt (4.5 KB)
• 4.1 Lecture_TRUNCATE.pdf.pdf (160.5 KB)
• 5. Practice Test 1.html (0.2 KB)

• 1. TIP 1 (EXPLAIN).mp4 (25.5 MB)
• 1. TIP 1 (EXPLAIN).vtt (3.7 KB)
• 1.1 Lecture_Performance_Tuning.pdf.pdf (285.0 KB)
• 2. TIP 2.mp4 (5.8 MB)
• 2. TIP 2.vtt (1.5 KB)
• 3. TIP 3.mp4 (14.3 MB)
• 3. TIP 3.vtt (3.4 KB)
• 4. TIP 4 (VACCUM).mp4 (2.9 MB)
• 4. TIP 4 (VACCUM).vtt (0.6 KB)
• 5. TIP 5.mp4 (11.5 MB)
• 5. TIP 5.vtt (2.8 KB)
• 6. TIP 6 (STRING FUNCTIONS).mp4 (13.7 MB)
• 6. TIP 6 (STRING FUNCTIONS).vtt (2.9 KB)
• 7. TIP 7 (JOINS).mp4 (10.8 MB)
• 7. TIP 7 (JOINS).vtt (2.4 KB)
• 8. TIP 8 (SCHEMAS).mp4 (32.0 MB)
• 8. TIP 8 (SCHEMAS).vtt (5.3 KB)

• 1. Practice Problem 1.html (0.2 KB)

• 1. What is SQL.mp4 (10.8 MB)
• 1. What is SQL.vtt (2.5 KB)
• 1.1 Lecture_1.pdf.pdf (220.3 KB)
• 2. Tables and DBMS.mp4 (17.4 MB)
• 2. Tables and DBMS.vtt (3.9 KB)
• 2.1 Lecture_2.pdf.pdf (289.5 KB)
• 3. Types of SQL commands.mp4 (25.3 MB)
• 3. Types of SQL commands.vtt (5.6 KB)
• 3.1 Lecture_3_Queries.pdf.pdf (208.4 KB)
• 4. PostgreSQL.mp4 (17.1 MB)
• 4. PostgreSQL.vtt (3.2 KB)
• 4.1 Lecture_5_Postgresql.pdf.pdf (216.4 KB)
• 5. Bonus Lecture Our other courses for you.html (0.9 KB)
• 6. Bonus Lecture.html (1.4 KB)

• 1. Case Study Part 1.mp4 (28.0 MB)
• 1. Case Study Part 1.vtt (5.2 KB)
• 2. Case Study Part 2.mp4 (51.2 MB)
• 2. Case Study Part 2.vtt (7.3 KB)

• 1. CREATE.mp4 (63.8 MB)
• 1. CREATE.vtt (13.5 KB)
• 1.1 Lecture_04_create_Queries.pdf.pdf (219.3 KB)
• 10. Logical Operators.mp4 (41.8 MB)
• 10. Logical Operators.vtt (5.5 KB)
• 10.1 Lecture_09_AND&OR.pdf.pdf (176.3 KB)
• 11. Exercise 3 SELECT & WHERE.mp4 (7.2 MB)
• 11. Exercise 3 SELECT & WHERE.vtt (1.7 KB)
• 12. UPDATE.mp4 (37.7 MB)
• 12. UPDATE.vtt (4.5 KB)
• 12.1 Lecture_10_UPDATEDelete.pdf.pdf (211.0 KB)
• 13. DELETE.mp4 (29.2 MB)
• 13. DELETE.vtt (4.4 KB)
• 14. ALTER.mp4 (125.7 MB)
• 14. ALTER.vtt (15.8 KB)
• 14.1 Lecture_11_ALTER.pdf.pdf (201.7 KB)
• 15. Exercise 4 Updating Table.mp4 (3.9 MB)
• 15. Exercise 4 Updating Table.vtt (1.2 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.vtt (2.2 KB)
• 3. Solutions to all Exercises.html (0.1 KB)
• 3.1 Solution.pdf.pdf (733.9 KB)
• 4. INSERT.mp4 (56.4 MB)
• 4. INSERT.vtt (8.6 KB)
• 4.1 Lecture_06_INSERT and COPY.pdf.pdf (219.2 KB)
• 5. Import data from File.mp4 (32.6 MB)
• 5. Import data from File.vtt (5.1 KB)
• 5.1 copy.csv.csv (0.1 KB)
• 5.2 copytext.txt.txt (0.0 KB)
• 6. Exercise 2 Inserting and Importing.mp4 (4.6 MB)
• 6. Exercise 2 Inserting and Importing.vtt (1.0 KB)
• 6.1 Student.csv.csv (0.1 KB)
• 7. SELECT statement.mp4 (27.1 MB)
• 7. SELECT statement.vtt (3.9 KB)
• 7.1 Lecture_07_SELECT & DISTINCT.pdf.pdf (179.2 KB)
• 8. SELECT DISTINCT.mp4 (43.2 MB)
• 8. SELECT DISTINCT.vtt (6.0 KB)
• 9. WHERE.mp4 (27.7 MB)
• 9. WHERE.vtt (3.9 KB)
• 9.1 Lecture_08_WHERE.pdf.pdf (175.6 KB)

• 1. Restore and Back-up.mp4 (72.1 MB)
• 1. Restore and Back-up.vtt (8.2 KB)
• 1.1 Supermart_DB_new.zip.zip (297.8 KB)
• 2. CSV files.html (0.2 KB)
• 2.1 Sales.csv.csv (983.7 KB)
• 2.2 Customer.csv.csv (64.0 KB)
• 2.3 Product.csv.csv (139.5 KB)
• 3. Exercise 5 Restore and Back-up.mp4 (3.0 MB)
• 3. Exercise 5 Restore and Back-up.vtt (1.1 KB)

• 1. IN.mp4 (29.4 MB)
• 1. IN.vtt (4.4 KB)
• 1.1 Lecture_12_IN_12.pdf.pdf (157.4 KB)
• 2. BETWEEN.mp4 (49.7 MB)
• 2. BETWEEN.vtt (5.3 KB)
• 2.1 Lecture_13_BETWEEN.pdf.pdf (187.6 KB)
• 3. LIKE.mp4 (61.2 MB)
• 3. LIKE.vtt (10.0 KB)
• 3.1 Lecture_14_LIKE.pdf.pdf (173.7 KB)
• 4. Exercise 6 In, Like & Between.mp4 (5.3 MB)
• 4. Exercise 6 In, Like & Between.vtt (0.8 KB)

• 1. Side Lecture Commenting in SQL.mp4 (12.3 MB)
• 1. Side Lecture Commenting in SQL.vtt (1.7 KB)
• 2. ORDER BY.mp4 (71.4 MB)
• 2. ORDER BY.vtt (8.4 KB)
• 2.1 Lecture_15_ORDER BY.pdf.pdf (180.1 KB)
• 3. LIMIT.mp4 (29.6 MB)
• 3. LIMIT.vtt (4.1 KB)
• 3.1 Lecture_16_LIMIT.pdf.pdf (162.1 KB)
• 4. Exercise 7 Sorting.mp4 (3.2 MB)
• 4. Exercise 7 Sorting.vtt (0.9 KB)

• 1. AS.mp4 (25.6 MB)
• 1. AS.vtt (4.1 KB)
• 1.1 Lecture_17_AS.pdf.pdf (151.7 KB)
• 1.2 Lecture_17_AS.pdf.pdf (151.7 KB)

• 1. COUNT.mp4 (38.3 MB)
• 1. COUNT.vtt (5.6 KB)
• 1.1 Lecture_18_count.pdf.pdf (158.2 KB)
• 2. SUM.mp4 (21.1 MB)
• 2. SUM.vtt (3.0 KB)
• 2.1 Lecture_19_SUM.pdf.pdf (162.9 KB)
• 3. AVERAGE.mp4 (17.5 MB)
• 3. AVERAGE.vtt (2.8 KB)
• 3.1 Lecture_20_AVG.pdf.pdf (157.5 KB)
• 4. MIN & MAX.mp4 (32.5 MB)
• 4. MIN & MAX.vtt (3.8 KB)
• 4.1 Lecture_21_MIN&MAX.pdf.pdf (164.1 KB)
• 5. Exercise 8 Aggregate functions.mp4 (6.4 MB)
• 5. Exercise 8 Aggregate functions.vtt (1.7 KB)

• [Tutorialsplanet.NET].url (0.1 KB)