Udemy - The Ultimate Mysql Bootcamp Go From Sql Beginner To Expert

Udemy.The.Ultimate.MySQL.Bootcamp.Go.from.SQL.Beginner.to.Expert-UDUMMY
Title:   The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
URL:     https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/
Length:  19:55:47
Subs:    de-DE, en-US, es-ES, fr-FR, id-ID, it-IT, ja-JP, pl-PL, pt-BR, ro-RO
Notes:
------
Headline:
---------
Become an In-demand SQL Master by creating complex databases and building reports through real-world projects
Contents:
---------
1. Introduction and 5 Minutes of SQL
 - 1. Course Introduction => 01:08
 - 2. Instructor Introduction(s) => 01:25
 - 3. Syllabus Walkthrough and Prerequisites => 04:18
 - 4. Note about SQL Editor => Article (not included)
 - 5. Your First 5 Minutes of SQL - Let's Get Coding! => 06:13
 - 6. CODE: Your First 5 Minutes of SQL => Article (not included)
 - 7. How The Course Works => 03:44
2. Getting Started: Overview and Installation
 - 8. Section Introduction => 01:02
 - 9. What Is a Database? => 07:16
 - 10. SQL Vs. MySQL => 05:50
 - 11. Important note about the next lecture => Article (not included)
 - 12. Installation Overview - WATCH BEFORE INSTALLING => 05:10
 - 13. Now using GoormIDE instead of Cloud9 => 03:16
 - 14. GoormIDE Registration IMPORTANT - PLEASE READ!!! => Article (not included)
 - 15. MySQL Tips to Make Your Life Easier => Article (not included)
 - 16. Mac Installation => 11:41
 - 17. CODE: Mac Installation => Article (not included)
 - 18. Windows Installation => 03:32
3. Creating Databases and Tables
 - 19. Section 3 Introduction => 01:09
 - 20. Creating Databases => 05:20
 - 21. CODE: Creating Databases => Article (not included)
 - 22. Dropping Databases => 01:46
 - 23. CODE: Dropping Databases => Article (not included)
 - 24. Using Databases => 03:00
 - 25. CODE: Using Databases => Article (not included)
 - 26. Introduction to Tables => 05:09
 - 27. The Basic Datatypes => 07:52
 - 28. Note about INT max size => Article (not included)
 - 29. Basic Datatypes Challenge => 02:35
 - 30. Basic Datatypes Challenge - Solution => Article (not included)
 - 31. Creating Your Own Tables => 03:06
 - 32. CODE: Creating Your Own Tables => Article (not included)
 - 33. How Do We Know It Worked? => 02:33
 - 34. CODE: How Do We Know It Worked? => Article (not included)
 - 35. Dropping Tables => 01:36
 - 36. CODE: Dropping Tables => Article (not included)
 - 37. Creating Your Own Tables Challenge => 04:29
 - 38. CODE: Creating Your Own Tables Challenge => Article (not included)
4. Inserting Data (and a couple other things)
 - 39. Section 4 Introduction => 01:40
 - 40. Inserting Data => 05:03
 - 41. CODE: Inserting Data => Article (not included)
 - 42. Super Quick Intro To SELECT => 02:07
 - 43. CODE: Super Quick Intro To SELECT => Article (not included)
 - 44. Multiple INSERT => 03:00
 - 45. CODE: Multiple Insert => Article (not included)
 - 46. INSERT Challenges => 01:35
 - 47. Note about using quotes inside of inserted values => Article (not included)
 - 48. INSERT Challenges Solution => 04:43
 - 49. CODE: INSERT Challenges Solution => Article (not included)
 - 50. NOTE: MySQL Warnings => Article (not included)
 - 51. MySQL Warnings => 05:35
 - 52. CODE: MySQL Warnings => Article (not included)
 - 53. NULL and NOT_NULL => 06:54
 - 54. CODE: NULL and NOT NULL => Article (not included)
 - 55. Setting Default Values => 07:17
 - 56. CODE: Setting Default Values => Article (not included)
 - 57. A Primer On Primary Keys => 12:21
 - 58. CODE: A Primer on Primary Keys => Article (not included)
 - 59. Table Constraints Exercise => 01:51
 - 60. Table Constraints Exercise Solution => 03:34
 - 61. CODE: Table Constraints Exercise Solution => Article (not included)
5. CRUD commmands
 - 62. Section 5 Introduction => 01:30
 - 63. Introduction to CRUD => 01:44
 - 64. CODE: Introduction to CRUD => Article (not included)
 - 65. Preparing Our Data => 02:29
 - 66. CODE: Preparing Our Data => Article (not included)
 - 67. Official Introduction to SELECT => 04:18
 - 68. CODE: Official Introduction to SELECT => Article (not included)
 - 69. Introduction to WHERE => 05:04
 - 70. CODE: Introduction to WHERE => Article (not included)
 - 71. SELECT Challenges => 02:00
 - 72. SELECT Challenges Solution => 02:45
 - 73. CODE: SELECT Challenges Solution => Article (not included)
 - 74. Introduction to Aliases => 02:55
 - 75. CODE: Introduction to Aliases => Article (not included)
 - 76. The UPDATE Command => 03:58
 - 77. CODE: The UPDATE Command => Article (not included)
 - 78. UPDATE Challenges => 00:37
 - 79. UPDATE Challenges Solution => 03:58
 - 80. CODE: UPDATE Challenges Solution => Article (not included)
 - 81. Introduction to DELETE => 04:41
 - 82. CODE: Introduction to DELETE => Article (not included)
 - 83. DELETE Challenges => 01:10
 - 84. DELETE Challenges Solution => 02:45
 - 85. CODE: DELETE Challenges Solution => Article (not included)
6. CRUD Challenge Section
 - 86. Section 6 Introduction => 01:52
 - 87. CRUD Exercise Overview => 07:26
 - 88. CRUD Exercise Create Solution => 05:55
 - 89. CODE: CRUD Exercise Create Solution => Article (not included)
 - 90. CRUD Exercise Read Solution => 01:48
 - 91. CODE: CRUD Exercise Read Solution => Article (not included)
 - 92. CRUD Exercise Update Solution => 04:10
 - 93. CODE: CRUD Exercise Update Solution => Article (not included)
 - 94. CRUD Exercise Delete Solution => 03:21
 - 95. CODE: CRUD Exercise Delete Solution => Article (not included)
7. The World Of String Functions
 - 96. Section 7 Introduction => 02:04
 - 97. Important Note about Running SQL Files (please read) => Article (not included)
 - 98. Running SQL Files => 10:15
 - 99. CODE: Running SQL Files => Article (not included)
 - 100. Loading Our Book Data => 05:25
 - 101. CODE: Loading Our Book Data => Article (not included)
 - 102. Working with CONCAT => 11:07
 - 103. CODE: Working With CONCAT => Article (not included)
 - 104. Introducing SUBSTRING => 10:04
 - 105. CODE: Introducing SUBSTRING => Article (not included)
 - 106. Introducing REPLACE => 06:39
 - 107. CODE: Introducing REPLACE => Article (not included)
 - 108. Using REVERSE => 03:39
 - 109. CODE: Using REVERSE => Article (not included)
 - 110. Working with CHAR LENGTH => 04:54
 - 111. CODE: Working with CHAR LENGTH => Article (not included)
 - 112. Changing Case with UPPER and LOWER => 03:20
 - 113. CODE: Changing Case with UPPER and LOWER => Article (not included)
 - 114. Note about string functions => Article (not included)
 - 115. String Function Challenges => 04:42
 - 116. String Function Challenges Solution => 13:08
 - 117. CODE: String Function Challenges Solution => Article (not included)
8. Refining Our Selections
 - 118. Section 8 Introduction => 00:35
 - 119. Seed Data: Adding A Couple New Books => 02:47
 - 120. CODE: Seed Data: Adding A Couple New Books => Article (not included)
 - 121. Using DISTINCT => 08:24
 - 122. CODE: Using DISTINCT => Article (not included)
 - 123. Sorting Data with ORDER BY => 11:19
 - 124. CODE: Sorting Data with ORDER BY => Article (not included)
 - 125. Using LIMIT => 09:03
 - 126. CODE: Using LIMIT => Article (not included)
 - 127. Better Searches with LIKE => 07:42
 - 128. CODE: Better Searches with LIKE => Article (not included)
 - 129. LIKE Part 2: More Wildcards => 06:09
 - 130. CODE: LIKE Part 2: More Wildcards => Article (not included)
 - 131. Refining Selections Exercises => 04:52
 - 132. Refining Selections Exercises Solution => 12:29
 - 133. CODE: Refining Selections Exercises Solution => Article (not included)
9. The Magic of Aggregate Functions
 - 134. Section 9 Introduction => 03:56
 - 135. The Count Function => 08:38
 - 136. CODE: The Count Function => Article (not included)
 - 137. The Joys of Group By => 12:22
 - 138. Note about SQL Mode only_full_group_by => 04:19
 - 139. CODE: The Joys of Group By => Article (not included)
 - 140. Min and Max Basics => 04:12
 - 141. CODE: MIN and MAX Basics => Article (not included)
 - 142. SUBQUERIES - A Problem with Min and Max => 07:14
 - 143. CODE: A Problem with Min and Max => Article (not included)
 - 144. Using Min and Max with Group By => 06:39
 - 145. CODE: Using Min and Max with Group By => Article (not included)
 - 146. The Sum Function => 04:27
 - 147. CODE: The Sum Function => Article (not included)
 - 148. The Avg Function => 06:00
 - 149. CODE: The Avg Function => Article (not included)
 - 150. Aggregate Functions Challenges => 04:27
 - 151. Aggregate Functions Challenges Solution => 09:10
 - 152. CODE: Aggregate Functions Challenges Solution => Article (not included)
10. Revisiting Data Types
 - 153. Section 10 Introduction => 01:56
 - 154. CHAR and VARCHAR => 14:29
 - 155. Note about CHAR and VARCHAR => Article (not included)
 - 156. CODE: CHAR and VARCHAR => Article (not included)
 - 157. DECIMAL => 06:07
 - 158. CODE: DECIMAL => Article (not included)
 - 159. FLOAT and DOUBLE => 07:44
 - 160. CODE: FLOAT and DOUBLE => Article (not included)
 - 161. Note about setting the timezone in Cloud9 => Article (not included)
 - 162. DATE, TIME, and DATETIME => 04:31
 - 163. Creating Our DATE data => 05:49
 - 164. CODE: Creating Our DATE data => Article (not included)
 - 165. CURDATE, CURTIME, and NOW => 05:15
 - 166. Note about formatting dates => Article (not included)
 - 167. Formatting Dates => 14:29
 - 168. CODE: Formatting Dates => Article (not included)
 - 169. Date Math => 09:40
 - 170. CODE: Date Math => Article (not included)
 - 171. Working with TIMESTAMPS => 10:54
 - 172. CODE: Working with TIMESTAMPS => Article (not included)
 - 173. Data Types Exercises => 04:50
 - 174. Data Types Exercises Solution => 13:58
 - 175. CODE: Data Types Exercises Solution => Article (not included)
11. The Power of Logical Operators
 - 176. Section 11 Introduction => 02:44
 - 177. Not Equal => 04:26
 - 178. CODE: Not Equal => Article (not included)
 - 179. Not Like => 02:34
 - 180. CODE: Not Like => Article (not included)
 - 181. Greater Than => 10:04
 - 182. CODE: Greater Than => Article (not included)
 - 183. Less Than => 03:48
 - 184. CODE: Less Than => Article (not included)
 - 185. Logical AND => 09:47
 - 186. CODE: Logical AND => Article (not included)
 - 187. Logical OR => 06:41
 - 188. CODE: Logical OR => Article (not included)
 - 189. Between => 10:57
 - 190. CODE: Between => Article (not included)
 - 191. In And Not In => 11:47
 - 192. CODE: In And Not In => Article (not included)
 - 193. Case Statements => 11:20
 - 194. CODE: Case Statements => Article (not included)
 - 195. Logical Operators Exercises => 06:45
 - 196. Logical Operators Exercises Solution => 17:46
 - 197. CODE: Logical Operators Exercises Solution => Article (not included)
12. Section 12: One To Many
 - 198. Section 12 Introduction => 01:57
 - 199. Real World Data Is Messy => 10:28
 - 200. Types of Data Relationships => 04:36
 - 201. One To Many: The Basics => 12:33
 - 202. Working With Foreign Keys => 12:04
 - 203. CODE: Working With Foreign Keys => Article (not included)
 - 204. Cross Join => 07:36
 - 205. CODE: Cross Joins => Article (not included)
 - 206. Inner Join => 12:44
 - 207. CODE: Inner Joins => Article (not included)
 - 208. Left Join => 15:17
 - 209. CODE: Left Joins => Article (not included)
 - 210. Right Joins Pt 1 => 10:36
 - 211. CODE: Right Joins Part 1 => Article (not included)
 - 212. Right Joins Pt 2 => 09:51
 - 213. CODE: Right Joins Part 2 => Article (not included)
 - 214. Right and Left Joins: A Common Question => 03:09
 - 215. CODE: Right and Left Joins FAQ => Article (not included)
 - 216. Our First Joins Exercise => 06:58
 - 217. Our First Joins Exercise SOLUTION => 09:10
 - 218. CODE: Our First Joins Exercise => Article (not included)
 - 219. Our First Joins Exercise SOLUTION PT. 2 => 09:21
 - 220. CODE: Our First Joins Exercise SOLUTION PT. 2 => Article (not included)
13. Section 13: Many To Many
 - 221. Section 13 Introduction => 01:54
 - 222. Many To Many Basics => 10:48
 - 223. Creating Our Tables => 10:57
 - 224. CODE: Creating Our Tables => Article (not included)
 - 225. TV Joins Challenge 1 => 04:49
 - 226. CODE: TV Joins Challenge 1 Solution => Article (not included)
 - 227. TV Joins Challenge 2 => 06:22
 - 228. CODE: TV Joins Challenge 2 SOLUTION => Article (not included)
 - 229. TV Joins Challenge 3 => 04:59
 - 230. CODE: TV Joins Challenge 3 SOLUTION => Article (not included)
 - 231. TV Joins Challenge 4 => 05:59
 - 232. CODE: TV Joins Challenge 4 SOLUTION => Article (not included)
 - 233. TV Joins Challenge 5 => 04:56
 - 234. CODE: TV Joins Challenge 5 SOLUTION => Article (not included)
 - 235. TV Joins Challenge 6 => 11:57
 - 236. CODE: TV Joins Challenge 6 SOLUTION => Article (not included)
 - 237. TV Joins Challenge 7 => 07:08
 - 238. CODE: TV Joins Challenge 7 SOLUTION => Article (not included)
14. Instagram Database Clone
 - 239. Section 14 Introduction => 01:19
 - 240. Introduction To Instagram Clone Schema => 08:31
 - 241. Cloning Instagram's DB: Users Schema => 06:08
 - 242. CODE: IG Clone Users Schema => Article (not included)
 - 243. Cloning Instagram's DB: Photos Schema => 06:37
 - 244. CODE: IG Clone Photos Schema => Article (not included)
 - 245. Cloning Instagram's DB: Comments Schema => 06:39
 - 246. CODE: IG Clone Comments Schema => Article (not included)
 - 247. Cloning Instagram's DB: Likes Schema => 07:41
 - 248. CODE: IG Clone Likes Schema => Article (not included)
 - 249. Cloning Instagram's DB: Followers Schema => 07:20
 - 250. CODE: IG Clone Followers Schema => Article (not included)
 - 251. Note about: Cloning Instagram's DB: Hashtags Part 1 => Article (not included)
 - 252. Cloning Instagram's DB: Hashtags Part 1 => 10:34
 - 253. Cloning Instagram's DB: Hashtags Part 2 => 05:25
 - 254. CODE: IG Clone Hashtags Schema => Article (not included)
 - 255. CODE: Complete IG Clone Schema => Article (not included)
15. Working With Lots Of Instagram Data
 - 256. Section 15 Introduction => 01:41
 - 257. Note about Loading The JUMBO dataset => Article (not included)
 - 258. Loading The JUMBO dataset => 08:30
 - 259. The Instagram Clone DATASET => Article (not included)
 - 260. Instagram Clone Challenge 1 => 04:52
 - 261. Instagram Challenge 1 Solution CODE => Article (not included)
 - 262. Instagram Clone Challenge 2 => 06:41
 - 263. Instagram Challenge 2 Solution CODE => Article (not included)
 - 264. Instagram Clone Challenge 3 => 07:22
 - 265. Instagram Challenge 3 Solution CODE => Article (not included)
 - 266. Instagram Clone Challenge 4 => 07:05
 - 267. Instagram Challenge 4 Solution CODE => Article (not included)
 - 268. Instagram Clone Challenge 5 => 03:13
 - 269. Instagram Challenge 5 Solution CODE => Article (not included)
 - 270. Instagram Clone Challenge 6 => 05:29
 - 271. Instagram Challenge 6 Solution CODE => Article (not included)
 - 272. Note about Instagram Clone Challenge 7 => Article (not included)
 - 273. Instagram Clone Challenge 7 => 05:14
 - 274. Instagram Challenge 7 Solution CODE => Article (not included)
16. Section 16 - Introducing Node
 - 275. Note about Introducing Node => Article (not included)
 - 276. Section 16 Introduction => 01:36
 - 277. MySQL and Other Languages => 08:59
 - 278. BUT WHAT ABOUT PHP => 07:34
 - 279. Introduction to JOIN US app => 08:00
 - 280. Note about Setting Up Cloud9 for Node => Article (not included)
 - 281. 5 Minute NodeJS Crash Course => 06:12
 - 282. CODE: 5 Minute Node Crash Course => Article (not included)
 - 283. Note about Faker install => Article (not included)
 - 284. Introduction to NPM and Faker => 09:11
 - 285. CODE: Introduction to NPM and Faker => Article (not included)
 - 286. Introducing the MySQL Package => 04:53
 - 287. Note about connecting Node to MySQL => Article (not included)
 - 288. Connecting Node to MySQL => 12:46
 - 289. CODE: Connecting Node to MySQL => Article (not included)
 - 290. Creating Our Users Table => 06:54
 - 291. CODE: Creating Our Users Table => Article (not included)
 - 292. Selecting Using Node => 06:15
 - 293. CODE: Selecting Using Node => Article (not included)
 - 294. Inserting Using Node => 11:31
 - 295. CODE: Inserting Using Node => Article (not included)
 - 296. Some MySQL/Node Magic => 07:41
 - 297. Bulk Inserting 500 Users - Finally! => 08:40
 - 298. CODE: Bulk Inserting 500 Users => Article (not included)
 - 299. 500 Users Exercises => 02:30
 - 300. 500 Users Exercises Solutions => 11:55
 - 301. CODE: 500 Users Exercises Solutions => Article (not included)
17. Section 17 - Building Our Web App
 - 302. Section 17 Introduction => 01:52
 - 303. Join Us Completed CODE => Article (not included)
 - 304. Introducing Express => 05:40
 - 305. NPM Init and package.json files => 06:38
 - 306. Note about Our First Simple Web App => Article (not included)
 - 307. Our First Simple Web App => 16:33
 - 308. CODE: Our First Simple Web App => Article (not included)
 - 309. Adding Multiple Routes => 09:56
 - 310. CODE: Adding Multiple Routes => Article (not included)
 - 311. Connecting Express and MySQL => 11:08
 - 312. CODE: Connecting Express and MySQL => Article (not included)
 - 313. Adding EJS Templates => 16:02
 - 314. CODE: Adding EJS Templates => Article (not included)
 - 315. Connecting The Form => 18:32
 - 316. CODE: Connecting the Form => Article (not included)
 - 317. Styling Part 1 => 08:24
 - 318. CODE: HTML AND CSS FILES => Article (not included)
 - 319. Styling Part 2 => 08:16
18. Section 18 - Database Triggers
 - 320. Introduction to Database Triggers => 06:10
 - 321. Writing Our First Trigger Part 1 => 07:27
 - 322. Writing Our First Trigger Part 2 => 11:36
 - 323. Note about next lecture => Article (not included)
 - 324. Preventing Instagram Self-Follows With Triggers => 08:16
 - 325. Creating Logger Triggers => 10:17
 - 326. Managing Triggers And A Warning => 06:12

https://rapidgator.net/file/8f98f34b654b4eb43c3639427e26ef4d/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part01.rar
https://rapidgator.net/file/dd4f81631ef37e4c6612efaa2e87693f/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part02.rar
https://rapidgator.net/file/ee68810dad1d4fffc4c413c6a4108477/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part03.rar
https://rapidgator.net/file/c0d2323460df8804dac47884d5898611/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part04.rar
https://rapidgator.net/file/90839bb11c16d6cf39859abfe143378f/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part05.rar
https://rapidgator.net/file/177d452c85b22179183b4ccff08b289d/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part06.rar
https://rapidgator.net/file/f5b53f01fa3bed374a6ce0f05597eb06/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part07.rar
https://rapidgator.net/file/90f169fe1b1905399b0d9df33c1cfeba/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part08.rar
https://rapidgator.net/file/e418b5eea62283a134472016b7160867/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part09.rar

https://nitroflare.com/view/994D9E6D96B1FE5/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part01.rar
https://nitroflare.com/view/7DA5BA7032611BD/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part02.rar
https://nitroflare.com/view/65E8C3911B2570C/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part03.rar
https://nitroflare.com/view/26B396781C87D61/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part04.rar
https://nitroflare.com/view/285E2A2BEE84506/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part05.rar
https://nitroflare.com/view/99CAAE0F8DC0256/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part06.rar
https://nitroflare.com/view/FD33132FF3B498A/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part07.rar
https://nitroflare.com/view/C5B4EFA58B2AB11/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part08.rar
https://nitroflare.com/view/9E7796E9590FD87/udemy.the.ultimate.mysql.bootcamp.go.from.sql.beginner.to.expert-udummy.part09.rar