:Search:

Udemy - The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert [1/2026]

Torrent:
Info Hash: CCCCF8442079EDE77FAC693A61F14A289B154677
Similar Posts:
Uploader: NoctDeath
Source: TP Logo The Pirate Bay
Downloads: 2593
Description:
Last updated: 1/2026 If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today. Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases. In this course, you will: - Learn the ins and outs of SQL syntax - Generate reports using sales and user data - Analyze data using Aggregate Functions - Run complex queries using MySQL logical operators and string functions - Write all the common SQL joins - Work with large datasets containing thousands of entries - Design and implement complex database schemas - Learn to navigate the treacherous world of storing dates and times - Clone the database structure of a photo sharing social network - Work with MySQL 8.x Window Functions: RANK, LEAD, LAG, NTILE, etc. - Create MySQL database views and virtual tables Requirements: - No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome. - All you need is a working computer for this course; PC, Mac, and Linux users are all welcome. - No previous programming language experience required, but it won't hurt :)
Category: Books
Size: 9.3 GB
Added: March 2, 2026, 7:56 a.m.
Peers: Seeders: 44, Leechers: 12 (Last updated: 1 month, 2 weeks ago)
Tracker Data:
Tracker Seeders Leechers Completed
udp://tracker.rarbg.torrentbay.st:6969/announce 0 1 0
udp://tracker.opentrackr.org:1337/announce 40 11 2593
udp://open.demonoid.ch:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://open.demonii.com:1337/announce (Failed to scrape UDP tracker) 0 0 0
udp://open.stealth.si:80/announce (Failed to scrape UDP tracker) 0 0 0
udp://explodie.org:6969/announce 3 0 0
udp://exodus.desync.com:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://wepzone.net:6969/announce 1 0 0
udp://tracker1.myporn.club:9337/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.srv00.com:6969/announce 0 0 0
Files:
  1. 024 Exercise SOLUTION.mp4 209.5 MB
  2. 001 This Course Was Just Updated!_en.srt 6.1 KB
  3. 002 Join The Community!.html 3.2 KB
  4. 003 Course Intro.mp4 10.1 MB
  5. 003 Course Intro_en.srt 2.6 KB
  6. 004 About Me.mp4 16.5 MB
  7. 004 About Me_en.srt 3.1 KB
  8. 005 Getting The Course Code.mp4 8.2 MB
  9. 005 Getting The Course Code_en.srt 3.3 KB
  10. 006 Download All Slides Here!.html 2.4 KB
  11. 007 First 5 Minutes of SQL.mp4 72.8 MB
  12. 007 First 5 Minutes of SQL_en.srt 16.0 KB
  13. 007 SLIDES.url 83 bytes
  14. 007 SQL-Try-It-Editor.url 86 bytes
  15. external-links.txt 164 bytes
  16. 01-pdf-slides-first-5-minutes-of-sql.pdf 59.2 KB
  17. 02-pdf-slides-getting-started-and-installation.pdf 349.3 KB
  18. 03-pdf-slides-creating-databases-and-tables.pdf 252.0 KB
  19. 04-pdf-slides-inserting-data.pdf 179.9 KB
  20. 05-pdf-slides-crud-basics.pdf 128.4 KB
  21. 06-pdf-slides-crud-challenge.pdf 73.7 KB
  22. 07-pdf-slides-string-functions.pdf 134.7 KB
  23. 08-pdf-slides-refining-selections.pdf 143.7 KB
  24. 09-pdf-slides-aggregate-functions.pdf 154.8 KB
  25. 10-pdf-slides-revisiting-data-types.pdf 118.8 KB
  26. 11-pdf-slides-comparison-and-logical-operators.pdf 203.5 KB
  27. 12-pdf-slides-constraints-and-alter-table.pdf 224.6 KB
  28. 13-pdf-slides-one-to-many-and-joins.pdf 170.4 KB
  29. 14-pdf-slides-many-to-many.pdf 92.8 KB
  30. 16-pdf-slides-window-functions.pdf 259.8 KB
  31. 17-18-pdf-slides-instagram-database-clone.pdf 5.6 MB
  32. 19-pdf-slides-database-triggers.pdf 117.6 KB
  33. 20-pdf-slides-introducing-node.pdf 1.4 MB
  34. 21-pdf-slides-building-our-web-app.pdf 1.6 MB
  35. 001 Section Introduction.mp4 23.2 MB
  36. 001 Section Introduction_en.srt 2.2 KB
  37. 002 02-pdf-slides-getting-started-and-installation.pdf 349.3 KB
  38. 002 SLIDES.url 73 bytes
  39. 002 What Is A Database.mp4 20.4 MB
  40. 002 What Is A Database_en.srt 13.4 KB
  41. 003 SQL vs. MySQL.mp4 14.1 MB
  42. 003 SQL vs. MySQL_en.srt 9.5 KB
  43. 004 Installation START HERE!.mp4 28.9 MB
  44. 004 Installation START HERE!_en.srt 11.1 KB
  45. 005 NEW-Video-Tutorial-Windows-MySQL-Installation.url 67 bytes
  46. 005 VERY IMPORTANT, PLEASE READ! — New MySQL Windows Installation Instructions.html 7.3 KB
  47. 006 [FOLLOW THE PREVIOUS LECTURE NOTE INSTEAD] Installation Windows Instructions.mp4 61.3 MB
  48. 006 [FOLLOW THE PREVIOUS LECTURE NOTE INSTEAD] Installation Windows Instructions_en.srt 16.9 KB
  49. 006 NEW-Video-Tutorial-Windows-MySQL-Installation.url 67 bytes
  50. 006 Windows-MySQL-Download.url 66 bytes
  51. 006 Windows-MySQL-Installation.url 89 bytes
  52. 007 NEW-Video-Tutorial-Mac-MySQL-Installation.url 67 bytes
  53. 007 VERY IMPORTANT, PLEASE READ! — New MySQL Mac Installation Instructions.html 9.4 KB
  54. 008 [FOLLOW THE PREVIOUS LECTURE NOTE INSTEAD] Installation Mac Instructions.mp4 73.5 MB
  55. 008 [FOLLOW THE PREVIOUS LECTURE NOTE INSTEAD] Installation Mac Instructions_en.srt 22.8 KB
  56. 008 MySQL-Community-Server-Download.url 62 bytes
  57. 008 MySQL-Workbench-Download.url 66 bytes
  58. 008 NEW-Video-Tutorial-Mac-MySQL-Installation.url 67 bytes
  59. 008 OPTIONAL-DbGate-Download.url 43 bytes
  60. external-links.txt 832 bytes
  61. 001 Section Introduction.mp4 25.7 MB
  62. 001 Section Introduction_en.srt 2.5 KB
  63. 002 03-pdf-slides-creating-databases-and-tables.pdf 252.0 KB
  64. 002 Showing Databases.mp4 13.2 MB
  65. 002 Showing Databases_en.srt 8.3 KB
  66. 002 SLIDES.url 98 bytes
  67. 003 CODE Showing Databases.html 2.3 KB
  68. 004 Creating Databases.mp4 14.9 MB
  69. 004 Creating Databases_en.srt 9.1 KB
  70. 005 CODE Creating Databases.html 2.4 KB
  71. 006 Dropping and Using Databases.mp4 16.6 MB
  72. 006 Dropping and Using Databases_en.srt 9.7 KB
  73. 007 CODE Dropping and Using Databases.html 2.4 KB
  74. 008 Introducing Tables.mp4 39.3 MB
  75. 008 Introducing Tables_en.srt 9.5 KB
  76. 009 Data Types The Basics.mp4 44.2 MB
  77. 009 Data Types The Basics_en.srt 14.5 KB
  78. 010 Basic Datatypes Challenge.mp4 7.1 MB
  79. 010 Basic Datatypes Challenge_en.srt 4.5 KB
  80. 011 CODE Basic Datatypes Challenge.html 2.4 KB
  81. 012 Creating Tables.mp4 12.8 MB
  82. 012 Creating Tables_en.srt 9.5 KB
  83. 013 CODE Creating Tables.html 2.4 KB
  84. 014 How Do We Know It Worked.mp4 32.1 MB
  85. 014 How Do We Know It Worked_en.srt 8.2 KB
  86. 015 CODE How Do We Know It Worked.html 2.3 KB
  87. 016 Dropping Tables.mp4 9.3 MB
  88. 016 Dropping Tables_en.srt 4.1 KB
  89. 017 CODE Dropping Tables.html 2.3 KB
  90. 018 Tables Basics Activity.mp4 11.6 MB
  91. 018 Tables Basics Activity_en.srt 5.1 KB
  92. 019 SOLUTION Tables Basics Activity.html 2.5 KB
  93. 020 MySQL Comments.mp4 9.0 MB
  94. 020 MySQL Comments_en.srt 6.0 KB
  95. external-links.txt 90 bytes
  96. 001 Section Introduction.mp4 19.5 MB
  97. 001 Section Introduction_en.srt 3.0 KB
  98. 002 04-pdf-slides-inserting-data.pdf 179.9 KB
  99. 002 INSERT The Basics.mp4 9.9 MB
  100. 002 INSERT The Basics_en.srt 6.2 KB
  101. 002 SLIDES.url 102 bytes
  102. 003 CODE INSERT The Basics.html 2.6 KB
  103. 004 A Quick Preview of SELECT.mp4 6.8 MB
  104. 004 A Quick Preview of SELECT_en.srt 3.2 KB
  105. 005 CODE A Quick Preview of SELECT.html 2.3 KB
  106. 006 Multi-inserts.mp4 16.3 MB
  107. 006 Multi-inserts_en.srt 8.2 KB
  108. 007 CODE Multi-inserts.html 2.5 KB
  109. 008 INSERT Exercise.mp4 58.9 MB
  110. 008 INSERT Exercise_en.srt 9.2 KB
  111. 009 SOLUTION INSERT Exercise.html 3.0 KB
  112. 010 Working With NOT NULL.mp4 31.2 MB
  113. 010 Working With NOT NULL_en.srt 9.6 KB
  114. 011 CODE Working With NOT NULL.html 2.3 KB
  115. 012 Sidenote Quotes In MySQL.mp4 11.7 MB
  116. 012 Sidenote Quotes In MySQL_en.srt 7.6 KB
  117. 013 Adding DEFAULT Values.mp4 35.1 MB
  118. 013 Adding DEFAULT Values_en.srt 11.5 KB
  119. 014 CODE Adding DEFAULT Values.html 2.8 KB
  120. 015 Introducing Primary Keys.mp4 17.4 MB
  121. 015 Introducing Primary Keys_en.srt 8.6 KB
  122. 016 CODE Introducing Primary Keys.html 2.6 KB
  123. 017 Working With AUTO_INCREMENT.mp4 55.4 MB
  124. 017 Working With AUTO_INCREMENT_en.srt 12.7 KB
  125. 018 CODE Working With AUTO_INCREMENT.html 2.4 KB
  126. 019 Create Table Insert Exercise.mp4 71.4 MB
  127. 019 Create Table Insert Exercise_en.srt 12.9 KB
  128. 020 SOLUTION Insert Exercise.html 3.0 KB
  129. external-links.txt 94 bytes
  130. 001 Section Introduction.mp4 33.8 MB
  131. 001 Section Introduction_en.srt 2.9 KB
  132. 002 05-pdf-slides-crud-basics.pdf 128.4 KB
  133. 002 Introducing CRUD.mp4 3.2 MB
  134. 002 Introducing CRUD_en.srt 3.7 KB
  135. 002 SLIDES.url 71 bytes
  136. 003 Getting Our New Dataset.mp4 4.2 MB
  137. 003 Getting Our New Dataset_en.srt 3.6 KB
  138. 004 CODE.html 2.8 KB
  139. 005 Officially Introducing SELECT.mp4 20.2 MB
  140. 005 Officially Introducing SELECT_en.srt 5.8 KB
  141. 006 CODE.html 2.4 KB
  142. 007 The WHERE clause.mp4 7.5 MB
  143. 007 The WHERE clause_en.srt 6.7 KB
  144. 008 CODE.html 2.3 KB
  145. 009 Rapid Fire Exercises.mp4 4.2 MB
  146. 009 Rapid Fire Exercises_en.srt 2.5 KB
  147. 010 Rapid Fire Exercises SOLUTION.mp4 12.0 MB
  148. 010 Rapid Fire Exercises SOLUTION_en.srt 4.7 KB
  149. 011 SOLUTION CODE.html 2.5 KB
  150. 012 Aliases.mp4 4.4 MB
  151. 012 Aliases_en.srt 4.0 KB
  152. 013 CODE.html 2.3 KB
  153. 014 Using UPDATE.mp4 15.3 MB
  154. 014 Using UPDATE_en.srt 9.1 KB
  155. 015 CODE.html 2.4 KB
  156. 016 A Quick Rule Of Thumb.mp4 3.1 MB
  157. 016 A Quick Rule Of Thumb_en.srt 3.2 KB
  158. 017 UPDATE Exercise.mp4 2.1 MB
  159. 017 UPDATE Exercise_en.srt 2.0 KB
  160. 018 UPDATE Exercise SOLUTION.mp4 6.7 MB
  161. 018 UPDATE Exercise SOLUTION_en.srt 4.6 KB
  162. 019 SOLUTION CODE.html 2.8 KB
  163. 020 Introducing DELETE.mp4 13.1 MB
  164. 020 Introducing DELETE_en.srt 4.2 KB
  165. 021 CODE.html 2.3 KB
  166. 022 DELETE Exercise.mp4 2.5 MB
  167. 022 DELETE Exercise_en.srt 1.9 KB
  168. 023 DELETE Exercise SOLUTION.mp4 4.7 MB
  169. 023 DELETE Exercise SOLUTION_en.srt 3.9 KB
  170. 024 SOLUTION CODE.html 2.5 KB
  171. external-links.txt 63 bytes
  172. 001 Section Introduction.mp4 39.8 MB
  173. 001 Section Introduction_en.srt 3.9 KB
  174. 002 06-pdf-slides-crud-challenge.pdf 73.7 KB
  175. 002 Introducing the CRUD Challenge.mp4 10.9 MB
  176. 002 Introducing the CRUD Challenge_en.srt 9.9 KB
  177. 002 SLIDES.url 79 bytes
  178. 003 CRUD Challenge Solution Creating.mp4 73.8 MB
  179. 003 CRUD Challenge Solution Creating_en.srt 15.2 KB
  180. 004 SOLUTION CODE.html 2.9 KB
  181. 005 CRUD Challenge Solution Reading.mp4 7.0 MB
  182. 005 CRUD Challenge Solution Reading_en.srt 2.9 KB
  183. 006 SOLUTION CODE.html 2.4 KB
  184. 007 CRUD Challenge Solution Updating.mp4 13.1 MB
  185. 007 CRUD Challenge Solution Updating_en.srt 5.3 KB
  186. 008 SOLUTION CODE.html 2.5 KB
  187. 009 CRUD Challenge Solution Deleting.mp4 12.0 MB
  188. 009 CRUD Challenge Solution Deleting_en.srt 5.0 KB
  189. 010 SOLUTION CODE.html 2.5 KB
  190. external-links.txt 71 bytes
  191. 001 Section Introduction.mp4 23.7 MB
  192. 001 Section Introduction_en.srt 3.8 KB
  193. 002 07-pdf-slides-string-functions.pdf 134.7 KB
  194. 002 MySQL-Docs-String-Functions.url 85 bytes
  195. 002 SLIDES.url 86 bytes
  196. 002 The World Of String Functions.mp4 14.6 MB
  197. 002 The World Of String Functions_en.srt 3.5 KB
  198. 003 book-data.sql 1.3 KB
  199. 003 Loading Our Books Data.mp4 23.8 MB
  200. 003 Loading Our Books Data_en.srt 10.1 KB
  201. 004 CODE.html 3.5 KB
  202. 005 CONCAT.mp4 46.7 MB
  203. 005 CONCAT_en.srt 15.1 KB
  204. 006 CODE.html 2.4 KB
  205. 007 SUBSTRING.mp4 51.0 MB
  206. 007 SUBSTRING_en.srt 13.4 KB
  207. 008 CODE.html 2.4 KB
  208. 009 Combining String Functions.mp4 31.8 MB
  209. 009 Combining String Functions_en.srt 11.5 KB
  210. 010 CODE.html 2.3 KB
  211. 011 Sidenote SQL Formatting.mp4 42.6 MB
  212. 011 Sidenote SQL Formatting_en.srt 8.5 KB
  213. 011 SQL-Formatter.url 61 bytes
  214. 012 REPLACE.mp4 37.4 MB
  215. 012 REPLACE_en.srt 10.2 KB
  216. 013 CODE.html 2.5 KB
  217. 014 REVERSE.mp4 15.4 MB
  218. 014 REVERSE_en.srt 5.3 KB
  219. 015 CODE.html 2.4 KB
  220. 016 CHAR_LENGTH.mp4 12.7 MB
  221. 016 CHAR_LENGTH_en.srt 4.8 KB
  222. 017 CODE.html 2.4 KB
  223. 018 UPPER & LOWER.mp4 34.5 MB
  224. 018 UPPER & LOWER_en.srt 6.3 KB
  225. 019 CODE.html 2.4 KB
  226. 020 Other String Functions.mp4 31.9 MB
  227. 020 Other String Functions_en.srt 10.9 KB
  228. 021 CODE.html 2.4 KB
  229. 022 String Functions Exercise.mp4 14.5 MB
  230. 022 String Functions Exercise_en.srt 6.8 KB
  231. 023 String Functions Exerise SOLUTION.mp4 132.9 MB
  232. 023 String Functions Exerise SOLUTION_en.srt 17.3 KB
  233. 024 SOLUTION CODE.html 2.9 KB
  234. external-links.txt 236 bytes
  235. 001 Section Introduction.mp4 12.8 MB
  236. 001 Section Introduction_en.srt 1.2 KB
  237. 002 08-pdf-slides-refining-selections.pdf 143.7 KB
  238. 002 Adding Some New Books.mp4 3.9 MB
  239. 002 Adding Some New Books_en.srt 2.6 KB
  240. 002 SLIDES.url 90 bytes
  241. 003 CODE.html 2.5 KB
  242. 004 DISTINCT.mp4 20.6 MB
  243. 004 DISTINCT_en.srt 10.4 KB
  244. 005 CODE.html 2.4 KB
  245. 006 ORDER BY.mp4 66.7 MB
  246. 006 ORDER BY_en.srt 10.8 KB
  247. 007 CODE.html 2.3 KB
  248. 008 More On ORDER BY.mp4 48.0 MB
  249. 008 More On ORDER BY_en.srt 11.3 KB
  250. 009 CODE.html 2.4 KB
  251. 010 LIMIT.mp4 49.0 MB
  252. 010 LIMIT_en.srt 10.0 KB
  253. 011 CODE.html 3.1 KB
  254. 012 LIKE.mp4 46.8 MB
  255. 012 LIKE_en.srt 12.1 KB
  256. 013 CODE.html 2.5 KB
  257. 014 Escaping Wildcards.mp4 8.3 MB
  258. 014 Escaping Wildcards_en.srt 3.9 KB
  259. 015 CODE.html 2.4 KB
  260. 016 Refining Selections Exercise.mp4 15.3 MB
  261. 016 Refining Selections Exercise_en.srt 5.7 KB
  262. 017 Refining Selections Exercise SOLUTION.mp4 132.0 MB
  263. 017 Refining Selections Exercise SOLUTION_en.srt 26.2 KB
  264. 018 SOLUTION CODE.html 2.9 KB
  265. external-links.txt 82 bytes
  266. 001 Section Introduction.mp4 43.4 MB
  267. 001 Section Introduction_en.srt 7.6 KB
  268. 002 09-pdf-slides-aggregate-functions.pdf 154.8 KB
  269. 002 Count Basics.mp4 31.4 MB
  270. 002 Count Basics_en.srt 12.4 KB
  271. 002 SLIDES.url 90 bytes
  272. 003 CODE.html 2.4 KB
  273. 004 GROUP BY.mp4 76.6 MB
  274. 004 GROUP BY_en.srt 16.8 KB
  275. 005 CODE.html 2.4 KB
  276. 006 MIN and MAX Basics.mp4 7.9 MB
  277. 006 MIN and MAX Basics_en.srt 6.2 KB
  278. 007 CODE.html 2.3 KB
  279. 008 Subqueries.mp4 38.2 MB
  280. 008 Subqueries_en.srt 10.0 KB
  281. 009 CODE.html 2.4 KB
  282. 010 Grouping By Multiple Columns.mp4 20.7 MB
  283. 010 Grouping By Multiple Columns_en.srt 7.6 KB
  284. 011 CODE.html 2.4 KB
  285. 012 MIN and MAX With GROUP BY.mp4 48.4 MB
  286. 012 MIN and MAX With GROUP BY_en.srt 10.0 KB
  287. 013 CODE.html 2.8 KB
  288. 014 SUM.mp4 22.8 MB
  289. 014 SUM_en.srt 5.8 KB
  290. 015 CODE.html 2.3 KB
  291. 016 AVG.mp4 6.1 MB
  292. 016 AVG_en.srt 3.8 KB
  293. 017 CODE.html 2.4 KB
  294. 018 Aggregate Functions Docs.mp4 22.3 MB
  295. 018 Aggregate Functions Docs_en.srt 2.4 KB
  296. 019 Agg Functions Exercise.mp4 6.3 MB
  297. 019 Agg Functions Exercise_en.srt 5.1 KB
  298. 020 Agg Functions Exercise SOLUTION.mp4 58.3 MB
  299. 020 Agg Functions Exercise SOLUTION_en.srt 20.4 KB
  300. 021 SOLUTION CODE.html 2.8 KB
  301. external-links.txt 82 bytes
  302. 001 Section Introduction.mp4 22.4 MB
  303. 001 Section Introduction_en.srt 3.7 KB
  304. 002 10-pdf-slides-revisiting-data-types.pdf 118.8 KB
  305. 002 Data-Types-Reference.url 79 bytes
  306. 002 SLIDES.url 82 bytes
  307. 002 Surveying Other Data Types.mp4 27.2 MB
  308. 002 Surveying Other Data Types_en.srt 5.8 KB
  309. 003 CHAR vs. VARCHAR.mp4 62.1 MB
  310. 003 CHAR vs. VARCHAR_en.srt 22.1 KB
  311. 004 INT, TINYINT, BIGINT, etc.mp4 43.3 MB
  312. 004 INT, TINYINT, BIGINT, etc_en.srt 8.9 KB
  313. 005 DECIMAL.mp4 15.0 MB
  314. 005 DECIMAL_en.srt 11.6 KB
  315. 006 FLOAT & DOUBLE.mp4 19.8 MB
  316. 006 FLOAT & DOUBLE_en.srt 9.5 KB
  317. 007 DATE and TIME.mp4 21.8 MB
  318. 007 DATE and TIME_en.srt 7.9 KB
  319. 008 Working With Dates.mp4 92.4 MB
  320. 008 Working With Dates_en.srt 12.9 KB
  321. 009 CODE.html 2.7 KB
  322. 010 CURDATE, CURTIME, & NOW.mp4 43.0 MB
  323. 010 CURDATE, CURTIME, & NOW_en.srt 7.2 KB
  324. 011 CODE.html 2.3 KB
  325. 012 Date Functions.mp4 69.5 MB
  326. 012 Date Functions_en.srt 9.7 KB
  327. 013 CODE.html 2.4 KB
  328. 014 Time Functions.mp4 15.7 MB
  329. 014 Time Functions_en.srt 3.2 KB
  330. 015 CODE.html 2.4 KB
  331. 016 Formatting Dates.mp4 103.0 MB
  332. 016 Formatting Dates_en.srt 15.7 KB
  333. 017 CODE.html 2.4 KB
  334. 018 Date Math.mp4 104.2 MB
  335. 018 Date Math_en.srt 17.2 KB
  336. 019 TIMESTAMPS.mp4 32.0 MB
  337. 019 TIMESTAMPS_en.srt 5.9 KB
  338. 020 DEFAULT & ON UPDATE TIMESTAMPS.mp4 70.3 MB
  339. 020 DEFAULT & ON UPDATE TIMESTAMPS_en.srt 10.9 KB
  340. 021 CODE.html 2.4 KB
  341. 022 Data Types Exercise.mp4 8.0 MB
  342. 022 Data Types Exercise_en.srt 6.7 KB
  343. 023 Data Types Exercise SOLUTION.mp4 74.9 MB
  344. 023 Data Types Exercise SOLUTION_en.srt 22.3 KB
  345. 024 SOLUTION CODE.html 3.4 KB
  346. external-links.txt 159 bytes
  347. 001 Section Introduction.mp4 31.5 MB
  348. 001 Section Introduction_en.srt 5.1 KB
  349. 002 11-pdf-slides-comparison-and-logical-operators.pdf 203.5 KB
  350. 002 Not Equal.mp4 25.3 MB
  351. 002 Not Equal_en.srt 4.7 KB
  352. 002 SLIDES.url 78 bytes
  353. 003 CODE.html 2.2 KB
  354. 004 NOT LIKE.mp4 9.2 MB
  355. 004 NOT LIKE_en.srt 5.1 KB
  356. 005 CODE.html 2.2 KB
  357. 006 Greater Than.mp4 15.6 MB
  358. 006 Greater Than_en.srt 6.7 KB
  359. 007 CODE.html 2.3 KB
  360. 008 Less Than Or Equal To.mp4 7.1 MB
  361. 008 Less Than Or Equal To_en.srt 4.5 KB
  362. 009 CODE.html 2.3 KB
  363. 010 Logical AND.mp4 46.8 MB
  364. 010 Logical AND_en.srt 15.4 KB
  365. 011 CODE.html 2.4 KB
  366. 012 Logical OR.mp4 42.6 MB
  367. 012 Logical OR_en.srt 9.3 KB
  368. 013 CODE.html 2.6 KB
  369. 014 Between.mp4 33.3 MB
  370. 014 Between_en.srt 7.3 KB
  371. 015 CODE.html 2.4 KB
  372. 016 Comparing Dates.mp4 84.3 MB
  373. 016 Comparing Dates_en.srt 13.1 KB
  374. 017 CODE.html 2.4 KB
  375. 018 The IN Operator.mp4 68.3 MB
  376. 018 The IN Operator_en.srt 14.1 KB
  377. 019 CODE.html 2.6 KB
  378. 020 CASE.mp4 80.0 MB
  379. 020 CASE_en.srt 14.4 KB
  380. 021 CODE.html 3.0 KB
  381. 022 IS NULL.mp4 11.8 MB
  382. 022 IS NULL_en.srt 3.2 KB
  383. 023 Exercise.mp4 14.7 MB
  384. 023 Exercise_en.srt 5.9 KB
  385. 001 This Course Was Just Updated!.mp4 23.4 MB
  386. 024 Exercise SOLUTION_en.srt 23.8 KB
  387. 025 SOLUTION CODE.html 3.2 KB
  388. external-links.txt 70 bytes
  389. 001 12-pdf-slides-constraints-and-alter-table.pdf 224.6 KB
  390. 001 SLIDES.url 88 bytes
  391. 001 UNIQUE Constraint.mp4 10.1 MB
  392. 001 UNIQUE Constraint_en.srt 6.2 KB
  393. 002 CODE.html 2.5 KB
  394. 003 CHECK Constraints.mp4 20.5 MB
  395. 003 CHECK Constraints_en.srt 8.0 KB
  396. 004 CODE.html 2.4 KB
  397. 005 Named Constraints.mp4 32.4 MB
  398. 005 Named Constraints_en.srt 6.8 KB
  399. 006 CODE.html 2.4 KB
  400. 007 Multiple Column Constraints.mp4 39.0 MB
  401. 007 Multiple Column Constraints_en.srt 8.5 KB
  402. 008 CODE.html 2.5 KB
  403. 009 ALTER TABLE Adding Columns.mp4 48.2 MB
  404. 009 ALTER TABLE Adding Columns_en.srt 9.8 KB
  405. 010 CODE.html 2.3 KB
  406. 011 ALTER TABLE Dropping Columns.mp4 21.0 MB
  407. 011 ALTER TABLE Dropping Columns_en.srt 3.0 KB
  408. 012 CODE.html 2.2 KB
  409. 013 ALTER TABLE Renaming.mp4 27.1 MB
  410. 013 ALTER TABLE Renaming_en.srt 6.1 KB
  411. 014 CODE.html 2.5 KB
  412. 015 ALTER TABLE Modifying Columns.mp4 15.5 MB
  413. 015 ALTER TABLE Modifying Columns_en.srt 6.1 KB
  414. 016 CODE.html 2.4 KB
  415. 017 ALTER TABLE Constraints.mp4 39.8 MB
  416. 017 ALTER TABLE Constraints_en.srt 6.8 KB
  417. 018 CODE.html 2.4 KB
  418. external-links.txt 80 bytes
  419. 001 Section Introduction.mp4 42.0 MB
  420. 001 Section Introduction_en.srt 3.7 KB
  421. 002 13-pdf-slides-one-to-many-and-joins.pdf 170.4 KB
  422. 002 Data is Messy.mp4 37.8 MB
  423. 002 Data is Messy_en.srt 19.8 KB
  424. 002 SLIDES.url 84 bytes
  425. 003 Relationships Basics.mp4 12.0 MB
  426. 003 Relationships Basics_en.srt 8.7 KB
  427. 004 One to Many Relationship.mp4 58.7 MB
  428. 004 One to Many Relationship_en.srt 22.3 KB
  429. 005 Working with FOREIGN KEY.mp4 85.5 MB
  430. 005 Working with FOREIGN KEY_en.srt 18.0 KB
  431. 006 CODE.html 3.0 KB
  432. 007 Cross Joins.mp4 102.0 MB
  433. 007 Cross Joins_en.srt 13.9 KB
  434. 008 CODE.html 2.5 KB
  435. 009 Inner Joins.mp4 103.6 MB
  436. 009 Inner Joins_en.srt 15.1 KB
  437. 010 CODE.html 2.5 KB
  438. 011 Inner Joins With Group By.mp4 36.5 MB
  439. 011 Inner Joins With Group By_en.srt 8.6 KB
  440. 012 CODE.html 2.4 KB
  441. 013 Left Join.mp4 64.5 MB
  442. 013 Left Join_en.srt 12.3 KB
  443. 014 CODE.html 2.5 KB
  444. 015 Left Join With Group By.mp4 20.5 MB
  445. 015 Left Join With Group By_en.srt 6.1 KB
  446. 016 CODE.html 2.4 KB
  447. 017 Right Join.mp4 16.1 MB
  448. 017 Right Join_en.srt 7.0 KB
  449. 018 CODE.html 2.3 KB
  450. 019 On Delete Cascade.mp4 18.1 MB
  451. 019 On Delete Cascade_en.srt 8.9 KB
  452. 020 CODE.html 2.6 KB
  453. 021 Joins Exercise.mp4 10.0 MB
  454. 021 Joins Exercise_en.srt 5.0 KB
  455. 022 EXERCISE STARTER DATA.html 2.6 KB
  456. 023 Joins Exercise SOLUTION.mp4 96.4 MB
  457. 023 Joins Exercise SOLUTION_en.srt 18.0 KB
  458. 024 SOLUTION CODE.html 3.4 KB
  459. external-links.txt 76 bytes
  460. 001 Section Introduction.mp4 41.2 MB
  461. 001 Section Introduction_en.srt 3.7 KB
  462. 002 14-pdf-slides-many-to-many.pdf 92.8 KB
  463. 002 Many to Many Basics.mp4 36.4 MB
  464. 002 Many to Many Basics_en.srt 19.4 KB
  465. 002 SLIDES.url 88 bytes
  466. 003 Creating Our Many To Many Tables.mp4 60.7 MB
  467. 003 Creating Our Many To Many Tables_en.srt 10.3 KB
  468. 004 CODE.html 4.2 KB
  469. 005 TV Series Challenge #1.mp4 32.3 MB
  470. 005 TV Series Challenge #1_en.srt 6.5 KB
  471. 006 CODE.html 2.3 KB
  472. 007 TV Series Challenge #2.mp4 19.7 MB
  473. 007 TV Series Challenge #2_en.srt 5.9 KB
  474. 008 CODE.html 2.4 KB
  475. 009 TV Series Challenge #3.mp4 31.9 MB
  476. 009 TV Series Challenge #3_en.srt 5.8 KB
  477. 010 CODE.html 2.3 KB
  478. 011 TV Series Challenge #4.mp4 35.0 MB
  479. 011 TV Series Challenge #4_en.srt 5.2 KB
  480. 012 CODE.html 2.5 KB
  481. 013 TV Series Challenge #5.mp4 22.7 MB
  482. 013 TV Series Challenge #5_en.srt 3.5 KB
  483. 014 CODE.html 2.3 KB
  484. 015 TV Series Challenge #6.mp4 127.9 MB
  485. 015 TV Series Challenge #6_en.srt 14.5 KB
  486. 016 CODE.html 3.1 KB
  487. 017 TV Series Challenge #7.mp4 56.8 MB
  488. 017 TV Series Challenge #7_en.srt 8.5 KB
  489. 018 CODE.html 2.9 KB
  490. external-links.txt 80 bytes
  491. 001 Introducing Views.mp4 61.7 MB
  492. 001 Introducing Views_en.srt 11.5 KB
  493. 002 CODE.html 2.8 KB
  494. 003 Updateable Views.mp4 65.1 MB
  495. 003 Updateable Views_en.srt 9.2 KB
  496. 004 ReplacingAltering Views.mp4 42.6 MB
  497. 004 ReplacingAltering Views_en.srt 5.7 KB
  498. 005 CODE.html 2.5 KB
  499. 006 HAVING clause.mp4 53.1 MB
  500. 006 HAVING clause_en.srt 7.5 KB
  501. 007 CODE.html 2.3 KB
  502. 008 WITH ROLLUP.mp4 58.4 MB
  503. 008 WITH ROLLUP_en.srt 11.9 KB
  504. 009 CODE.html 2.5 KB
  505. 010 SQL Modes Basics.mp4 65.5 MB
  506. 010 SQL Modes Basics_en.srt 10.7 KB
  507. 011 CODE.html 2.3 KB
  508. 012 STRICT_TRANS_TABLES.mp4 27.8 MB
  509. 012 STRICT_TRANS_TABLES_en.srt 7.4 KB
  510. 013 More Modes.mp4 77.7 MB
  511. 013 More Modes_en.srt 17.3 KB
  512. 001 Important Note (please read).html 2.7 KB
  513. 002 16-pdf-slides-window-functions.pdf 259.8 KB
  514. 002 Introducing Window Functions.mp4 67.6 MB
  515. 002 Introducing Window Functions_en.srt 13.0 KB
  516. 002 SLIDES.url 79 bytes
  517. 003 Using OVER().mp4 44.4 MB
  518. 003 Using OVER()_en.srt 15.4 KB
  519. 004 CODE.html 3.2 KB
  520. 005 PARTITION BY.mp4 59.6 MB
  521. 005 PARTITION BY_en.srt 10.8 KB
  522. 006 CODE.html 2.7 KB
  523. 007 ORDER BY with Windows.mp4 61.4 MB
  524. 007 ORDER BY with Windows_en.srt 10.6 KB
  525. 008 CODE.html 2.6 KB
  526. 009 RANK().mp4 77.3 MB
  527. 009 RANK()_en.srt 9.9 KB
  528. 010 DENSE_RANK & ROW_NUMBER().mp4 68.5 MB
  529. 010 DENSE_RANK & ROW_NUMBER()_en.srt 8.8 KB
  530. 011 CODE.html 2.6 KB
  531. 012 NTILE().mp4 34.3 MB
  532. 012 NTILE()_en.srt 6.0 KB
  533. 013 CODE.html 2.4 KB
  534. 014 FIRST_VALUE.mp4 38.8 MB
  535. 014 FIRST_VALUE_en.srt 7.1 KB
  536. 015 CODE.html 2.4 KB
  537. 016 LEAD and LAG.mp4 77.6 MB
  538. 016 LEAD and LAG_en.srt 9.7 KB
  539. 017 CODE.html 2.5 KB
  540. external-links.txt 71 bytes
  541. 001 Section Introduction.mp4 28.9 MB
  542. 001 Section Introduction_en.srt 2.4 KB
  543. 002 IMPORTANT NOTE ABOUT THIS SECTION!.mp4 27.6 MB
  544. 002 IMPORTANT NOTE ABOUT THIS SECTION!_en.srt 3.8 KB
  545. 003 17-18-pdf-slides-instagram-database-clone.pdf 5.6 MB
  546. 003 Introducing Instagram Clone.mp4 118.6 MB
  547. 003 Introducing Instagram Clone_en.srt 16.7 KB
  548. 003 SLIDES.url 80 bytes
  549. 004 Users Schema.mp4 26.5 MB
  550. 004 Users Schema_en.srt 11.3 KB
  551. 005 CODE.html 2.3 KB
  552. 006 Photos Schema.mp4 39.2 MB
  553. 006 Photos Schema_en.srt 10.2 KB
  554. 007 CODE.html 2.4 KB
  555. 008 Comments Schema.mp4 44.5 MB
  556. 008 Comments Schema_en.srt 10.2 KB
  557. 009 CODE.html 2.5 KB
  558. 010 Likes Schema.mp4 127.6 MB
  559. 010 Likes Schema_en.srt 12.2 KB
  560. 011 CODE.html 2.4 KB
  561. 012 Followers Schema.mp4 34.5 MB
  562. 012 Followers Schema_en.srt 11.8 KB
  563. 013 CODE.html 2.5 KB
  564. 014 Note!.html 2.5 KB
  565. 015 3 Approaches for Hashtags.mp4 60.0 MB
  566. 015 3 Approaches for Hashtags_en.srt 19.6 KB
  567. 016 Implementing Hashtags Table.mp4 60.3 MB
  568. 016 Implementing Hashtags Table_en.srt 7.6 KB
  569. 017 CODE.html 2.5 KB
  570. 018 Complete Instagram Schema.html 3.8 KB
  571. external-links.txt 72 bytes
  572. 001 Section Introduction.mp4 36.0 MB
  573. 001 Section Introduction_en.srt 3.2 KB
  574. 002 Getting Lots of Instagram Data.mp4 208.5 MB
  575. 002 Getting Lots of Instagram Data_en.srt 15.6 KB
  576. 003 CODE.html 2.3 KB
  577. 003 ig-clone-data.sql 429.4 KB
  578. 004 Instagram Challenge #1.mp4 20.5 MB
  579. 004 Instagram Challenge #1_en.srt 8.8 KB
  580. 005 CODE.html 2.3 KB
  581. 006 Instagram Challenge #2.mp4 67.9 MB
  582. 006 Instagram Challenge #2_en.srt 12.3 KB
  583. 007 CODE.html 2.3 KB
  584. 008 Instagram Challenge #3.mp4 49.8 MB
  585. 008 Instagram Challenge #3_en.srt 13.3 KB
  586. 009 CODE.html 2.3 KB
  587. 010 Instagram Challenge #4.mp4 48.6 MB
  588. 010 Instagram Challenge #4_en.srt 10.8 KB
  589. 011 CODE.html 2.4 KB
  590. 012 Instagram Challenge #5.mp4 16.2 MB
  591. 012 Instagram Challenge #5_en.srt 5.4 KB
  592. 013 CODE.html 2.3 KB
  593. 014 Instagram Challenge #6.mp4 31.1 MB
  594. 014 Instagram Challenge #6_en.srt 8.5 KB
  595. 015 CODE.html 2.4 KB
  596. 016 Instagram Challenge #7.mp4 33.7 MB
  597. 016 Instagram Challenge #7_en.srt 8.6 KB
  598. 017 CODE.html 2.4 KB
  599. 001 NOTE Use MySQL Locally Instead of Cloud9.html 2.5 KB
  600. 002 19-pdf-slides-database-triggers.pdf 117.6 KB
  601. 002 Introduction to Database Triggers.mp4 15.8 MB
  602. 002 Introduction to Database Triggers_en.srt 12.1 KB
  603. 002 Lecture-Slides.url 84 bytes
  604. 003 Lecture-Slides.url 87 bytes
  605. 003 users.sql 285 bytes
  606. 003 Writing Our First Trigger Part 1.mp4 34.0 MB
  607. 003 Writing Our First Trigger Part 1_en.srt 12.0 KB
  608. 004 Lecture-Slides.url 87 bytes
  609. 004 Writing Our First Trigger Part 2.mp4 90.2 MB
  610. 004 Writing Our First Trigger Part 2_en.srt 20.3 KB
  611. 005 NOTE About the Next Lecture.html 2.6 KB
  612. 006 Lecture-Slides.url 88 bytes
  613. 006 Preventing Instagram Self-Follows With Triggers.mp4 33.2 MB
  614. 006 Preventing Instagram Self-Follows With Triggers_en.srt 13.8 KB
  615. 007 Creating Logger Triggers.mp4 62.9 MB
  616. 007 Creating Logger Triggers_en.srt 17.0 KB
  617. 007 Lecture-Slides.url 88 bytes
  618. 008 Lecture-Slides.url 88 bytes
  619. 008 Managing Triggers And A Warning.mp4 95.9 MB
  620. 008 Managing Triggers And A Warning_en.srt 10.9 KB
  621. external-links.txt 522 bytes
  622. 001 Deprecated NodeWeb App Legacy Sections Download.html 3.8 KB
  623. 20.01 - Section Introduction.mp4 33.8 MB
  624. 20.02 - IMPORTANT Supplemental Video Tutorials.pdf 109.7 KB
  625. 20.03 - Using a Local Coding Environment Instead of Cloud9.pdf 135.9 KB
  626. 20.04 - Downloading Source Code.pdf 77.2 KB
  627. node-and-mysql.zip 10.1 KB
  628. 20.05 - MySQL and Other Languages.mp4 29.1 MB
  629. 20-pdf-slides-introducing-node.pdf 1.4 MB
  630. LINK - Slides For This Section.txt 46 bytes
  631. 20.06 - BUT WHAT ABOUT PHP.mp4 59.9 MB
  632. 20.07 - Introduction to JOIN US app.mp4 49.7 MB
  633. 20.08 - REMINDER NodeJS and VS Code Installation.pdf 134.3 KB
  634. 20.09 - 5 Minute NodeJS Crash Course.mp4 30.9 MB
  635. 20.09 - CODE.pdf 66.1 KB
  636. 20-09-code.js?v=1.05 192 bytes
  637. 20.10 - About the Faker Package.pdf 103.9 KB
  638. 20.11 - Introduction to NPM and Faker.mp4 56.6 MB
  639. 20.11 - UPDATED CODE.pdf 101.1 KB
  640. 20-11-code.js?v=1.05 1.0 KB
  641. 20.12 - Introducing the MySQL Package.mp4 20.6 MB
  642. LINK - mysql Node Package.txt 71 bytes
  643. 20.13 - IMPORTANT NOTE About the MySQL Package.pdf 124.7 KB
  644. LINK - mysql2 Node Package.txt 80 bytes
  645. 20.14 - REMINDER Start the MySQL Command Line Locally.pdf 131.1 KB
  646. 20.15 - CODE.pdf 159.9 KB
  647. 20.15 - Connecting Node to MySQL.mp4 96.2 MB
  648. 20-15-code.js?v=1.05 740 bytes
  649. 20.16 - CODE.pdf 41.8 KB
  650. 20.16 - Creating Our Users Table.mp4 47.4 MB
  651. 20-16-code.sql 101 bytes
  652. 20.17 - CODE.pdf 66.8 KB
  653. 20.17 - Selecting Using Node.mp4 47.1 MB
  654. 20-17-code.js?v=1.05 608 bytes
  655. 20.18 - CODE.pdf 63.6 KB
  656. 20.18 - Inserting Using Node.mp4 94.0 MB
  657. 20-18-code.js?v=1.05 534 bytes
  658. 20.19 - Some MySQL-Node Magic.mp4 68.5 MB
  659. 20.20 - Bulk Inserting 500 Users - Finally!.mp4 81.6 MB
  660. 20.20 - CODE.pdf 67.7 KB
  661. 20-20-code.sql 723 bytes
  662. 20.21 - 500 Users Exercises.mp4 10.7 MB
  663. LINK - Slides.txt 50 bytes
  664. 20.22 - 500 Users Exercises Solutions.mp4 79.8 MB
  665. 20.22 - CODE.pdf 73.0 KB
  666. 20-22-code.sql 882 bytes
  667. 21.01 - Section Introduction.mp4 39.2 MB
  668. 21.02 - REMINDER Set Up A Local Coding Environment.pdf 71.3 KB
  669. 21.03 - Join Us Completed CODE.pdf 245.3 KB
  670. JoinUsCompleteCode.zip 2.7 MB
  671. 21.04 - Introducing Express.mp4 33.6 MB
  672. 21-pdf-slides-building-our-web-app.pdf 1.6 MB
  673. LINK - Express Documentation.txt 22 bytes
  674. LINK - Slides.txt 50 bytes
  675. 21.05 - NPM Init and package.js?v=1.05on files.mp4 43.7 MB
  676. 21.06 - Previewing Our Node Web App in the Browser.pdf 88.9 KB
  677. 21.07 - CODE.pdf 60.6 KB
  678. 21.07 - Our First Simple Web App.mp4 98.8 MB
  679. 21-07-code.js?v=1.05 225 bytes
  680. 20-08-code.js?v=1.05 341 bytes
  681. 21.08 - Adding Multiple Routes.mp4 81.3 MB
  682. 21.08 - CODE.pdf 53.5 KB
  683. 21.09 - REMINDER Use the Updated Connection Code.pdf 81.9 KB
  684. 21-09-code.js?v=1.05 315 bytes
  685. 21.10 - CODE.pdf 66.0 KB
  686. 21.10 - Connecting Express and MySQL.mp4 85.2 MB
  687. 21-10-code.js?v=1.05 239 bytes
  688. 21.11 - Adding EJS Templates.mp4 119.2 MB
  689. 21.11 - CODE.pdf 67.2 KB
  690. 21-11-code.html 306 bytes
  691. JOIN_US_HTML_AND_CSS.zip 1.4 KB
  692. 21.12 - CODE.pdf 47.9 KB
  693. 21.12 - Connecting The Form.mp4 144.0 MB
  694. 21-12-code.js?v=1.05 267 bytes
  695. 21.13 - Styling Part 1.mp4 80.2 MB
  696. 21.14 - CODE - HTML AND CSS FILES.pdf 54.6 KB
  697. JOIN_US_HTML_AND_CSS.zip 1.4 KB
  698. 21.15 - Styling Part 2.mp4 99.1 MB

Discussion