589689.xyz

[] Udemy - SQL Masterclass SQL for Data Analytics

  • 收录时间:2021-03-18 12:46:31
  • 文件大小:3GB
  • 下载次数:1
  • 最近下载:2021-03-18 12:46:30
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 4. Fundamental SQL statements/14. ALTER.mp4 126MB
  2. 13. Subqueries/1. Subqueries.mp4 104MB
  3. 18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4 103MB
  4. 10. Group By Commands/1. GROUP BY.mp4 93MB
  5. 20. User Access Control Functions/1. User Access Control.mp4 80MB
  6. 19. Data Type conversion functions/1. Converting Numbers Date to String.mp4 73MB
  7. 5. Restore and Back-up/1. Restore and Back-up.mp4 72MB
  8. 7. Selection commands Ordering/2. ORDER BY.mp4 71MB
  9. 4. Fundamental SQL statements/1. CREATE.mp4 64MB
  10. 6. Selection commands Filtering/3. LIKE.mp4 61MB
  11. 12. JOINS/2. Inner Join.mp4 59MB
  12. 2. Installation and getting started/1. Installing and setting up PostgreSQL.mp4 59MB
  13. 17. Date-Time Functions/3. EXTRACT.mp4 59MB
  14. 4. Fundamental SQL statements/4. INSERT.mp4 56MB
  15. 3. Case Study Demo/3. Case Study Part 2.mp4 51MB
  16. 12. JOINS/3. Left Join.mp4 50MB
  17. 15. String Functions/4. TRIM, LTRIM, RTRIM.mp4 50MB
  18. 6. Selection commands Filtering/2. BETWEEN.mp4 50MB
  19. 12. JOINS/4. Right Join.mp4 49MB
  20. 4. Fundamental SQL statements/8. SELECT DISTINCT.mp4 43MB
  21. 21. Bonus Section Nail that Interview!/3. ACID compliance.mp4 43MB
  22. 14. Views and Indexes/1. VIEWS.mp4 43MB
  23. 15. String Functions/6. SUBSTRING.mp4 42MB
  24. 4. Fundamental SQL statements/10. Logical Operators.mp4 42MB
  25. 18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.mp4 41MB
  26. 14. Views and Indexes/2. INDEX.mp4 40MB
  27. 12. JOINS/5. Full Outer Join.mp4 39MB
  28. 19. Data Type conversion functions/2. Converting String to Numbers Date.mp4 39MB
  29. 9. Aggregate Commands/1. COUNT.mp4 38MB
  30. 10. Group By Commands/2. HAVING.mp4 38MB
  31. 4. Fundamental SQL statements/12. UPDATE.mp4 38MB
  32. 21. Bonus Section Nail that Interview!/1. Tablespace.mp4 36MB
  33. 15. String Functions/7. LIST AGGREGATION.mp4 33MB
  34. 4. Fundamental SQL statements/5. Import data from File.mp4 33MB
  35. 9. Aggregate Commands/4. MIN & MAX.mp4 32MB
  36. 17. Date-Time Functions/1. CURRENT DATE & TIME.mp4 32MB
  37. 22. Performance tuning tips/8. TIP 8 (SCHEMAS).mp4 32MB
  38. 16. Mathematical Functions/2. RANDOM.mp4 31MB
  39. 7. Selection commands Ordering/3. LIMIT.mp4 30MB
  40. 6. Selection commands Filtering/1. IN.mp4 29MB
  41. 1. Introduction/1. Course Overview.mp4 29MB
  42. 4. Fundamental SQL statements/13. DELETE.mp4 29MB
  43. 11. Conditional Statement/1. CASE WHEN.mp4 29MB
  44. 3. Case Study Demo/2. Case Study Part 1.mp4 28MB
  45. 4. Fundamental SQL statements/9. WHERE.mp4 28MB
  46. 4. Fundamental SQL statements/7. SELECT statement.mp4 27MB
  47. 17. Date-Time Functions/2. AGE.mp4 27MB
  48. 12. JOINS/6. Cross Join.mp4 26MB
  49. 8. Alias/1. AS.mp4 26MB
  50. 22. Performance tuning tips/1. TIP 1 (EXPLAIN).mp4 25MB
  51. 21. Bonus Section Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.mp4 25MB
  52. 23. Bonus Section Database Basics/3. Types of SQL commands.mp4 25MB
  53. 15. String Functions/3. REPLACE.mp4 25MB
  54. 16. Mathematical Functions/3. SETSEED.mp4 25MB
  55. 21. Bonus Section Nail that Interview!/4. Truncate.mp4 21MB
  56. 9. Aggregate Commands/2. SUM.mp4 21MB
  57. 16. Mathematical Functions/1. CEIL & FLOOR.mp4 21MB
  58. 12. JOINS/8. Union.mp4 20MB
  59. 15. String Functions/1. LENGTH.mp4 19MB
  60. 12. JOINS/1. Introduction to Joins.mp4 18MB
  61. 9. Aggregate Commands/3. AVERAGE.mp4 18MB
  62. 23. Bonus Section Database Basics/2. Tables and DBMS.mp4 17MB
  63. 12. JOINS/7. Except.mp4 17MB
  64. 23. Bonus Section Database Basics/4. PostgreSQL.mp4 17MB
  65. 15. String Functions/5. CONCATENATION.mp4 17MB
  66. 16. Mathematical Functions/4. ROUND.mp4 17MB
  67. 15. String Functions/8. Exercise 13 String Functions.mp4 16MB
  68. 22. Performance tuning tips/3. TIP 3.mp4 14MB
  69. 22. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).mp4 14MB
  70. 7. Selection commands Ordering/1. Side Lecture Commenting in SQL.mp4 12MB
  71. 16. Mathematical Functions/5. POWER.mp4 12MB
  72. 15. String Functions/2. UPPER LOWER.mp4 12MB
  73. 22. Performance tuning tips/5. TIP 5.mp4 11MB
  74. 22. Performance tuning tips/7. TIP 7 (JOINS).mp4 11MB
  75. 23. Bonus Section Database Basics/1. What is SQL.mp4 11MB
  76. 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.mp4 10MB
  77. 18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.mp4 8MB
  78. 4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.mp4 7MB
  79. 12. JOINS/9. Exercise 10 Joins.mp4 7MB
  80. 9. Aggregate Commands/5. Exercise 8 Aggregate functions.mp4 6MB
  81. 10. Group By Commands/3. Exercise 9 Group By.mp4 6MB
  82. 4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.mp4 6MB
  83. 22. Performance tuning tips/2. TIP 2.mp4 6MB
  84. 17. Date-Time Functions/4. Exercise 15 Date-time functions.mp4 6MB
  85. 6. Selection commands Filtering/4. Exercise 6 In, Like & Between.mp4 5MB
  86. 13. Subqueries/2. Exercise 11 Subqueries.mp4 5MB
  87. 4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.mp4 5MB
  88. 4. Fundamental SQL statements/15. Exercise 4 Updating Table.mp4 4MB
  89. 14. Views and Indexes/3. Exercise 12 Views.mp4 3MB
  90. 7. Selection commands Ordering/4. Exercise 7 Sorting.mp4 3MB
  91. 5. Restore and Back-up/3. Exercise 5 Restore and Back-up.mp4 3MB
  92. 22. Performance tuning tips/4. TIP 4 (VACCUM).mp4 3MB
  93. 5. Restore and Back-up/1.2 Supermart_DB.tar 1MB
  94. 5. Restore and Back-up/2.3 Sales.csv 984KB
  95. 4. Fundamental SQL statements/3.1 Solution.pdf 734KB
  96. 1. Introduction/1.1 IntroV_01.pdf 707KB
  97. 5. Restore and Back-up/1.1 BackupFiles.zip 586KB
  98. 23. Bonus Section Database Basics/2.1 Lecture_2.pdf 289KB
  99. 22. Performance tuning tips/1.1 Lecture_Performance_Tuning.pdf 285KB
  100. 18. PATTERN (STRING) MATCHING/1.1 Lecture_Pattern_Matching.pdf 239KB
  101. 21. Bonus Section Nail that Interview!/2.1 Lecture_5_Keys.pdf 235KB
  102. 17. Date-Time Functions/1.1 Lecture_36_DATETIME functions.pdf 232KB
  103. 12. JOINS/4.1 Lecture_26_RIGHT join.pdf 222KB
  104. 14. Views and Indexes/1.1 Lecture_32_VIEWS.pdf 221KB
  105. 23. Bonus Section Database Basics/1.1 Lecture_1.pdf 220KB
  106. 19. Data Type conversion functions/1.1 Lecture_37_Conversion functions.pdf 220KB
  107. 4. Fundamental SQL statements/1.1 Lecture_04_create_Queries.pdf 219KB
  108. 4. Fundamental SQL statements/4.1 Lecture_06_INSERT and COPY.pdf 219KB
  109. 12. JOINS/5.1 Lecture_27_OUTER join.pdf 219KB
  110. 12. JOINS/3.1 Lecture_25_LEFT join.pdf 219KB
  111. 23. Bonus Section Database Basics/4.1 Lecture_5_Postgresql.pdf 216KB
  112. 12. JOINS/2.1 Lecture_24_INNER join.pdf 214KB
  113. 4. Fundamental SQL statements/12.1 Lecture_10_UPDATEDelete.pdf 211KB
  114. 2. Installation and getting started/1.1 Installing+PostgreSQL+on+Mac.pdf 210KB
  115. 15. String Functions/1.1 Lecture_34_STRING functions.pdf 209KB
  116. 23. Bonus Section Database Basics/3.1 Lecture_3_Queries.pdf 208KB
  117. 20. User Access Control Functions/1.1 Lecture_38_ACCESS control.pdf 208KB
  118. 13. Subqueries/1.1 Lecture_31_SUBQUERY.pdf 207KB
  119. 4. Fundamental SQL statements/14.1 Lecture_11_ALTER.pdf 202KB
  120. 14. Views and Indexes/2.1 Lecture_33_INDEX.pdf 202KB
  121. 16. Mathematical Functions/1.1 Lecture_35_MATH functions.pdf 193KB
  122. 21. Bonus Section Nail that Interview!/3.1 Lecture_ACID.pdf 191KB
  123. 21. Bonus Section Nail that Interview!/1.1 Lecture_TABLESPACE.pdf 189KB
  124. 6. Selection commands Filtering/2.1 Lecture_13_BETWEEN.pdf 188KB
  125. 12. JOINS/6.1 Lecture_28_Cross join.pdf 187KB
  126. 7. Selection commands Ordering/2.1 Lecture_15_ORDER BY.pdf 180KB
  127. 4. Fundamental SQL statements/7.1 Lecture_07_SELECT & DISTINCT.pdf 179KB
  128. 4. Fundamental SQL statements/10.1 Lecture_09_AND&OR.pdf 176KB
  129. 4. Fundamental SQL statements/9.1 Lecture_08_WHERE.pdf 176KB
  130. 12. JOINS/7.1 Lecture_29_EXCEPT.pdf 174KB
  131. 6. Selection commands Filtering/3.1 Lecture_14_LIKE.pdf 174KB
  132. 12. JOINS/8.1 Lecture_30_UNION.pdf 167KB
  133. 10. Group By Commands/2.1 Lecture_23_HAVING.pdf 167KB
  134. 10. Group By Commands/1.1 Lecture_22_group by.pdf 165KB
  135. 9. Aggregate Commands/4.1 Lecture_21_MIN&MAX.pdf 164KB
  136. 9. Aggregate Commands/2.1 Lecture_19_SUM.pdf 163KB
  137. 7. Selection commands Ordering/3.1 Lecture_16_LIMIT.pdf 162KB
  138. 21. Bonus Section Nail that Interview!/4.1 Lecture_TRUNCATE.pdf 161KB
  139. 11. Conditional Statement/1.1 Lecture_CASE.pdf 160KB
  140. 9. Aggregate Commands/1.1 Lecture_18_count.pdf 158KB
  141. 9. Aggregate Commands/3.1 Lecture_20_AVG.pdf 158KB
  142. 6. Selection commands Filtering/1.1 Lecture_12_IN_12.pdf 157KB
  143. 8. Alias/1.1 Lecture_17_AS.pdf 152KB
  144. 8. Alias/1.2 Lecture_17_AS.pdf 152KB
  145. 5. Restore and Back-up/2.1 Product.csv 139KB
  146. 5. Restore and Back-up/2.2 Customer.csv 64KB
  147. 13. Subqueries/1. Subqueries.srt 19KB
  148. 4. Fundamental SQL statements/14. ALTER.srt 19KB
  149. 18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt 18KB
  150. 20. User Access Control Functions/1. User Access Control.srt 16KB
  151. 4. Fundamental SQL statements/1. CREATE.srt 16KB
  152. 10. Group By Commands/1. GROUP BY.srt 14KB
  153. 19. Data Type conversion functions/1. Converting Numbers Date to String.srt 13KB
  154. 6. Selection commands Filtering/3. LIKE.srt 12KB
  155. 18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.srt 11KB
  156. 4. Fundamental SQL statements/4. INSERT.srt 10KB
  157. 7. Selection commands Ordering/2. ORDER BY.srt 10KB
  158. 17. Date-Time Functions/3. EXTRACT.srt 10KB
  159. 21. Bonus Section Nail that Interview!/3. ACID compliance.srt 10KB
  160. 12. JOINS/2. Inner Join.srt 10KB
  161. 12. JOINS/3. Left Join.srt 10KB
  162. 14. Views and Indexes/2. INDEX.srt 10KB
  163. 5. Restore and Back-up/1. Restore and Back-up.srt 10KB
  164. 14. Views and Indexes/1. VIEWS.srt 10KB
  165. 15. String Functions/4. TRIM, LTRIM, RTRIM.srt 10KB
  166. 3. Case Study Demo/3. Case Study Part 2.srt 9KB
  167. 2. Installation and getting started/1. Installing and setting up PostgreSQL.srt 9KB
  168. 21. Bonus Section Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.srt 9KB
  169. 12. JOINS/4. Right Join.srt 8KB
  170. 15. String Functions/6. SUBSTRING.srt 7KB
  171. 1. Introduction/1. Course Overview.srt 7KB
  172. 4. Fundamental SQL statements/8. SELECT DISTINCT.srt 7KB
  173. 21. Bonus Section Nail that Interview!/1. Tablespace.srt 7KB
  174. 4. Fundamental SQL statements/10. Logical Operators.srt 7KB
  175. 9. Aggregate Commands/1. COUNT.srt 7KB
  176. 15. String Functions/7. LIST AGGREGATION.srt 7KB
  177. 23. Bonus Section Database Basics/3. Types of SQL commands.srt 7KB
  178. 11. Conditional Statement/1. CASE WHEN.srt 7KB
  179. 16. Mathematical Functions/2. RANDOM.srt 7KB
  180. 6. Selection commands Filtering/2. BETWEEN.srt 7KB
  181. 19. Data Type conversion functions/2. Converting String to Numbers Date.srt 6KB
  182. 17. Date-Time Functions/1. CURRENT DATE & TIME.srt 6KB
  183. 22. Performance tuning tips/8. TIP 8 (SCHEMAS).srt 6KB
  184. 3. Case Study Demo/2. Case Study Part 1.srt 6KB
  185. 12. JOINS/6. Cross Join.srt 6KB
  186. 4. Fundamental SQL statements/5. Import data from File.srt 6KB
  187. 4. Fundamental SQL statements/12. UPDATE.srt 6KB
  188. 15. String Functions/3. REPLACE.srt 5KB
  189. 4. Fundamental SQL statements/13. DELETE.srt 5KB
  190. 10. Group By Commands/2. HAVING.srt 5KB
  191. 21. Bonus Section Nail that Interview!/4. Truncate.srt 5KB
  192. 6. Selection commands Filtering/1. IN.srt 5KB
  193. 12. JOINS/5. Full Outer Join.srt 5KB
  194. 7. Selection commands Ordering/3. LIMIT.srt 5KB
  195. 8. Alias/1. AS.srt 5KB
  196. 16. Mathematical Functions/1. CEIL & FLOOR.srt 5KB
  197. 9. Aggregate Commands/4. MIN & MAX.srt 5KB
  198. 23. Bonus Section Database Basics/2. Tables and DBMS.srt 5KB
  199. 4. Fundamental SQL statements/7. SELECT statement.srt 5KB
  200. 4. Fundamental SQL statements/9. WHERE.srt 5KB
  201. 15. String Functions/1. LENGTH.srt 5KB
  202. 16. Mathematical Functions/3. SETSEED.srt 4KB
  203. 12. JOINS/8. Union.srt 4KB
  204. 22. Performance tuning tips/1. TIP 1 (EXPLAIN).srt 4KB
  205. 17. Date-Time Functions/2. AGE.srt 4KB
  206. 22. Performance tuning tips/3. TIP 3.srt 4KB
  207. 12. JOINS/7. Except.srt 4KB
  208. 15. String Functions/8. Exercise 13 String Functions.srt 4KB
  209. 15. String Functions/5. CONCATENATION.srt 4KB
  210. 23. Bonus Section Database Basics/4. PostgreSQL.srt 4KB
  211. 9. Aggregate Commands/2. SUM.srt 4KB
  212. 12. JOINS/1. Introduction to Joins.srt 4KB
  213. 9. Aggregate Commands/3. AVERAGE.srt 3KB
  214. 22. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).srt 3KB
  215. 15. String Functions/2. UPPER LOWER.srt 3KB
  216. 22. Performance tuning tips/5. TIP 5.srt 3KB
  217. 16. Mathematical Functions/4. ROUND.srt 3KB
  218. 16. Mathematical Functions/5. POWER.srt 3KB
  219. 23. Bonus Section Database Basics/1. What is SQL.srt 3KB
  220. 22. Performance tuning tips/7. TIP 7 (JOINS).srt 3KB
  221. 18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.srt 3KB
  222. 4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.srt 3KB
  223. 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.srt 3KB
  224. 4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.srt 2KB
  225. 9. Aggregate Commands/5. Exercise 8 Aggregate functions.srt 2KB
  226. 7. Selection commands Ordering/1. Side Lecture Commenting in SQL.srt 2KB
  227. 13. Subqueries/2. Exercise 11 Subqueries.srt 2KB
  228. 17. Date-Time Functions/4. Exercise 15 Date-time functions.srt 2KB
  229. 10. Group By Commands/3. Exercise 9 Group By.srt 2KB
  230. 22. Performance tuning tips/2. TIP 2.srt 2KB
  231. 12. JOINS/9. Exercise 10 Joins.srt 2KB
  232. 23. Bonus Section Database Basics/5. Congratulations & About your certificate.html 2KB
  233. 4. Fundamental SQL statements/15. Exercise 4 Updating Table.srt 1KB
  234. 23. Bonus Section Database Basics/6. Bonus Lecture.html 1KB
  235. 5. Restore and Back-up/2. If your restore fails, then....html 1KB
  236. 5. Restore and Back-up/3. Exercise 5 Restore and Back-up.srt 1KB
  237. 14. Views and Indexes/3. Exercise 12 Views.srt 1KB
  238. 4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.srt 1KB
  239. 7. Selection commands Ordering/4. Exercise 7 Sorting.srt 1KB
  240. 6. Selection commands Filtering/4. Exercise 6 In, Like & Between.srt 973B
  241. 22. Performance tuning tips/4. TIP 4 (VACCUM).srt 777B
  242. 12. JOINS/1.1 Lecture_24_Joins_Query.txt 417B
  243. 3. Case Study Demo/1. Course Resources.html 411B
  244. 18. PATTERN (STRING) MATCHING/2.1 User_table.txt 242B
  245. 10. Group By Commands/4. Quiz.html 158B
  246. 12. JOINS/10. Quiz.html 158B
  247. 21. Bonus Section Nail that Interview!/5. Practice Test 1.html 158B
  248. 21. Bonus Section Nail that Interview!/6. SQL Quiz.html 158B
  249. 4. Fundamental SQL statements/16. Fundamental SQL statements.html 158B
  250. 9. Aggregate Commands/6. Quiz.html 158B
  251. 0. Websites you may like/[FCS Forum].url 133B
  252. 4. Fundamental SQL statements/6.1 Student.csv 129B
  253. 0. Websites you may like/[FreeCourseSite.com].url 127B
  254. 0. Websites you may like/[CourseClub.ME].url 122B
  255. 4. Fundamental SQL statements/3. Solutions to all Exercises.html 120B
  256. 4. Fundamental SQL statements/5.2 copy.csv 97B
  257. 4. Fundamental SQL statements/5.1 copytext.txt 51B