589689.xyz

[] Udemy - Master SQL For Data Science

  • 收录时间:2019-11-25 03:42:58
  • 文件大小:1GB
  • 下载次数:70
  • 最近下载:2021-01-15 07:54:46
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 10. Window Functions for Analytics/5. Working with Rollups and Cubes.mp4 112MB
  2. 10. Window Functions for Analytics/3. RANK, FIRST_VALUE and NTILE Functions.mp4 111MB
  3. 9. Working with Multiple Tables/6. Creating Views vs. Inline Views.mp4 80MB
  4. 2. Database Basics/4. Install Postgres on Windows.mp4 72MB
  5. 10. Window Functions for Analytics/4. LEAD and LAG Functions.mp4 63MB
  6. 1. Chapter 1/1. Course Overview.mp4 53MB
  7. 2. Database Basics/5. Create Table and Insert Statements.mp4 43MB
  8. 9. Working with Multiple Tables/2. INNER and OUTER Joins + [EXERCISES].mp4 41MB
  9. 3. SQL Query Basics/2. Filter Data Using the WHERE Clause + AND & OR.mp4 40MB
  10. 2. Database Basics/7. Prepare the Database.mp4 40MB
  11. 10. Window Functions for Analytics/2. Ordering Data in Window Frames.mp4 35MB
  12. 7. Using the CASE Clause in Interesting Ways/1. Conditional Expressions Using CASE Clause + [EXERCISES].mp4 33MB
  13. 6. Using Subqueries/4. Subqueries with ANY and ALL Operators + [EXERCISES].mp4 33MB
  14. 3. SQL Query Basics/1. Introducing the SELECT Statement.mp4 33MB
  15. 8. Advanced Query Techniques using Correlated Subqueries/1. Understanding Correlated Subqueries.mp4 32MB
  16. 7. Using the CASE Clause in Interesting Ways/2. Transposing Data using the CASE Clause + [EXERCISES].mp4 30MB
  17. 3. SQL Query Basics/3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4 30MB
  18. 10. Window Functions for Analytics/1. Window Functions using the OVER() Clause.mp4 30MB
  19. 6. Using Subqueries/3. Subqueries Continued + [EXERCISES].mp4 30MB
  20. 9. Working with Multiple Tables/5. [EXERCISES] Joins and Subqueries Continued.mp4 27MB
  21. 8. Advanced Query Techniques using Correlated Subqueries/2. [EXERCISES] Correlated Subqueries Continued.mp4 26MB
  22. 5. Grouping Data and Computing Aggregates/3. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4 26MB
  23. 5. Grouping Data and Computing Aggregates/2. GROUP BY & HAVING Clauses.mp4 26MB
  24. 9. Working with Multiple Tables/1. Introducing Table Joins.mp4 26MB
  25. 4. Using Functions/1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4 25MB
  26. 6. Using Subqueries/2. Introducing Subqueries.mp4 24MB
  27. 4. Using Functions/2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4 24MB
  28. 6. Using Subqueries/5. [EXERCISES] More Practice with Subqueries.mp4 22MB
  29. 3. SQL Query Basics/5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4 21MB
  30. 9. Working with Multiple Tables/3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 21MB
  31. 3. SQL Query Basics/4. [EXERCISES] WHERE Clause and Operators.mp4 19MB
  32. 4. Using Functions/3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4 16MB
  33. 2. Database Basics/1. What is a Database.mp4 15MB
  34. 2. Database Basics/2. Install Postgres Database on Mac.mp4 13MB
  35. 9. Working with Multiple Tables/4. Cartesian Product with the CROSS JOIN.mp4 12MB
  36. 6. Using Subqueries/1. Aliasing Sources of Data.mp4 9MB
  37. 5. Grouping Data and Computing Aggregates/1. Understanding Grouping.mp4 9MB
  38. 2. Database Basics/7.1 mock_data.sql.sql 120KB
  39. 9. Working with Multiple Tables/2. INNER and OUTER Joins + [EXERCISES].vtt 31KB
  40. 3. SQL Query Basics/2. Filter Data Using the WHERE Clause + AND & OR.vtt 28KB
  41. 2. Database Basics/5. Create Table and Insert Statements.vtt 26KB
  42. 10. Window Functions for Analytics/2. Ordering Data in Window Frames.vtt 25KB
  43. 8. Advanced Query Techniques using Correlated Subqueries/1. Understanding Correlated Subqueries.vtt 25KB
  44. 7. Using the CASE Clause in Interesting Ways/1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt 24KB
  45. 10. Window Functions for Analytics/1. Window Functions using the OVER() Clause.vtt 24KB
  46. 6. Using Subqueries/4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt 23KB
  47. 6. Using Subqueries/3. Subqueries Continued + [EXERCISES].vtt 22KB
  48. 3. SQL Query Basics/1. Introducing the SELECT Statement.vtt 21KB
  49. 5. Grouping Data and Computing Aggregates/3. [EXERCISES] Using GROUP BY and HAVING Clauses.vtt 21KB
  50. 5. Grouping Data and Computing Aggregates/2. GROUP BY & HAVING Clauses.vtt 21KB
  51. 7. Using the CASE Clause in Interesting Ways/2. Transposing Data using the CASE Clause + [EXERCISES].vtt 21KB
  52. 9. Working with Multiple Tables/5. [EXERCISES] Joins and Subqueries Continued.vtt 20KB
  53. 4. Using Functions/2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt 20KB
  54. 4. Using Functions/1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt 20KB
  55. 9. Working with Multiple Tables/1. Introducing Table Joins.vtt 19KB
  56. 8. Advanced Query Techniques using Correlated Subqueries/2. [EXERCISES] Correlated Subqueries Continued.vtt 19KB
  57. 3. SQL Query Basics/3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt 19KB
  58. 9. Working with Multiple Tables/3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt 19KB
  59. 6. Using Subqueries/5. [EXERCISES] More Practice with Subqueries.vtt 18KB
  60. 2. Database Basics/7. Prepare the Database.vtt 17KB
  61. 6. Using Subqueries/2. Introducing Subqueries.vtt 17KB
  62. 10. Window Functions for Analytics/3. RANK, FIRST_VALUE and NTILE Functions.vtt 15KB
  63. 10. Window Functions for Analytics/5. Working with Rollups and Cubes.vtt 14KB
  64. 3. SQL Query Basics/5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.vtt 14KB
  65. 3. SQL Query Basics/4. [EXERCISES] WHERE Clause and Operators.vtt 14KB
  66. 4. Using Functions/3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().vtt 13KB
  67. 9. Working with Multiple Tables/6. Creating Views vs. Inline Views.vtt 12KB
  68. 2. Database Basics/1. What is a Database.vtt 12KB
  69. 2. Database Basics/4. Install Postgres on Windows.vtt 10KB
  70. 10. Window Functions for Analytics/4. LEAD and LAG Functions.vtt 10KB
  71. 2. Database Basics/2. Install Postgres Database on Mac.vtt 9KB
  72. 9. Working with Multiple Tables/4. Cartesian Product with the CROSS JOIN.vtt 8KB
  73. 6. Using Subqueries/1. Aliasing Sources of Data.vtt 8KB
  74. 5. Grouping Data and Computing Aggregates/1. Understanding Grouping.vtt 7KB
  75. 1. Chapter 1/1. Course Overview.vtt 6KB
  76. 2. Database Basics/3. Troubleshoot Connection.html 1KB
  77. 11. Difficult Query Challenges/2. Get Access to All of my current and future courses!.html 1021B
  78. 10. Window Functions for Analytics/5.1 sales_tbl.txt.txt 696B
  79. 2. Database Basics/6. Data file that will be used in the course (IMPORTANT).html 444B
  80. 11. Difficult Query Challenges/1. Challenging Puzzles For the Brave.html 135B
  81. 2. Database Basics/8. Create More Tables and Populate Data.html 135B
  82. 3. SQL Query Basics/6. Practice Writing Basic Queries (5 Problems).html 135B
  83. 4. Using Functions/4. Practice with Functions, Conditional Expressions and Concatenation.html 135B
  84. 5. Grouping Data and Computing Aggregates/4. Practice Aggregation Queries.html 135B
  85. 6. Using Subqueries/6. Practice with Subqueries.html 135B
  86. 7. Using the CASE Clause in Interesting Ways/3. Practice Using Case and Transposing Data.html 135B
  87. 9. Working with Multiple Tables/7. ADVANCED Problems using Joins, Grouping and Subqueries.html 135B
  88. [Tutorialsplanet.NET].url 128B