589689.xyz

[] Udemy - SQL Masterclass - SQL for Data Analytics

  • 收录时间:2022-01-28 10:35:27
  • 文件大小:3GB
  • 下载次数:1
  • 最近下载:2022-01-28 10:35:27
  • 磁力链接:
立即下载 复制链接

文件列表

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