GetFreeCourses.Co-Udemy-SQL Masterclass SQL for Data Analytics 收录时间:2024-09-18 07:27:28 文件大小:4GB 下载次数:1 最近下载:2024-09-18 07:27:28 磁力链接: magnet:?xt=urn:btih:a77f9ff0d66eb3b2e48d12c30a40dcd3ef062de0 立即下载 复制链接 文件列表 19. Window Functions/3. Implementing Row number in SQL.mp4 174MB 4. Fundamental SQL statements/14. ALTER.mp4 126MB 13. Subqueries/1. Subqueries.mp4 104MB 18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4 103MB 10. Group By Commands/1. GROUP BY.mp4 93MB 4. Fundamental SQL statements/1. CREATE.mp4 91MB 19. Window Functions/8. SUM TOTAL.mp4 87MB 22. User Access Control Functions/1. User Access Control.mp4 80MB 21. Data Type conversion functions/1. Converting Numbers Date to String.mp4 73MB 4. Fundamental SQL statements/4. INSERT.mp4 73MB 5. Restore and Back-up/1. Restore and Back-up.mp4 72MB 7. Selection commands Ordering/2. ORDER BY.mp4 71MB 19. Window Functions/10. LAG and LEAD.mp4 71MB 2. Installation and getting started/1. Installing PostgreSQL and pgAdmin in your PC.mp4 68MB 19. Window Functions/5. NTILE function.mp4 67MB 19. Window Functions/9. RUNNING TOTAL.mp4 64MB 6. Selection commands Filtering/3. LIKE.mp4 61MB 12. JOINS/2. Concepts of Joining and Combining Data.mp4 60MB 3. Case Study Demo/2. Case Study Part 2 - How SQL is Used.mp4 59MB 19. Window Functions/6. AVERAGE function.mp4 59MB 17. Date-Time Functions/3. EXTRACT.mp4 59MB 19. Window Functions/1. Introduction to Window functions.mp4 58MB 19. Window Functions/4. RANK and DENSERANK.mp4 55MB 4. Fundamental SQL statements/10. Logical Operators.mp4 50MB 5. Restore and Back-up/2. Debugging restoration issues.mp4 50MB 15. String Functions/4. TRIM, LTRIM, RTRIM.mp4 50MB 6. Selection commands Filtering/2. BETWEEN.mp4 50MB 12. JOINS/4. Inner Join.mp4 47MB 4. Fundamental SQL statements/8. SELECT DISTINCT.mp4 46MB 23. Nail that Interview!/3. ACID compliance.mp4 43MB 20. COALESCE function/1. COALESCE function.mp4 43MB 14. Views and Indexes/1. VIEWS.mp4 43MB 15. String Functions/6. SUBSTRING.mp4 42MB 4. Fundamental SQL statements/5. Import data from File.mp4 42MB 18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.mp4 41MB 14. Views and Indexes/2. INDEX.mp4 40MB 21. Data Type conversion functions/2. Converting String to Numbers Date.mp4 39MB 9. Aggregate Commands/1. COUNT.mp4 38MB 10. Group By Commands/2. HAVING.mp4 38MB 3. Case Study Demo/1. Case Study Part 1 - Business problems.mp4 38MB 4. Fundamental SQL statements/12. UPDATE.mp4 38MB 19. Window Functions/2. Introduction to Row number.mp4 38MB 12. JOINS/5. Left Join.mp4 37MB 23. Nail that Interview!/1. Tablespace.mp4 36MB 12. JOINS/6. Right Join.mp4 36MB 5. Restore and Back-up/3. Creating DB using CSV files.mp4 35MB 15. String Functions/7. LIST AGGREGATION.mp4 33MB 4. Fundamental SQL statements/9. WHERE.mp4 33MB 9. Aggregate Commands/4. MIN & MAX.mp4 32MB 17. Date-Time Functions/1. CURRENT DATE & TIME.mp4 32MB 12. JOINS/7. Full Outer Join.mp4 32MB 24. Performance tuning tips/8. TIP 8 (SCHEMAS).mp4 32MB 4. Fundamental SQL statements/7. SELECT statement.mp4 32MB 19. Window Functions/7. COUNT.mp4 32MB 16. Mathematical Functions/2. RANDOM.mp4 31MB 1. Introduction/1. Introduction.mp4 30MB 7. Selection commands Ordering/3. LIMIT.mp4 30MB 6. Selection commands Filtering/1. IN.mp4 29MB 4. Fundamental SQL statements/13. DELETE.mp4 29MB 11. Conditional Statement/1. CASE WHEN.mp4 29MB 17. Date-Time Functions/2. AGE.mp4 27MB 8. Alias/1. AS.mp4 26MB 24. Performance tuning tips/1. TIP 1 (EXPLAIN).mp4 25MB 23. Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.mp4 25MB 15. String Functions/3. REPLACE.mp4 25MB 16. Mathematical Functions/3. SETSEED.mp4 25MB 12. JOINS/9. Intersect and Intersect ALL.mp4 25MB 25. Final Section Database Basics/3. Types of SQL commands.mp4 22MB 23. Nail that Interview!/4. Truncate.mp4 21MB 9. Aggregate Commands/2. SUM.mp4 21MB 16. Mathematical Functions/1. CEIL & FLOOR.mp4 21MB 2. Installation and getting started/2. This is a milestone!.mp4 21MB 12. JOINS/8. Cross Join.mp4 19MB 15. String Functions/1. LENGTH.mp4 19MB 9. Aggregate Commands/3. AVERAGE.mp4 18MB 15. String Functions/5. CONCATENATION.mp4 17MB 16. Mathematical Functions/4. ROUND.mp4 17MB 15. String Functions/8. Exercise 13 String Functions.mp4 16MB 12. JOINS/11. Union.mp4 15MB 25. Final Section Database Basics/2. Tables and DBMS.mp4 15MB 24. Performance tuning tips/3. TIP 3.mp4 14MB 25. Final Section Database Basics/4. PostgreSQL.mp4 14MB 12. JOINS/3. Preparing the data.mp4 14MB 24. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).mp4 14MB 12. JOINS/10. Except.mp4 13MB 7. Selection commands Ordering/1. Side Lecture Commenting in SQL.mp4 12MB 16. Mathematical Functions/5. POWER.mp4 12MB 25. Final Section Database Basics/5. The final milestone!.mp4 12MB 15. String Functions/2. UPPER LOWER.mp4 12MB 24. Performance tuning tips/5. TIP 5.mp4 11MB 24. Performance tuning tips/7. TIP 7 (JOINS).mp4 11MB 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.mp4 10MB 25. Final Section Database Basics/1. What is SQL.mp4 9MB 18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.mp4 8MB 12. JOINS/1. Introduction to Joins.mp4 8MB 4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.mp4 7MB 12. JOINS/12. Exercise 10 Joins.mp4 7MB 9. Aggregate Commands/5. Exercise 8 Aggregate functions.mp4 6MB 10. Group By Commands/3. Exercise 9 Group By.mp4 6MB 4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.mp4 6MB 24. Performance tuning tips/2. TIP 2.mp4 6MB 17. Date-Time Functions/4. Exercise 15 Date-time functions.mp4 6MB 6. Selection commands Filtering/4. Exercise 6 In, Like & Between.mp4 5MB 13. Subqueries/2. Exercise 11 Subqueries.mp4 5MB 4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.mp4 5MB 4. Fundamental SQL statements/15. Exercise 4 Updating Table.mp4 4MB 14. Views and Indexes/3. Exercise 12 Views.mp4 3MB 7. Selection commands Ordering/4. Exercise 7 Sorting.mp4 3MB 5. Restore and Back-up/5. Exercise 5 Restore and Back-up.mp4 3MB 24. Performance tuning tips/4. TIP 4 (VACCUM).mp4 3MB 5. Restore and Back-up/1.2 Supermart_DB.tar 1MB 5. Restore and Back-up/4.3 Sales.csv 984KB 4. Fundamental SQL statements/3.1 Solution.pdf 734KB 19. Window Functions/1.1 Windows Function PPT.pdf 617KB 20. COALESCE function/1.1 Windows Function PPT.pdf 617KB 5. Restore and Back-up/1.1 BackupFiles.zip 586KB 24. Performance tuning tips/1.1 Lecture_Performance_Tuning.pdf 285KB 2. Installation and getting started/1.1 00 Debugging PostgreSQL installation issues.pdf 253KB 18. PATTERN (STRING) MATCHING/1.1 Lecture_Pattern_Matching.pdf 239KB 23. Nail that Interview!/2.1 Lecture_5_Keys.pdf 235KB 17. Date-Time Functions/1.1 Lecture_36_DATETIME functions.pdf 232KB 12. JOINS/6.1 Lecture_26_RIGHT join.pdf 222KB 14. Views and Indexes/1.1 Lecture_32_VIEWS.pdf 221KB 21. Data Type conversion functions/1.1 Lecture_37_Conversion functions.pdf 220KB 12. JOINS/7.1 Lecture_27_OUTER join.pdf 219KB 12. JOINS/5.1 Lecture_25_LEFT join.pdf 219KB 12. JOINS/4.1 Lecture_24_INNER join.pdf 214KB 4. Fundamental SQL statements/12.1 Lecture_10_UPDATEDelete.pdf 211KB 2. Installation and getting started/1.2 Installing+PostgreSQL+on+Mac.pdf 210KB 15. String Functions/1.1 Lecture_34_STRING functions.pdf 209KB 22. User Access Control Functions/1.1 Lecture_38_ACCESS control.pdf 208KB 13. Subqueries/1.1 Lecture_31_SUBQUERY.pdf 207KB 4. Fundamental SQL statements/14.1 Lecture_11_ALTER.pdf 202KB 14. Views and Indexes/2.1 Lecture_33_INDEX.pdf 202KB 16. Mathematical Functions/1.1 Lecture_35_MATH functions.pdf 193KB 23. Nail that Interview!/3.1 Lecture_ACID.pdf 191KB 23. Nail that Interview!/1.1 Lecture_TABLESPACE.pdf 189KB 6. Selection commands Filtering/2.1 Lecture_13_BETWEEN.pdf 188KB 12. JOINS/8.1 Lecture_28_Cross join.pdf 187KB 7. Selection commands Ordering/2.1 Lecture_15_ORDER BY.pdf 180KB 10. Group By Commands/1.1 Lecture_22_group by.pdf 175KB 12. JOINS/10.1 Lecture_29_EXCEPT.pdf 174KB 6. Selection commands Filtering/3.1 Lecture_14_LIKE.pdf 174KB 12. JOINS/11.1 Lecture_30_UNION.pdf 167KB 10. Group By Commands/2.1 Lecture_23_HAVING.pdf 167KB 9. Aggregate Commands/4.1 Lecture_21_MIN&MAX.pdf 164KB 9. Aggregate Commands/2.1 Lecture_19_SUM.pdf 163KB 7. Selection commands Ordering/3.1 Lecture_16_LIMIT.pdf 162KB 23. Nail that Interview!/4.1 Lecture_TRUNCATE.pdf 161KB 11. Conditional Statement/1.1 Lecture_CASE.pdf 160KB 9. Aggregate Commands/1.1 Lecture_18_count.pdf 158KB 9. Aggregate Commands/3.1 Lecture_20_AVG.pdf 158KB 6. Selection commands Filtering/1.1 Lecture_12_IN_12.pdf 157KB 8. Alias/1.1 Lecture_17_AS.pdf 152KB 8. Alias/1.2 Lecture_17_AS.pdf 152KB 5. Restore and Back-up/4.2 Product.csv 140KB 5. Restore and Back-up/4.1 Customer.csv 64KB 13. Subqueries/1. Subqueries.srt 19KB 4. Fundamental SQL statements/14. ALTER.srt 19KB 19. Window Functions/3. Implementing Row number in SQL.srt 19KB 18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt 18KB 22. User Access Control Functions/1. User Access Control.srt 16KB 4. Fundamental SQL statements/1. CREATE.srt 14KB 10. Group By Commands/1. GROUP BY.srt 14KB 12. JOINS/2. Concepts of Joining and Combining Data.srt 13KB 21. Data Type conversion functions/1. Converting Numbers Date to String.srt 13KB 2. Installation and getting started/1. Installing PostgreSQL and pgAdmin in your PC.srt 13KB 6. Selection commands Filtering/3. LIKE.srt 12KB 18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.srt 11KB 19. Window Functions/8. SUM TOTAL.srt 11KB 7. Selection commands Ordering/2. ORDER BY.srt 10KB 19. Window Functions/1. Introduction to Window functions.srt 10KB 17. Date-Time Functions/3. EXTRACT.srt 10KB 23. Nail that Interview!/3. ACID compliance.srt 10KB 14. Views and Indexes/2. INDEX.srt 10KB 5. Restore and Back-up/1. Restore and Back-up.srt 10KB 5. Restore and Back-up/2. Debugging restoration issues.srt 10KB 14. Views and Indexes/1. VIEWS.srt 10KB 15. String Functions/4. TRIM, LTRIM, RTRIM.srt 10KB 4. Fundamental SQL statements/4. INSERT.srt 10KB 23. Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.srt 9KB 19. Window Functions/10. LAG and LEAD.srt 8KB 12. JOINS/5. Left Join.srt 8KB 19. Window Functions/6. AVERAGE function.srt 8KB 12. JOINS/4. Inner Join.srt 8KB 12. JOINS/9. Intersect and Intersect ALL.srt 8KB 19. Window Functions/4. RANK and DENSERANK.srt 8KB 3. Case Study Demo/2. Case Study Part 2 - How SQL is Used.srt 7KB 15. String Functions/6. SUBSTRING.srt 7KB 19. Window Functions/9. RUNNING TOTAL.srt 7KB 23. Nail that Interview!/1. Tablespace.srt 7KB 19. Window Functions/5. NTILE function.srt 7KB 9. Aggregate Commands/1. COUNT.srt 7KB 15. String Functions/7. LIST AGGREGATION.srt 7KB 11. Conditional Statement/1. CASE WHEN.srt 7KB 12. JOINS/6. Right Join.srt 7KB 16. Mathematical Functions/2. RANDOM.srt 7KB 6. Selection commands Filtering/2. BETWEEN.srt 7KB 5. Restore and Back-up/3. Creating DB using CSV files.srt 6KB 21. Data Type conversion functions/2. Converting String to Numbers Date.srt 6KB 17. Date-Time Functions/1. CURRENT DATE & TIME.srt 6KB 24. Performance tuning tips/8. TIP 8 (SCHEMAS).srt 6KB 20. COALESCE function/1. COALESCE function.srt 6KB 4. Fundamental SQL statements/8. SELECT DISTINCT.srt 6KB 19. Window Functions/2. Introduction to Row number.srt 6KB 4. Fundamental SQL statements/10. Logical Operators.srt 6KB 25. Final Section Database Basics/3. Types of SQL commands.srt 6KB 4. Fundamental SQL statements/12. UPDATE.srt 6KB 4. Fundamental SQL statements/5. Import data from File.srt 5KB 15. String Functions/3. REPLACE.srt 5KB 4. Fundamental SQL statements/13. DELETE.srt 5KB 10. Group By Commands/2. HAVING.srt 5KB 3. Case Study Demo/1. Case Study Part 1 - Business problems.srt 5KB 23. Nail that Interview!/4. Truncate.srt 5KB 6. Selection commands Filtering/1. IN.srt 5KB 12. JOINS/8. Cross Join.srt 5KB 7. Selection commands Ordering/3. LIMIT.srt 5KB 8. Alias/1. AS.srt 5KB 1. Introduction/1. Introduction.srt 5KB 12. JOINS/7. Full Outer Join.srt 5KB 16. Mathematical Functions/1. CEIL & FLOOR.srt 5KB 9. Aggregate Commands/4. MIN & MAX.srt 5KB 4. Fundamental SQL statements/7. SELECT statement.srt 5KB 15. String Functions/1. LENGTH.srt 5KB 16. Mathematical Functions/3. SETSEED.srt 4KB 24. Performance tuning tips/1. TIP 1 (EXPLAIN).srt 4KB 17. Date-Time Functions/2. AGE.srt 4KB 4. Fundamental SQL statements/9. WHERE.srt 4KB 24. Performance tuning tips/3. TIP 3.srt 4KB 19. Window Functions/7. COUNT.srt 4KB 2. Installation and getting started/2. This is a milestone!.srt 4KB 15. String Functions/8. Exercise 13 String Functions.srt 4KB 15. String Functions/5. CONCATENATION.srt 4KB 9. Aggregate Commands/2. SUM.srt 4KB 25. Final Section Database Basics/2. Tables and DBMS.srt 4KB 12. JOINS/11. Union.srt 3KB 12. JOINS/10. Except.srt 3KB 9. Aggregate Commands/3. AVERAGE.srt 3KB 24. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).srt 3KB 15. String Functions/2. UPPER LOWER.srt 3KB 24. Performance tuning tips/5. TIP 5.srt 3KB 25. Final Section Database Basics/4. PostgreSQL.srt 3KB 16. Mathematical Functions/4. ROUND.srt 3KB 16. Mathematical Functions/5. POWER.srt 3KB 12. JOINS/1. Introduction to Joins.srt 3KB 24. Performance tuning tips/7. TIP 7 (JOINS).srt 3KB 18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.srt 3KB 4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.srt 3KB 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.srt 3KB 5. Restore and Back-up/4. Debugging summary and Code for CSV files.html 2KB 25. Final Section Database Basics/6. Bonus Lecture.html 2KB 25. Final Section Database Basics/1. What is SQL.srt 2KB 12. JOINS/3. Preparing the data.srt 2KB 4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.srt 2KB 9. Aggregate Commands/5. Exercise 8 Aggregate functions.srt 2KB 7. Selection commands Ordering/1. Side Lecture Commenting in SQL.srt 2KB 13. Subqueries/2. Exercise 11 Subqueries.srt 2KB 17. Date-Time Functions/4. Exercise 15 Date-time functions.srt 2KB 10. Group By Commands/3. Exercise 9 Group By.srt 2KB 25. Final Section Database Basics/5. The final milestone!.srt 2KB 24. Performance tuning tips/2. TIP 2.srt 2KB 12. JOINS/12. Exercise 10 Joins.srt 2KB 2. Installation and getting started/3. If pgAdmin is not opening....html 2KB 4. Fundamental SQL statements/15. Exercise 4 Updating Table.srt 1KB 5. Restore and Back-up/5. Exercise 5 Restore and Back-up.srt 1KB 14. Views and Indexes/3. Exercise 12 Views.srt 1KB 4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.srt 1KB 7. Selection commands Ordering/4. Exercise 7 Sorting.srt 1KB 6. Selection commands Filtering/4. Exercise 6 In, Like & Between.srt 973B 24. Performance tuning tips/4. TIP 4 (VACCUM).srt 777B 12. JOINS/1.1 Lecture_24_Joins_Query.txt 417B 12. JOINS/3.1 M3_T1_V3 Joins_Query.txt 417B 2. Installation and getting started/4. Course Resources.html 411B 18. PATTERN (STRING) MATCHING/2.1 User_table.txt 242B 10. Group By Commands/4. Quiz.html 198B 12. JOINS/13. Quiz.html 198B 23. Nail that Interview!/5. Practice Test 1.html 198B 23. Nail that Interview!/6. SQL Quiz.html 198B 4. Fundamental SQL statements/16. Fundamental SQL statements.html 198B 9. Aggregate Commands/6. Quiz.html 198B 4. Fundamental SQL statements/6.1 Student.csv 129B 4. Fundamental SQL statements/3. Solutions to all Exercises.html 120B 11. Conditional Statement/GetFreeCourses.Co.url 116B 16. Mathematical Functions/GetFreeCourses.Co.url 116B 20. COALESCE function/GetFreeCourses.Co.url 116B 23. Nail that Interview!/GetFreeCourses.Co.url 116B 6. Selection commands Filtering/GetFreeCourses.Co.url 116B Download Paid Udemy Courses For Free.url 116B GetFreeCourses.Co.url 116B