Name GetFreeCourses.Co-Udemy-SQL Masterclass SQL for Data Analytics

File Type video

Size 3.81GB

UpdateDate 2024-9-10

hash *****FF0D66EB3B2E48D12C30A40DCD3EF062DE

Hot 33

Files 1. Introduction/1. Introduction.mp4 | 29.65MB 1. Introduction/1. Introduction.srt | 4.92KB 10. Group By Commands/1. GROUP BY.mp4 | 93.33MB 10. Group By Commands/1. GROUP BY.srt | 13.78KB 10. Group By Commands/1.1 Lecture_22_group by.pdf | 174.64KB 10. Group By Commands/2. HAVING.mp4 | 37.91MB 10. Group By Commands/2. HAVING.srt | 5.39KB 10. Group By Commands/2.1 Lecture_23_HAVING.pdf | 166.52KB 10. Group By Commands/3. Exercise 9 Group By.mp4 | 6.17MB 10. Group By Commands/3. Exercise 9 Group By.srt | 1.80KB 10. Group By Commands/4. Quiz.html | 198B 11. Conditional Statement/1. CASE WHEN.mp4 | 28.52MB 11. Conditional Statement/1. CASE WHEN.srt | 6.63KB 11. Conditional Statement/1.1 Lecture_CASE.pdf | 160.02KB 11. Conditional Statement/GetFreeCourses.Co.url | 116B 12. JOINS/1. Introduction to Joins.mp4 | 7.93MB 12. JOINS/1. Introduction to Joins.srt | 3.11KB 12. JOINS/1.1 Lecture_24_Joins_Query.txt | 417B 12. JOINS/10. Except.mp4 | 12.67MB 12. JOINS/10. Except.srt | 3.47KB 12. JOINS/10.1 Lecture_29_EXCEPT.pdf | 173.89KB 12. JOINS/11. Union.mp4 | 15.13MB 12. JOINS/11. Union.srt | 3.49KB 12. JOINS/11.1 Lecture_30_UNION.pdf | 166.94KB 12. JOINS/12. Exercise 10 Joins.mp4 | 6.90MB 12. JOINS/12. Exercise 10 Joins.srt | 1.73KB 12. JOINS/13. Quiz.html | 198B 12. JOINS/2. Concepts of Joining and Combining Data.mp4 | 59.79MB 12. JOINS/2. Concepts of Joining and Combining Data.srt | 13.35KB 12. JOINS/3. Preparing the data.mp4 | 13.86MB 12. JOINS/3. Preparing the data.srt | 2.30KB 12. JOINS/3.1 M3_T1_V3 Joins_Query.txt | 417B 12. JOINS/4. Inner Join.mp4 | 47.15MB 12. JOINS/4. Inner Join.srt | 7.97KB 12. JOINS/4.1 Lecture_24_INNER join.pdf | 214.20KB 12. JOINS/5. Left Join.mp4 | 36.79MB 12. JOINS/5. Left Join.srt | 8.44KB 12. JOINS/5.1 Lecture_25_LEFT join.pdf | 219.01KB 12. JOINS/6. Right Join.mp4 | 36.00MB 12. JOINS/6. Right Join.srt | 6.63KB 12. JOINS/6.1 Lecture_26_RIGHT join.pdf | 221.83KB 12. JOINS/7. Full Outer Join.mp4 | 32.07MB 12. JOINS/7. Full Outer Join.srt | 4.85KB 12. JOINS/7.1 Lecture_27_OUTER join.pdf | 219.09KB 12. JOINS/8. Cross Join.mp4 | 18.76MB 12. JOINS/8. Cross Join.srt | 5.28KB 12. JOINS/8.1 Lecture_28_Cross join.pdf | 186.71KB 12. JOINS/9. Intersect and Intersect ALL.mp4 | 24.73MB 12. JOINS/9. Intersect and Intersect ALL.srt | 7.63KB 13. Subqueries/1. Subqueries.mp4 | 103.85MB 13. Subqueries/1. Subqueries.srt | 19.41KB 13. Subqueries/1.1 Lecture_31_SUBQUERY.pdf | 207.47KB 13. Subqueries/2. Exercise 11 Subqueries.mp4 | 5.11MB 13. Subqueries/2. Exercise 11 Subqueries.srt | 1.95KB 14. Views and Indexes/1. VIEWS.mp4 | 42.52MB 14. Views and Indexes/1. VIEWS.srt | 9.66KB 14. Views and Indexes/1.1 Lecture_32_VIEWS.pdf | 220.67KB 14. Views and Indexes/2. INDEX.mp4 | 40.34MB 14. Views and Indexes/2. INDEX.srt | 9.89KB 14. Views and Indexes/2.1 Lecture_33_INDEX.pdf | 201.61KB 14. Views and Indexes/3. Exercise 12 Views.mp4 | 3.20MB 14. Views and Indexes/3. Exercise 12 Views.srt | 1.25KB 15. String Functions/1. LENGTH.mp4 | 18.57MB 15. String Functions/1. LENGTH.srt | 4.58KB 15. String Functions/1.1 Lecture_34_STRING functions.pdf | 209.47KB 15. String Functions/2. UPPER LOWER.mp4 | 11.64MB 15. String Functions/2. UPPER LOWER.srt | 3.42KB 15. String Functions/3. REPLACE.mp4 | 25.26MB 15. String Functions/3. REPLACE.srt | 5.46KB 15. String Functions/4. TRIM, LTRIM, RTRIM.mp4 | 49.97MB 15. String Functions/4. TRIM, LTRIM, RTRIM.srt | 9.62KB 15. String Functions/5. CONCATENATION.mp4 | 16.91MB 15. String Functions/5. CONCATENATION.srt | 3.81KB 15. String Functions/6. SUBSTRING.mp4 | 42.30MB 15. String Functions/6. SUBSTRING.srt | 7.42KB 15. String Functions/7. LIST AGGREGATION.mp4 | 33.08MB 15. String Functions/7. LIST AGGREGATION.srt | 6.68KB 15. String Functions/8. Exercise 13 String Functions.mp4 | 16.46MB 15. String Functions/8. Exercise 13 String Functions.srt | 3.85KB 16. Mathematical Functions/1. CEIL & FLOOR.mp4 | 20.96MB 16. Mathematical Functions/1. CEIL & FLOOR.srt | 4.81KB 16. Mathematical Functions/1.1 Lecture_35_MATH functions.pdf | 192.89KB 16. Mathematical Functions/2. RANDOM.mp4 | 31.41MB 16. Mathematical Functions/2. RANDOM.srt | 6.62KB 16. Mathematical Functions/3. SETSEED.mp4 | 24.81MB 16. Mathematical Functions/3. SETSEED.srt | 4.48KB 16. Mathematical Functions/4. ROUND.mp4 | 16.76MB 16. Mathematical Functions/4. ROUND.srt | 3.15KB 16. Mathematical Functions/5. POWER.mp4 | 12.12MB 16. Mathematical Functions/5. POWER.srt | 3.12KB 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.mp4 | 10.34MB 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.srt | 2.51KB 16. Mathematical Functions/GetFreeCourses.Co.url | 116B 17. Date-Time Functions/1. CURRENT DATE & TIME.mp4 | 32.31MB 17. Date-Time Functions/1. CURRENT DATE & TIME.srt | 6.27KB 17. Date-Time Functions/1.1 Lecture_36_DATETIME functions.pdf | 232.41KB 17. Date-Time Functions/2. AGE.mp4 | 26.64MB 17. Date-Time Functions/2. AGE.srt | 4.21KB 17. Date-Time Functions/3. EXTRACT.mp4 | 58.65MB 17. Date-Time Functions/3. EXTRACT.srt | 10.28KB 17. Date-Time Functions/4. Exercise 15 Date-time functions.mp4 | 5.71MB 17. Date-Time Functions/4. Exercise 15 Date-time functions.srt | 1.90KB 18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.mp4 | 40.93MB 18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.srt | 11.24KB 18. PATTERN (STRING) MATCHING/1.1 Lecture_Pattern_Matching.pdf | 238.92KB 18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4 | 103.05MB 18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt | 18.49KB 18. PATTERN (STRING) MATCHING/2.1 User_table.txt | 242B 18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.mp4 | 8.31MB 18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.srt | 2.70KB 19. Window Functions/1. Introduction to Window functions.mp4 | 57.68MB 19. Window Functions/1. Introduction to Window functions.srt | 10.33KB 19. Window Functions/1.1 Windows Function PPT.pdf | 616.72KB 19. Window Functions/10. LAG and LEAD.mp4 | 70.64MB 19. Window Functions/10. LAG and LEAD.srt | 8.49KB 19. Window Functions/2. Introduction to Row number.mp4 | 37.54MB 19. Window Functions/2. Introduction to Row number.srt | 6.05KB 19. Window Functions/3. Implementing Row number in SQL.mp4 | 174.20MB 19. Window Functions/3. Implementing Row number in SQL.srt | 19.20KB 19. Window Functions/4. RANK and DENSERANK.mp4 | 54.72MB 19. Window Functions/4. RANK and DENSERANK.srt | 7.57KB 19. Window Functions/5. NTILE function.mp4 | 66.64MB 19. Window Functions/5. NTILE function.srt | 6.95KB 19. Window Functions/6. AVERAGE function.mp4 | 58.92MB 19. Window Functions/6. AVERAGE function.srt | 8.00KB 19. Window Functions/7. COUNT.mp4 | 31.62MB 19. Window Functions/7. COUNT.srt | 4.01KB 19. Window Functions/8. SUM TOTAL.mp4 | 87.45MB 19. Window Functions/8. SUM TOTAL.srt | 10.83KB 19. Window Functions/9. RUNNING TOTAL.mp4 | 64.22MB 19. Window Functions/9. RUNNING TOTAL.srt | 7.19KB 2. Installation and getting started/1. Installing PostgreSQL and pgAdmin in your PC.mp4 | 68.13MB 2. Installation and getting started/1. Installing PostgreSQL and pgAdmin in your PC.srt | 13.01KB 2. Installation and getting started/1.1 00 Debugging PostgreSQL installation issues.pdf | 253.44KB 2. Installation and getting started/1.2 Installing+PostgreSQL+on+Mac.pdf | 209.83KB 2. Installation and getting started/2. This is a milestone!.mp4 | 20.66MB 2. Installation and getting started/2. This is a milestone!.srt | 3.94KB 2. Installation and getting started/3. If pgAdmin is not opening....html | 1.55KB 2. Installation and getting started/4. Course Resources.html | 411B 20. COALESCE function/1. COALESCE function.mp4 | 42.61MB 20. COALESCE function/1. COALESCE function.srt | 6.13KB 20. COALESCE function/1.1 Windows Function PPT.pdf | 616.72KB 20. COALESCE function/GetFreeCourses.Co.url | 116B 21. Data Type conversion functions/1. Converting Numbers Date to String.mp4 | 73.18MB 21. Data Type conversion functions/1. Converting Numbers Date to String.srt | 13.05KB 21. Data Type conversion functions/1.1 Lecture_37_Conversion functions.pdf | 219.66KB 21. Data Type conversion functions/2. Converting String to Numbers Date.mp4 | 39.04MB 21. Data Type conversion functions/2. Converting String to Numbers Date.srt | 6.38KB 22. User Access Control Functions/1. User Access Control.mp4 | 80.48MB 22. User Access Control Functions/1. User Access Control.srt | 16.23KB 22. User Access Control Functions/1.1 Lecture_38_ACCESS control.pdf | 207.86KB 23. Nail that Interview!/1. Tablespace.mp4 | 36.28MB 23. Nail that Interview!/1. Tablespace.srt | 7.13KB 23. Nail that Interview!/1.1 Lecture_TABLESPACE.pdf | 188.68KB 23. Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.mp4 | 25.41MB 23. Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.srt | 8.58KB 23. Nail that Interview!/2.1 Lecture_5_Keys.pdf | 234.59KB 23. Nail that Interview!/3. ACID compliance.mp4 | 42.68MB 23. Nail that Interview!/3. ACID compliance.srt | 10.23KB 23. Nail that Interview!/3.1 Lecture_ACID.pdf | 190.69KB 23. Nail that Interview!/4. Truncate.mp4 | 21.09MB 23. Nail that Interview!/4. Truncate.srt | 5.34KB 23. Nail that Interview!/4.1 Lecture_TRUNCATE.pdf | 160.50KB 23. Nail that Interview!/5. Practice Test 1.html | 198B 23. Nail that Interview!/6. SQL Quiz.html | 198B 23. Nail that Interview!/GetFreeCourses.Co.url | 116B 24. Performance tuning tips/1. TIP 1 (EXPLAIN).mp4 | 25.50MB 24. Performance tuning tips/1. TIP 1 (EXPLAIN).srt | 4.22KB 24. Performance tuning tips/1.1 Lecture_Performance_Tuning.pdf | 285.00KB 24. Performance tuning tips/2. TIP 2.mp4 | 5.80MB 24. Performance tuning tips/2. TIP 2.srt | 1.76KB 24. Performance tuning tips/3. TIP 3.mp4 | 14.26MB 24. Performance tuning tips/3. TIP 3.srt | 4.07KB 24. Performance tuning tips/4. TIP 4 (VACCUM).mp4 | 2.86MB 24. Performance tuning tips/4. TIP 4 (VACCUM).srt | 777B 24. Performance tuning tips/5. TIP 5.mp4 | 11.46MB 24. Performance tuning tips/5. TIP 5.srt | 3.38KB 24. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).mp4 | 13.70MB 24. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).srt | 3.43KB 24. Performance tuning tips/7. TIP 7 (JOINS).mp4 | 10.81MB 24. Performance tuning tips/7. TIP 7 (JOINS).srt | 2.85KB 24. Performance tuning tips/8. TIP 8 (SCHEMAS).mp4 | 31.97MB 24. Performance tuning tips/8. TIP 8 (SCHEMAS).srt | 6.26KB 25. Final Section Database Basics/1. What is SQL.mp4 | 8.66MB 25. Final Section Database Basics/1. What is SQL.srt | 2.34KB 25. Final Section Database Basics/2. Tables and DBMS.mp4 | 14.68MB 25. Final Section Database Basics/2. Tables and DBMS.srt | 3.61KB 25. Final Section Database Basics/3. Types of SQL commands.mp4 | 22.07MB 25. Final Section Database Basics/3. Types of SQL commands.srt | 5.60KB 25. Final Section Database Basics/4. PostgreSQL.mp4 | 14.11MB 25. Final Section Database Basics/4. PostgreSQL.srt | 3.37KB 25. Final Section Database Basics/5. The final milestone!.mp4 | 11.85MB 25. Final Section Database Basics/5. The final milestone!.srt | 1.79KB 25. Final Section Database Basics/6. Bonus Lecture.html | 2.35KB 3. Case Study Demo/1. Case Study Part 1 - Business problems.mp4 | 37.75MB 3. Case Study Demo/1. Case Study Part 1 - Business problems.srt | 5.38KB 3. Case Study Demo/2. Case Study Part 2 - How SQL is Used.mp4 | 58.94MB 3. Case Study Demo/2. Case Study Part 2 - How SQL is Used.srt | 7.45KB 4. Fundamental SQL statements/1. CREATE.mp4 | 91.13MB 4. Fundamental SQL statements/1. CREATE.srt | 14.48KB 4. Fundamental SQL statements/10. Logical Operators.mp4 | 50.48MB 4. Fundamental SQL statements/10. Logical Operators.srt | 5.99KB 4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.mp4 | 7.18MB 4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.srt | 2.04KB 4. Fundamental SQL statements/12. UPDATE.mp4 | 37.67MB 4. Fundamental SQL statements/12. UPDATE.srt | 5.56KB 4. Fundamental SQL statements/12.1 Lecture_10_UPDATEDelete.pdf | 211.00KB 4. Fundamental SQL statements/13. DELETE.mp4 | 29.23MB 4. Fundamental SQL statements/13. DELETE.srt | 5.44KB 4. Fundamental SQL statements/14. ALTER.mp4 | 125.75MB 4. Fundamental SQL statements/14. ALTER.srt | 19.38KB 4. Fundamental SQL statements/14.1 Lecture_11_ALTER.pdf | 201.72KB 4. Fundamental SQL statements/15. Exercise 4 Updating Table.mp4 | 3.93MB 4. Fundamental SQL statements/15. Exercise 4 Updating Table.srt | 1.47KB 4. Fundamental SQL statements/16. Fundamental SQL statements.html | 198B 4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.mp4 | 5.88MB 4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.srt | 2.64KB 4. Fundamental SQL statements/3. Solutions to all Exercises.html | 120B 4. Fundamental SQL statements/3.1 Solution.pdf | 733.87KB 4. Fundamental SQL statements/4. INSERT.mp4 | 73.09MB 4. Fundamental SQL statements/4. INSERT.srt | 9.58KB 4. Fundamental SQL statements/5. Import data from File.mp4 | 42.01MB 4. Fundamental SQL statements/5. Import data from File.srt | 5.49KB 4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.mp4 | 4.59MB 4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.srt | 1.17KB 4. Fundamental SQL statements/6.1 Student.csv | 129B 4. Fundamental SQL statements/7. SELECT statement.mp4 | 31.83MB 4. Fundamental SQL statements/7. SELECT statement.srt | 4.60KB 4. Fundamental SQL statements/8. SELECT DISTINCT.mp4 | 46.19MB 4. Fundamental SQL statements/8. SELECT DISTINCT.srt | 6.07KB 4. Fundamental SQL statements/9. WHERE.mp4 | 32.56MB 4. Fundamental SQL statements/9. WHERE.srt | 4.15KB 5. Restore and Back-up/1. Restore and Back-up.mp4 | 72.10MB 5. Restore and Back-up/1. Restore and Back-up.srt | 9.84KB 5. Restore and Back-up/1.1 BackupFiles.zip | 585.82KB 5. Restore and Back-up/1.2 Supermart_DB.tar | 1.16MB 5. Restore and Back-up/2. Debugging restoration issues.mp4 | 50.18MB 5. Restore and Back-up/2. Debugging restoration issues.srt | 9.75KB 5. Restore and Back-up/3. Creating DB using CSV files.mp4 | 35.47MB 5. Restore and Back-up/3. Creating DB using CSV files.srt | 6.39KB 5. Restore and Back-up/4. Debugging summary and Code for CSV files.html | 2.46KB 5. Restore and Back-up/4.1 Customer.csv | 64.02KB 5. Restore and Back-up/4.2 Product.csv | 139.60KB 5. Restore and Back-up/4.3 Sales.csv | 983.71KB 5. Restore and Back-up/5. Exercise 5 Restore and Back-up.mp4 | 3.00MB 5. Restore and Back-up/5. Exercise 5 Restore and Back-up.srt | 1.31KB 6. Selection commands Filtering/1. IN.mp4 | 29.41MB 6. Selection commands Filtering/1. IN.srt | 5.29KB 6. Selection commands Filtering/1.1 Lecture_12_IN_12.pdf | 157.38KB 6. Selection commands Filtering/2. BETWEEN.mp4 | 49.73MB 6. Selection commands Filtering/2. BETWEEN.srt | 6.55KB 6. Selection commands Filtering/2.1 Lecture_13_BETWEEN.pdf | 187.63KB 6. Selection commands Filtering/3. LIKE.mp4 | 61.17MB 6. Selection commands Filtering/3. LIKE.srt | 12.26KB 6. Selection commands Filtering/3.1 Lecture_14_LIKE.pdf | 173.67KB 6. Selection commands Filtering/4. Exercise 6 In, Like & Between.mp4 | 5.25MB 6. Selection commands Filtering/4. Exercise 6 In, Like & Between.srt | 973B 6. Selection commands Filtering/GetFreeCourses.Co.url | 116B 7. Selection commands Ordering/1. Side Lecture Commenting in SQL.mp4 | 12.30MB 7. Selection commands Ordering/1. Side Lecture Commenting in SQL.srt | 1.97KB 7. Selection commands Ordering/2. ORDER BY.mp4 | 71.37MB 7. Selection commands Ordering/2. ORDER BY.srt | 10.36KB 7. Selection commands Ordering/2.1 Lecture_15_ORDER BY.pdf | 180.15KB 7. Selection commands Ordering/3. LIMIT.mp4 | 29.61MB 7. Selection commands Ordering/3. LIMIT.srt | 5.08KB 7. Selection commands Ordering/3.1 Lecture_16_LIMIT.pdf | 162.11KB 7. Selection commands Ordering/4. Exercise 7 Sorting.mp4 | 3.17MB 7. Selection commands Ordering/4. Exercise 7 Sorting.srt | 1.06KB 8. Alias/1. AS.mp4 | 25.58MB 8. Alias/1. AS.srt | 4.93KB 8. Alias/1.1 Lecture_17_AS.pdf | 151.75KB 8. Alias/1.2 Lecture_17_AS.pdf | 151.75KB 9. Aggregate Commands/1. COUNT.mp4 | 38.36MB 9. Aggregate Commands/1. COUNT.srt | 6.77KB 9. Aggregate Commands/1.1 Lecture_18_count.pdf | 158.20KB 9. Aggregate Commands/2. SUM.mp4 | 21.06MB 9. Aggregate Commands/2. SUM.srt | 3.76KB 9. Aggregate Commands/2.1 Lecture_19_SUM.pdf | 162.88KB 9. Aggregate Commands/3. AVERAGE.mp4 | 17.52MB 9. Aggregate Commands/3. AVERAGE.srt | 3.46KB 9. Aggregate Commands/3.1 Lecture_20_AVG.pdf | 157.54KB 9. Aggregate Commands/4. MIN & MAX.mp4 | 32.48MB 9. Aggregate Commands/4. MIN & MAX.srt | 4.78KB 9. Aggregate Commands/4.1 Lecture_21_MIN&MAX.pdf | 164.14KB 9. Aggregate Commands/5. Exercise 8 Aggregate functions.mp4 | 6.43MB 9. Aggregate Commands/5. Exercise 8 Aggregate functions.srt | 2.00KB 9. Aggregate Commands/6. Quiz.html | 198B Download Paid Udemy Courses For Free.url | 116B GetFreeCourses.Co.url | 116B