589689.xyz

[] Udemy - SQL Masterclass SQL for Data Analytics

  • 收录时间:2019-11-26 21:40:15
  • 文件大小:3GB
  • 下载次数:48
  • 最近下载:2021-01-21 04:03:44
  • 磁力链接:
立即下载 复制链接

文件列表

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