Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:03:09
    This Course Was Just Updated!
  • Урок 2. 00:01:09
    Course Intro
  • Урок 3. 00:01:26
    About Me
  • Урок 4. 00:01:41
    Getting The Course Code
  • Урок 5. 00:08:24
    First 5 Minutes of SQL
  • Урок 6. 00:01:03
    Section Introduction
  • Урок 7. 00:07:17
    What Is A Database?
  • Урок 8. 00:05:51
    SQL vs. MySQL
  • Урок 9. 00:05:18
    Installation: START HERE!
  • Урок 10. 00:09:14
    Installation: Windows Instructions
  • Урок 11. 00:11:35
    Installation: Mac Instructions
  • Урок 12. 00:01:10
    Section Introduction
  • Урок 13. 00:04:16
    Showing Databases
  • Урок 14. 00:04:56
    Creating Databases
  • Урок 15. 00:05:33
    Dropping and Using Databases
  • Урок 16. 00:05:19
    Introducing Tables
  • Урок 17. 00:07:39
    Data Types: The Basics
  • Урок 18. 00:02:36
    Basic Datatypes Challenge
  • Урок 19. 00:04:58
    Creating Tables
  • Урок 20. 00:04:34
    How Do We Know It Worked?
  • Урок 21. 00:02:11
    Dropping Tables
  • Урок 22. 00:02:37
    Tables Basics Activity
  • Урок 23. 00:03:13
    MySQL Comments
  • Урок 24. 00:01:41
    Section Introduction
  • Урок 25. 00:03:45
    INSERT: The Basics
  • Урок 26. 00:01:45
    A Quick Preview of SELECT
  • Урок 27. 00:04:49
    Multi-inserts
  • Урок 28. 00:05:28
    INSERT Exercise
  • Урок 29. 00:05:41
    Working With NOT NULL
  • Урок 30. 00:04:14
    Sidenote: Quotes In MySQL
  • Урок 31. 00:06:32
    Adding DEFAULT Values
  • Урок 32. 00:04:58
    Introducing Primary Keys
  • Урок 33. 00:07:14
    Working With AUTO_INCREMENT
  • Урок 34. 00:07:20
    Create Table/ Insert Exercise
  • Урок 35. 00:01:31
    Section Introduction
  • Урок 36. 00:01:52
    Introducing CRUD
  • Урок 37. 00:01:51
    Getting Our New "Dataset"
  • Урок 38. 00:03:14
    Officially Introducing SELECT
  • Урок 39. 00:03:33
    The WHERE clause
  • Урок 40. 00:01:26
    Rapid Fire Exercises
  • Урок 41. 00:02:56
    Rapid Fire Exercises SOLUTION
  • Урок 42. 00:02:14
    Aliases
  • Урок 43. 00:05:25
    Using UPDATE
  • Урок 44. 00:01:45
    A Quick Rule Of Thumb
  • Урок 45. 00:01:05
    UPDATE Exercise
  • Урок 46. 00:03:03
    UPDATE Exercise SOLUTION
  • Урок 47. 00:02:38
    Introducing DELETE
  • Урок 48. 00:00:59
    DELETE Exercise
  • Урок 49. 00:02:16
    DELETE Exercise SOLUTION
  • Урок 50. 00:01:53
    Section Introduction
  • Урок 51. 00:05:12
    Introducing the CRUD Challenge
  • Урок 52. 00:08:09
    CRUD Challenge Solution: Creating
  • Урок 53. 00:01:43
    CRUD Challenge Solution: Reading
  • Урок 54. 00:03:25
    CRUD Challenge Solution: Updating
  • Урок 55. 00:02:51
    CRUD Challenge Solution: Deleting
  • Урок 56. 00:02:05
    Section Introduction
  • Урок 57. 00:01:53
    The World Of String Functions
  • Урок 58. 00:05:26
    Loading Our Books Data
  • Урок 59. 00:08:51
    CONCAT
  • Урок 60. 00:07:32
    SUBSTRING
  • Урок 61. 00:06:50
    Combining String Functions
  • Урок 62. 00:04:27
    Sidenote: SQL Formatting
  • Урок 63. 00:05:44
    REPLACE
  • Урок 64. 00:03:31
    REVERSE
  • Урок 65. 00:02:51
    CHAR_LENGTH
  • Урок 66. 00:03:49
    UPPER & LOWER
  • Урок 67. 00:06:22
    Other String Functions
  • Урок 68. 00:03:44
    String Functions Exercise
  • Урок 69. 00:11:33
    String Functions Exerise SOLUTION
  • Урок 70. 00:00:36
    Section Introduction
  • Урок 71. 00:01:27
    Adding Some New Books
  • Урок 72. 00:06:13
    DISTINCT
  • Урок 73. 00:06:38
    ORDER BY
  • Урок 74. 00:06:20
    More On ORDER BY
  • Урок 75. 00:05:40
    LIMIT
  • Урок 76. 00:07:15
    LIKE
  • Урок 77. 00:02:04
    Escaping Wildcards
  • Урок 78. 00:03:06
    Refining Selections Exercise
  • Урок 79. 00:14:41
    Refining Selections Exercise SOLUTION
  • Урок 80. 00:03:57
    Section Introduction
  • Урок 81. 00:07:34
    Count Basics
  • Урок 82. 00:10:12
    GROUP BY
  • Урок 83. 00:03:46
    MIN and MAX Basics
  • Урок 84. 00:06:27
    Subqueries
  • Урок 85. 00:04:48
    Grouping By Multiple Columns
  • Урок 86. 00:05:51
    MIN and MAX With GROUP BY
  • Урок 87. 00:03:46
    SUM
  • Урок 88. 00:02:24
    AVG
  • Урок 89. 00:01:18
    Aggregate Functions Docs
  • Урок 90. 00:02:52
    Agg Functions Exercise
  • Урок 91. 00:12:36
    Agg Functions Exercise SOLUTION
  • Урок 92. 00:01:57
    Section Introduction
  • Урок 93. 00:02:53
    Surveying Other Data Types
  • Урок 94. 00:12:07
    CHAR vs. VARCHAR
  • Урок 95. 00:05:03
    INT, TINYINT, BIGINT, etc.
  • Урок 96. 00:06:56
    DECIMAL
  • Урок 97. 00:05:32
    FLOAT & DOUBLE
  • Урок 98. 00:04:38
    DATE and TIME
  • Урок 99. 00:07:40
    Working With Dates
  • Урок 100. 00:04:16
    CURDATE, CURTIME, & NOW
  • Урок 101. 00:06:04
    Date Functions
  • Урок 102. 00:02:04
    Time Functions
  • Урок 103. 00:09:14
    Formatting Dates
  • Урок 104. 00:10:43
    Date Math
  • Урок 105. 00:03:29
    TIMESTAMPS
  • Урок 106. 00:06:59
    DEFAULT & ON UPDATE TIMESTAMPS
  • Урок 107. 00:03:37
    Data Types Exercise
  • Урок 108. 00:13:17
    Data Types Exercise SOLUTION
  • Урок 109. 00:02:45
    Section Introduction
  • Урок 110. 00:02:57
    Not Equal
  • Урок 111. 00:03:22
    NOT LIKE
  • Урок 112. 00:03:57
    Greater Than
  • Урок 113. 00:02:58
    Less Than Or Equal To
  • Урок 114. 00:08:54
    Logical AND
  • Урок 115. 00:05:39
    Logical OR
  • Урок 116. 00:04:48
    Between
  • Урок 117. 00:08:16
    Comparing Dates
  • Урок 118. 00:08:30
    The IN Operator
  • Урок 119. 00:08:48
    CASE
  • Урок 120. 00:02:04
    IS NULL
  • Урок 121. 00:03:26
    Exercise
  • Урок 122. 00:15:23
    Exercise SOLUTION
  • Урок 123. 00:03:45
    UNIQUE Constraint
  • Урок 124. 00:05:00
    CHECK Constraints
  • Урок 125. 00:04:14
    Named Constraints
  • Урок 126. 00:05:21
    Multiple Column Constraints
  • Урок 127. 00:05:39
    ALTER TABLE: Adding Columns
  • Урок 128. 00:01:55
    ALTER TABLE: Dropping Columns
  • Урок 129. 00:03:44
    ALTER TABLE: Renaming
  • Урок 130. 00:03:56
    ALTER TABLE: Modifying Columns
  • Урок 131. 00:04:13
    ALTER TABLE: Constraints
  • Урок 132. 00:01:58
    Section Introduction
  • Урок 133. 00:10:29
    Data is Messy
  • Урок 134. 00:04:38
    Relationships Basics
  • Урок 135. 00:12:34
    One to Many Relationship
  • Урок 136. 00:11:08
    Working with FOREIGN KEY
  • Урок 137. 00:08:00
    Cross Joins
  • Урок 138. 00:08:53
    Inner Joins
  • Урок 139. 00:04:54
    Inner Joins With Group By
  • Урок 140. 00:07:06
    Left Join
  • Урок 141. 00:03:36
    Left Join With Group By
  • Урок 142. 00:04:29
    Right Join
  • Урок 143. 00:05:37
    On Delete Cascade
  • Урок 144. 00:03:02
    Joins Exercise
  • Урок 145. 00:10:43
    Joins Exercise SOLUTION
  • Урок 146. 00:01:55
    Section Introduction
  • Урок 147. 00:10:49
    Many to Many Basics
  • Урок 148. 00:06:44
    Creating Our Many To Many Tables
  • Урок 149. 00:03:36
    TV Series Challenge #1
  • Урок 150. 00:03:25
    TV Series Challenge #2
  • Урок 151. 00:03:39
    TV Series Challenge #3
  • Урок 152. 00:03:35
    TV Series Challenge #4
  • Урок 153. 00:02:26
    TV Series Challenge #5
  • Урок 154. 00:09:11
    TV Series Challenge #6
  • Урок 155. 00:05:28
    TV Series Challenge #7
  • Урок 156. 00:06:32
    Introducing Views
  • Урок 157. 00:05:43
    Updateable Views
  • Урок 158. 00:03:27
    Replacing/Altering Views
  • Урок 159. 00:04:29
    HAVING clause
  • Урок 160. 00:08:19
    WITH ROLLUP
  • Урок 161. 00:05:52
    SQL Modes Basics
  • Урок 162. 00:04:26
    STRICT_TRANS_TABLES
  • Урок 163. 00:09:50
    More Modes
  • Урок 164. 00:06:29
    Introducing Window Functions
  • Урок 165. 00:08:16
    Using OVER()
  • Урок 166. 00:06:54
    PARTITION BY
  • Урок 167. 00:06:42
    ORDER BY with Windows
  • Урок 168. 00:05:54
    RANK()
  • Урок 169. 00:05:15
    DENSE_RANK, & ROW_NUMBER()
  • Урок 170. 00:03:37
    NTILE()
  • Урок 171. 00:04:06
    FIRST_VALUE
  • Урок 172. 00:05:52
    LEAD and LAG
  • Урок 173. 00:01:20
    Section Introduction
  • Урок 174. 00:01:53
    IMPORTANT NOTE ABOUT THIS SECTION!
  • Урок 175. 00:08:32
    Introducing Instagram Clone
  • Урок 176. 00:06:09
    Users Schema
  • Урок 177. 00:06:38
    Photos Schema
  • Урок 178. 00:06:40
    Comments Schema
  • Урок 179. 00:07:42
    Likes Schema
  • Урок 180. 00:07:21
    Followers Schema
  • Урок 181. 00:10:35
    3 Approaches for Hashtags
  • Урок 182. 00:05:27
    Implementing Hashtags Table
  • Урок 183. 00:01:43
    Section Introduction
  • Урок 184. 00:08:31
    Getting Lots of Instagram Data
  • Урок 185. 00:04:54
    Instagram Challenge #1
  • Урок 186. 00:06:42
    Instagram Challenge #2
  • Урок 187. 00:07:23
    Instagram Challenge #3
  • Урок 188. 00:07:06
    Instagram Challenge #4
  • Урок 189. 00:03:14
    Instagram Challenge #5
  • Урок 190. 00:05:30
    Instagram Challenge #6
  • Урок 191. 00:05:16
    Instagram Challenge #7
  • Урок 192. 00:01:09
    Course Introduction
  • Урок 193. 00:01:26
    Instructor Introduction(s)
  • Урок 194. 00:04:19
    Syllabus Walkthrough and Prerequisites
  • Урок 195. 00:06:14
    Your First 5 Minutes of SQL - Let's Get Coding!
  • Урок 196. 00:03:45
    How The Course Works
  • Урок 197. 00:01:03
    Section Introduction
  • Урок 198. 00:07:17
    What Is a Database?
  • Урок 199. 00:05:51
    SQL Vs. MySQL
  • Урок 200. 00:05:11
    Installation Overview - WATCH BEFORE INSTALLING
  • Урок 201. 00:03:17
    Now using GoormIDE instead of Cloud9
  • Урок 202. 00:11:42
    Mac Installation
  • Урок 203. 00:03:33
    Windows Installation
  • Урок 204. 00:01:10
    Section 3 Introduction
  • Урок 205. 00:05:21
    Creating Databases
  • Урок 206. 00:01:47
    Dropping Databases
  • Урок 207. 00:03:01
    Using Databases
  • Урок 208. 00:05:10
    Introduction to Tables
  • Урок 209. 00:07:53
    The Basic Datatypes
  • Урок 210. 00:02:36
    Basic Datatypes Challenge
  • Урок 211. 00:00:00
    Creating Your Own Tables
  • Урок 212. 00:02:34
    How Do We Know It Worked?
  • Урок 213. 00:01:37
    Dropping Tables
  • Урок 214. 00:04:30
    Creating Your Own Tables Challenge
  • Урок 215. 00:01:41
    Section 4 Introduction
  • Урок 216. 00:05:04
    Inserting Data
  • Урок 217. 00:02:09
    Super Quick Intro To SELECT
  • Урок 218. 00:03:01
    Multiple INSERT
  • Урок 219. 00:01:36
    INSERT Challenges
  • Урок 220. 00:04:44
    INSERT Challenges Solution
  • Урок 221. 00:05:36
    MySQL Warnings
  • Урок 222. 00:06:55
    NULL and NOT_NULL
  • Урок 223. 00:07:18
    Setting Default Values
  • Урок 224. 00:12:22
    A Primer On Primary Keys
  • Урок 225. 00:01:52
    Table Constraints Exercise
  • Урок 226. 00:03:35
    Table Constraints Exercise Solution
  • Урок 227. 00:01:31
    Section 5 Introduction
  • Урок 228. 00:01:45
    Introduction to CRUD
  • Урок 229. 00:02:30
    Preparing Our Data
  • Урок 230. 00:04:19
    Official Introduction to SELECT
  • Урок 231. 00:05:06
    Introduction to WHERE
  • Урок 232. 00:02:01
    SELECT Challenges
  • Урок 233. 00:02:46
    SELECT Challenges Solution
  • Урок 234. 00:02:56
    Introduction to Aliases
  • Урок 235. 00:03:59
    The UPDATE Command
  • Урок 236. 00:00:38
    UPDATE Challenges
  • Урок 237. 00:03:59
    UPDATE Challenges Solution
  • Урок 238. 00:04:42
    Introduction to DELETE
  • Урок 239. 00:01:12
    DELETE Challenges
  • Урок 240. 00:02:46
    DELETE Challenges Solution
  • Урок 241. 00:01:53
    Section 6 Introduction
  • Урок 242. 00:07:27
    CRUD Exercise Overview
  • Урок 243. 00:05:56
    CRUD Exercise Create Solution
  • Урок 244. 00:01:49
    CRUD Exercise Read Solution
  • Урок 245. 00:04:11
    CRUD Exercise Update Solution
  • Урок 246. 00:03:22
    CRUD Exercise Delete Solution
  • Урок 247. 00:02:05
    Section 7 Introduction
  • Урок 248. 00:10:16
    Running SQL Files
  • Урок 249. 00:05:26
    Loading Our Book Data
  • Урок 250. 00:11:08
    Working with CONCAT
  • Урок 251. 00:10:05
    Introducing SUBSTRING
  • Урок 252. 00:06:40
    Introducing REPLACE
  • Урок 253. 00:03:40
    Using REVERSE
  • Урок 254. 00:04:55
    Working with CHAR LENGTH
  • Урок 255. 00:03:21
    Changing Case with UPPER and LOWER
  • Урок 256. 00:04:43
    String Function Challenges
  • Урок 257. 00:13:09
    String Function Challenges Solution
  • Урок 258. 00:00:36
    Section 8 Introduction
  • Урок 259. 00:02:48
    Seed Data: Adding A Couple New Books
  • Урок 260. 00:08:25
    Using DISTINCT
  • Урок 261. 00:11:20
    Sorting Data with ORDER BY
  • Урок 262. 00:09:04
    Using LIMIT
  • Урок 263. 00:07:43
    Better Searches with LIKE
  • Урок 264. 00:06:10
    LIKE Part 2: More Wildcards
  • Урок 265. 00:04:53
    Refining Selections Exercises
  • Урок 266. 00:12:30
    Refining Selections Exercises Solution
  • Урок 267. 00:03:57
    Section 9 Introduction
  • Урок 268. 00:08:39
    The Count Function
  • Урок 269. 00:12:23
    The Joys of Group By
  • Урок 270. 00:04:20
    Note about SQL Mode only_full_group_by
  • Урок 271. 00:04:13
    Min and Max Basics
  • Урок 272. 00:07:16
    SUBQUERIES - A Problem with Min and Max
  • Урок 273. 00:06:40
    Using Min and Max with Group By
  • Урок 274. 00:04:28
    The Sum Function
  • Урок 275. 00:06:01
    The Avg Function
  • Урок 276. 00:04:28
    Aggregate Functions Challenges
  • Урок 277. 00:09:11
    Aggregate Functions Challenges Solution
  • Урок 278. 00:01:57
    Section 10 Introduction
  • Урок 279. 00:14:30
    CHAR and VARCHAR
  • Урок 280. 00:06:09
    DECIMAL
  • Урок 281. 00:07:45
    FLOAT and DOUBLE
  • Урок 282. 00:04:32
    DATE, TIME, and DATETIME
  • Урок 283. 00:05:50
    Creating Our DATE data
  • Урок 284. 00:05:16
    CURDATE, CURTIME, and NOW
  • Урок 285. 00:14:30
    Formatting Dates
  • Урок 286. 00:09:41
    Date Math
  • Урок 287. 00:10:55
    Working with TIMESTAMPS
  • Урок 288. 00:04:51
    Data Types Exercises
  • Урок 289. 00:13:59
    Data Types Exercises Solution
  • Урок 290. 00:02:45
    Section 11 Introduction
  • Урок 291. 00:04:27
    Not Equal
  • Урок 292. 00:02:35
    Not Like
  • Урок 293. 00:10:05
    Greater Than
  • Урок 294. 00:03:49
    Less Than
  • Урок 295. 00:09:48
    Logical AND
  • Урок 296. 00:06:42
    Logical OR
  • Урок 297. 00:10:58
    Between
  • Урок 298. 00:11:48
    In And Not In
  • Урок 299. 00:11:22
    Case Statements
  • Урок 300. 00:06:46
    Logical Operators Exercises
  • Урок 301. 00:17:48
    Logical Operators Exercises Solution
  • Урок 302. 00:01:58
    Section 12 Introduction
  • Урок 303. 00:10:29
    Real World Data Is Messy
  • Урок 304. 00:04:38
    Types of Data Relationships
  • Урок 305. 00:12:34
    One To Many: The Basics
  • Урок 306. 00:12:05
    Working With Foreign Keys
  • Урок 307. 00:07:37
    Cross Join
  • Урок 308. 00:12:46
    Inner Join
  • Урок 309. 00:15:18
    Left Join
  • Урок 310. 00:10:37
    Right Joins Pt 1
  • Урок 311. 00:09:52
    Right Joins Pt 2
  • Урок 312. 00:03:10
    Right and Left Joins: A Common Question
  • Урок 313. 00:06:59
    Our First Joins Exercise
  • Урок 314. 00:09:11
    Our First Joins Exercise SOLUTION
  • Урок 315. 00:09:22
    Our First Joins Exercise SOLUTION PT. 2
  • Урок 316. 00:01:55
    Section 13 Introduction
  • Урок 317. 00:10:49
    Many To Many Basics
  • Урок 318. 00:10:58
    Creating Our Tables
  • Урок 319. 00:04:50
    TV Joins Challenge 1
  • Урок 320. 00:06:23
    TV Joins Challenge 2
  • Урок 321. 00:05:00
    TV Joins Challenge 3
  • Урок 322. 00:06:00
    TV Joins Challenge 4
  • Урок 323. 00:04:57
    TV Joins Challenge 5
  • Урок 324. 00:11:58
    TV Joins Challenge 6
  • Урок 325. 00:07:10
    TV Joins Challenge 7
  • Урок 326. 00:01:20
    Section 14 Introduction
  • Урок 327. 00:08:32
    Introduction To Instagram Clone Schema
  • Урок 328. 00:06:09
    Cloning Instagram's DB: Users Schema
  • Урок 329. 00:06:38
    Cloning Instagram's DB: Photos Schema
  • Урок 330. 00:06:40
    Cloning Instagram's DB: Comments Schema
  • Урок 331. 00:07:42
    Cloning Instagram's DB: Likes Schema
  • Урок 332. 00:07:21
    Cloning Instagram's DB: Followers Schema
  • Урок 333. 00:10:35
    Cloning Instagram's DB: Hashtags Part 1
  • Урок 334. 00:05:27
    Cloning Instagram's DB: Hashtags Part 2
  • Урок 335. 00:01:43
    Section 15 Introduction
  • Урок 336. 00:08:31
    Loading The JUMBO dataset
  • Урок 337. 00:04:54
    Instagram Clone Challenge 1
  • Урок 338. 00:06:42
    Instagram Clone Challenge 2
  • Урок 339. 00:07:23
    Instagram Clone Challenge 3
  • Урок 340. 00:07:06
    Instagram Clone Challenge 4
  • Урок 341. 00:03:14
    Instagram Clone Challenge 5
  • Урок 342. 00:05:30
    Instagram Clone Challenge 6
  • Урок 343. 00:05:16
    Instagram Clone Challenge 7
  • Урок 344. 00:01:37
    Section 16 Introduction
  • Урок 345. 00:09:00
    MySQL and Other Languages
  • Урок 346. 00:07:35
    BUT WHAT ABOUT PHP
  • Урок 347. 00:08:01
    Introduction to JOIN US app
  • Урок 348. 00:06:13
    5 Minute NodeJS Crash Course
  • Урок 349. 00:09:12
    Introduction to NPM and Faker
  • Урок 350. 00:04:54
    Introducing the MySQL Package
  • Урок 351. 00:12:47
    Connecting Node to MySQL
  • Урок 352. 00:06:55
    Creating Our Users Table
  • Урок 353. 00:06:16
    Selecting Using Node
  • Урок 354. 00:11:32
    Inserting Using Node
  • Урок 355. 00:07:42
    Some MySQL/Node Magic
  • Урок 356. 00:08:41
    Bulk Inserting 500 Users - Finally!
  • Урок 357. 00:02:31
    500 Users Exercises
  • Урок 358. 00:11:56
    500 Users Exercises Solutions
  • Урок 359. 00:01:53
    Section 17 Introduction
  • Урок 360. 00:05:41
    Introducing Express
  • Урок 361. 00:06:39
    NPM Init and package.json files
  • Урок 362. 00:16:34
    Our First Simple Web App
  • Урок 363. 00:09:57
    Adding Multiple Routes
  • Урок 364. 00:11:09
    Connecting Express and MySQL
  • Урок 365. 00:16:03
    Adding EJS Templates
  • Урок 366. 00:18:33
    Connecting The Form
  • Урок 367. 00:08:25
    Styling Part 1
  • Урок 368. 00:08:17
    Styling Part 2
  • Урок 369. 00:06:11
    Introduction to Database Triggers
  • Урок 370. 00:07:28
    Writing Our First Trigger Part 1
  • Урок 371. 00:11:37
    Writing Our First Trigger Part 2
  • Урок 372. 00:08:17
    Preventing Instagram Self-Follows With Triggers
  • Урок 373. 00:10:18
    Creating Logger Triggers
  • Урок 374. 00:06:13
    Managing Triggers And A Warning