1. Урок 1.00:03:09
    This Course Was Just Updated!
  2. Урок 2.00:01:09
    Course Intro
  3. Урок 3.00:01:26
    About Me
  4. Урок 4.00:01:41
    Getting The Course Code
  5. Урок 5.00:08:24
    First 5 Minutes of SQL
  6. Урок 6.00:01:03
    Section Introduction
  7. Урок 7.00:07:17
    What Is A Database?
  8. Урок 8.00:05:51
    SQL vs. MySQL
  9. Урок 9.00:05:18
    Installation: START HERE!
  10. Урок 10.00:09:14
    Installation: Windows Instructions
  11. Урок 11.00:11:35
    Installation: Mac Instructions
  12. Урок 12.00:01:10
    Section Introduction
  13. Урок 13.00:04:16
    Showing Databases
  14. Урок 14.00:04:56
    Creating Databases
  15. Урок 15.00:05:33
    Dropping and Using Databases
  16. Урок 16.00:05:19
    Introducing Tables
  17. Урок 17.00:07:39
    Data Types: The Basics
  18. Урок 18.00:02:36
    Basic Datatypes Challenge
  19. Урок 19.00:04:58
    Creating Tables
  20. Урок 20.00:04:34
    How Do We Know It Worked?
  21. Урок 21.00:02:11
    Dropping Tables
  22. Урок 22.00:02:37
    Tables Basics Activity
  23. Урок 23.00:03:13
    MySQL Comments
  24. Урок 24.00:01:41
    Section Introduction
  25. Урок 25.00:03:45
    INSERT: The Basics
  26. Урок 26.00:01:45
    A Quick Preview of SELECT
  27. Урок 27.00:04:49
    Multi-inserts
  28. Урок 28.00:05:28
    INSERT Exercise
  29. Урок 29.00:05:41
    Working With NOT NULL
  30. Урок 30.00:04:14
    Sidenote: Quotes In MySQL
  31. Урок 31.00:06:32
    Adding DEFAULT Values
  32. Урок 32.00:04:58
    Introducing Primary Keys
  33. Урок 33.00:07:14
    Working With AUTO_INCREMENT
  34. Урок 34.00:07:20
    Create Table/ Insert Exercise
  35. Урок 35.00:01:31
    Section Introduction
  36. Урок 36.00:01:52
    Introducing CRUD
  37. Урок 37.00:01:51
    Getting Our New "Dataset"
  38. Урок 38.00:03:14
    Officially Introducing SELECT
  39. Урок 39.00:03:33
    The WHERE clause
  40. Урок 40.00:01:26
    Rapid Fire Exercises
  41. Урок 41.00:02:56
    Rapid Fire Exercises SOLUTION
  42. Урок 42.00:02:14
    Aliases
  43. Урок 43.00:05:25
    Using UPDATE
  44. Урок 44.00:01:45
    A Quick Rule Of Thumb
  45. Урок 45.00:01:05
    UPDATE Exercise
  46. Урок 46.00:03:03
    UPDATE Exercise SOLUTION
  47. Урок 47.00:02:38
    Introducing DELETE
  48. Урок 48.00:00:59
    DELETE Exercise
  49. Урок 49.00:02:16
    DELETE Exercise SOLUTION
  50. Урок 50.00:01:53
    Section Introduction
  51. Урок 51.00:05:12
    Introducing the CRUD Challenge
  52. Урок 52.00:08:09
    CRUD Challenge Solution: Creating
  53. Урок 53.00:01:43
    CRUD Challenge Solution: Reading
  54. Урок 54.00:03:25
    CRUD Challenge Solution: Updating
  55. Урок 55.00:02:51
    CRUD Challenge Solution: Deleting
  56. Урок 56.00:02:05
    Section Introduction
  57. Урок 57.00:01:53
    The World Of String Functions
  58. Урок 58.00:05:26
    Loading Our Books Data
  59. Урок 59.00:08:51
    CONCAT
  60. Урок 60.00:07:32
    SUBSTRING
  61. Урок 61.00:06:50
    Combining String Functions
  62. Урок 62.00:04:27
    Sidenote: SQL Formatting
  63. Урок 63.00:05:44
    REPLACE
  64. Урок 64.00:03:31
    REVERSE
  65. Урок 65.00:02:51
    CHAR_LENGTH
  66. Урок 66.00:03:49
    UPPER & LOWER
  67. Урок 67.00:06:22
    Other String Functions
  68. Урок 68.00:03:44
    String Functions Exercise
  69. Урок 69.00:11:33
    String Functions Exerise SOLUTION
  70. Урок 70.00:00:36
    Section Introduction
  71. Урок 71.00:01:27
    Adding Some New Books
  72. Урок 72.00:06:13
    DISTINCT
  73. Урок 73.00:06:38
    ORDER BY
  74. Урок 74.00:06:20
    More On ORDER BY
  75. Урок 75.00:05:40
    LIMIT
  76. Урок 76.00:07:15
    LIKE
  77. Урок 77.00:02:04
    Escaping Wildcards
  78. Урок 78.00:03:06
    Refining Selections Exercise
  79. Урок 79.00:14:41
    Refining Selections Exercise SOLUTION
  80. Урок 80.00:03:57
    Section Introduction
  81. Урок 81.00:07:34
    Count Basics
  82. Урок 82.00:10:12
    GROUP BY
  83. Урок 83.00:03:46
    MIN and MAX Basics
  84. Урок 84.00:06:27
    Subqueries
  85. Урок 85.00:04:48
    Grouping By Multiple Columns
  86. Урок 86.00:05:51
    MIN and MAX With GROUP BY
  87. Урок 87.00:03:46
    SUM
  88. Урок 88.00:02:24
    AVG
  89. Урок 89.00:01:18
    Aggregate Functions Docs
  90. Урок 90.00:02:52
    Agg Functions Exercise
  91. Урок 91.00:12:36
    Agg Functions Exercise SOLUTION
  92. Урок 92.00:01:57
    Section Introduction
  93. Урок 93.00:02:53
    Surveying Other Data Types
  94. Урок 94.00:12:07
    CHAR vs. VARCHAR
  95. Урок 95.00:05:03
    INT, TINYINT, BIGINT, etc.
  96. Урок 96.00:06:56
    DECIMAL
  97. Урок 97.00:05:32
    FLOAT & DOUBLE
  98. Урок 98.00:04:38
    DATE and TIME
  99. Урок 99.00:07:40
    Working With Dates
  100. Урок 100.00:04:16
    CURDATE, CURTIME, & NOW
  101. Урок 101.00:06:04
    Date Functions
  102. Урок 102.00:02:04
    Time Functions
  103. Урок 103.00:09:14
    Formatting Dates
  104. Урок 104.00:10:43
    Date Math
  105. Урок 105.00:03:29
    TIMESTAMPS
  106. Урок 106.00:06:59
    DEFAULT & ON UPDATE TIMESTAMPS
  107. Урок 107.00:03:37
    Data Types Exercise
  108. Урок 108.00:13:17
    Data Types Exercise SOLUTION
  109. Урок 109.00:02:45
    Section Introduction
  110. Урок 110.00:02:57
    Not Equal
  111. Урок 111.00:03:22
    NOT LIKE
  112. Урок 112.00:03:57
    Greater Than
  113. Урок 113.00:02:58
    Less Than Or Equal To
  114. Урок 114.00:08:54
    Logical AND
  115. Урок 115.00:05:39
    Logical OR
  116. Урок 116.00:04:48
    Between
  117. Урок 117.00:08:16
    Comparing Dates
  118. Урок 118.00:08:30
    The IN Operator
  119. Урок 119.00:08:48
    CASE
  120. Урок 120.00:02:04
    IS NULL
  121. Урок 121.00:03:26
    Exercise
  122. Урок 122.00:15:23
    Exercise SOLUTION
  123. Урок 123.00:03:45
    UNIQUE Constraint
  124. Урок 124.00:05:00
    CHECK Constraints
  125. Урок 125.00:04:14
    Named Constraints
  126. Урок 126.00:05:21
    Multiple Column Constraints
  127. Урок 127.00:05:39
    ALTER TABLE: Adding Columns
  128. Урок 128.00:01:55
    ALTER TABLE: Dropping Columns
  129. Урок 129.00:03:44
    ALTER TABLE: Renaming
  130. Урок 130.00:03:56
    ALTER TABLE: Modifying Columns
  131. Урок 131.00:04:13
    ALTER TABLE: Constraints
  132. Урок 132.00:01:58
    Section Introduction
  133. Урок 133.00:10:29
    Data is Messy
  134. Урок 134.00:04:38
    Relationships Basics
  135. Урок 135.00:12:34
    One to Many Relationship
  136. Урок 136.00:11:08
    Working with FOREIGN KEY
  137. Урок 137.00:08:00
    Cross Joins
  138. Урок 138.00:08:53
    Inner Joins
  139. Урок 139.00:04:54
    Inner Joins With Group By
  140. Урок 140.00:07:06
    Left Join
  141. Урок 141.00:03:36
    Left Join With Group By
  142. Урок 142.00:04:29
    Right Join
  143. Урок 143.00:05:37
    On Delete Cascade
  144. Урок 144.00:03:02
    Joins Exercise
  145. Урок 145.00:10:43
    Joins Exercise SOLUTION
  146. Урок 146.00:01:55
    Section Introduction
  147. Урок 147.00:10:49
    Many to Many Basics
  148. Урок 148.00:06:44
    Creating Our Many To Many Tables
  149. Урок 149.00:03:36
    TV Series Challenge #1
  150. Урок 150.00:03:25
    TV Series Challenge #2
  151. Урок 151.00:03:39
    TV Series Challenge #3
  152. Урок 152.00:03:35
    TV Series Challenge #4
  153. Урок 153.00:02:26
    TV Series Challenge #5
  154. Урок 154.00:09:11
    TV Series Challenge #6
  155. Урок 155.00:05:28
    TV Series Challenge #7
  156. Урок 156.00:06:32
    Introducing Views
  157. Урок 157.00:05:43
    Updateable Views
  158. Урок 158.00:03:27
    Replacing/Altering Views
  159. Урок 159.00:04:29
    HAVING clause
  160. Урок 160.00:08:19
    WITH ROLLUP
  161. Урок 161.00:05:52
    SQL Modes Basics
  162. Урок 162.00:04:26
    STRICT_TRANS_TABLES
  163. Урок 163.00:09:50
    More Modes
  164. Урок 164.00:06:29
    Introducing Window Functions
  165. Урок 165.00:08:16
    Using OVER()
  166. Урок 166.00:06:54
    PARTITION BY
  167. Урок 167.00:06:42
    ORDER BY with Windows
  168. Урок 168.00:05:54
    RANK()
  169. Урок 169.00:05:15
    DENSE_RANK, & ROW_NUMBER()
  170. Урок 170.00:03:37
    NTILE()
  171. Урок 171.00:04:06
    FIRST_VALUE
  172. Урок 172.00:05:52
    LEAD and LAG
  173. Урок 173.00:01:20
    Section Introduction
  174. Урок 174.00:01:53
    IMPORTANT NOTE ABOUT THIS SECTION!
  175. Урок 175.00:08:32
    Introducing Instagram Clone
  176. Урок 176.00:06:09
    Users Schema
  177. Урок 177.00:06:38
    Photos Schema
  178. Урок 178.00:06:40
    Comments Schema
  179. Урок 179.00:07:42
    Likes Schema
  180. Урок 180.00:07:21
    Followers Schema
  181. Урок 181.00:10:35
    3 Approaches for Hashtags
  182. Урок 182.00:05:27
    Implementing Hashtags Table
  183. Урок 183.00:01:43
    Section Introduction
  184. Урок 184.00:08:31
    Getting Lots of Instagram Data
  185. Урок 185.00:04:54
    Instagram Challenge #1
  186. Урок 186.00:06:42
    Instagram Challenge #2
  187. Урок 187.00:07:23
    Instagram Challenge #3
  188. Урок 188.00:07:06
    Instagram Challenge #4
  189. Урок 189.00:03:14
    Instagram Challenge #5
  190. Урок 190.00:05:30
    Instagram Challenge #6
  191. Урок 191.00:05:16
    Instagram Challenge #7
  192. Урок 192.00:01:09
    Course Introduction
  193. Урок 193.00:01:26
    Instructor Introduction(s)
  194. Урок 194.00:04:19
    Syllabus Walkthrough and Prerequisites
  195. Урок 195.00:06:14
    Your First 5 Minutes of SQL - Let's Get Coding!
  196. Урок 196.00:03:45
    How The Course Works
  197. Урок 197.00:01:03
    Section Introduction
  198. Урок 198.00:07:17
    What Is a Database?
  199. Урок 199.00:05:51
    SQL Vs. MySQL
  200. Урок 200.00:05:11
    Installation Overview - WATCH BEFORE INSTALLING
  201. Урок 201.00:03:17
    Now using GoormIDE instead of Cloud9
  202. Урок 202.00:11:42
    Mac Installation
  203. Урок 203.00:03:33
    Windows Installation
  204. Урок 204.00:01:10
    Section 3 Introduction
  205. Урок 205.00:05:21
    Creating Databases
  206. Урок 206.00:01:47
    Dropping Databases
  207. Урок 207.00:03:01
    Using Databases
  208. Урок 208.00:05:10
    Introduction to Tables
  209. Урок 209.00:07:53
    The Basic Datatypes
  210. Урок 210.00:02:36
    Basic Datatypes Challenge
  211. Урок 211.00:00:00
    Creating Your Own Tables
  212. Урок 212.00:02:34
    How Do We Know It Worked?
  213. Урок 213.00:01:37
    Dropping Tables
  214. Урок 214.00:04:30
    Creating Your Own Tables Challenge
  215. Урок 215.00:01:41
    Section 4 Introduction
  216. Урок 216.00:05:04
    Inserting Data
  217. Урок 217.00:02:09
    Super Quick Intro To SELECT
  218. Урок 218.00:03:01
    Multiple INSERT
  219. Урок 219.00:01:36
    INSERT Challenges
  220. Урок 220.00:04:44
    INSERT Challenges Solution
  221. Урок 221.00:05:36
    MySQL Warnings
  222. Урок 222.00:06:55
    NULL and NOT_NULL
  223. Урок 223.00:07:18
    Setting Default Values
  224. Урок 224.00:12:22
    A Primer On Primary Keys
  225. Урок 225.00:01:52
    Table Constraints Exercise
  226. Урок 226.00:03:35
    Table Constraints Exercise Solution
  227. Урок 227.00:01:31
    Section 5 Introduction
  228. Урок 228.00:01:45
    Introduction to CRUD
  229. Урок 229.00:02:30
    Preparing Our Data
  230. Урок 230.00:04:19
    Official Introduction to SELECT
  231. Урок 231.00:05:06
    Introduction to WHERE
  232. Урок 232.00:02:01
    SELECT Challenges
  233. Урок 233.00:02:46
    SELECT Challenges Solution
  234. Урок 234.00:02:56
    Introduction to Aliases
  235. Урок 235.00:03:59
    The UPDATE Command
  236. Урок 236.00:00:38
    UPDATE Challenges
  237. Урок 237.00:03:59
    UPDATE Challenges Solution
  238. Урок 238.00:04:42
    Introduction to DELETE
  239. Урок 239.00:01:12
    DELETE Challenges
  240. Урок 240.00:02:46
    DELETE Challenges Solution
  241. Урок 241.00:01:53
    Section 6 Introduction
  242. Урок 242.00:07:27
    CRUD Exercise Overview
  243. Урок 243.00:05:56
    CRUD Exercise Create Solution
  244. Урок 244.00:01:49
    CRUD Exercise Read Solution
  245. Урок 245.00:04:11
    CRUD Exercise Update Solution
  246. Урок 246.00:03:22
    CRUD Exercise Delete Solution
  247. Урок 247.00:02:05
    Section 7 Introduction
  248. Урок 248.00:10:16
    Running SQL Files
  249. Урок 249.00:05:26
    Loading Our Book Data
  250. Урок 250.00:11:08
    Working with CONCAT
  251. Урок 251.00:10:05
    Introducing SUBSTRING
  252. Урок 252.00:06:40
    Introducing REPLACE
  253. Урок 253.00:03:40
    Using REVERSE
  254. Урок 254.00:04:55
    Working with CHAR LENGTH
  255. Урок 255.00:03:21
    Changing Case with UPPER and LOWER
  256. Урок 256.00:04:43
    String Function Challenges
  257. Урок 257.00:13:09
    String Function Challenges Solution
  258. Урок 258.00:00:36
    Section 8 Introduction
  259. Урок 259.00:02:48
    Seed Data: Adding A Couple New Books
  260. Урок 260.00:08:25
    Using DISTINCT
  261. Урок 261.00:11:20
    Sorting Data with ORDER BY
  262. Урок 262.00:09:04
    Using LIMIT
  263. Урок 263.00:07:43
    Better Searches with LIKE
  264. Урок 264.00:06:10
    LIKE Part 2: More Wildcards
  265. Урок 265.00:04:53
    Refining Selections Exercises
  266. Урок 266.00:12:30
    Refining Selections Exercises Solution
  267. Урок 267.00:03:57
    Section 9 Introduction
  268. Урок 268.00:08:39
    The Count Function
  269. Урок 269.00:12:23
    The Joys of Group By
  270. Урок 270.00:04:20
    Note about SQL Mode only_full_group_by
  271. Урок 271.00:04:13
    Min and Max Basics
  272. Урок 272.00:07:16
    SUBQUERIES - A Problem with Min and Max
  273. Урок 273.00:06:40
    Using Min and Max with Group By
  274. Урок 274.00:04:28
    The Sum Function
  275. Урок 275.00:06:01
    The Avg Function
  276. Урок 276.00:04:28
    Aggregate Functions Challenges
  277. Урок 277.00:09:11
    Aggregate Functions Challenges Solution
  278. Урок 278.00:01:57
    Section 10 Introduction
  279. Урок 279.00:14:30
    CHAR and VARCHAR
  280. Урок 280.00:06:09
    DECIMAL
  281. Урок 281.00:07:45
    FLOAT and DOUBLE
  282. Урок 282.00:04:32
    DATE, TIME, and DATETIME
  283. Урок 283.00:05:50
    Creating Our DATE data
  284. Урок 284.00:05:16
    CURDATE, CURTIME, and NOW
  285. Урок 285.00:14:30
    Formatting Dates
  286. Урок 286.00:09:41
    Date Math
  287. Урок 287.00:10:55
    Working with TIMESTAMPS
  288. Урок 288.00:04:51
    Data Types Exercises
  289. Урок 289.00:13:59
    Data Types Exercises Solution
  290. Урок 290.00:02:45
    Section 11 Introduction
  291. Урок 291.00:04:27
    Not Equal
  292. Урок 292.00:02:35
    Not Like
  293. Урок 293.00:10:05
    Greater Than
  294. Урок 294.00:03:49
    Less Than
  295. Урок 295.00:09:48
    Logical AND
  296. Урок 296.00:06:42
    Logical OR
  297. Урок 297.00:10:58
    Between
  298. Урок 298.00:11:48
    In And Not In
  299. Урок 299.00:11:22
    Case Statements
  300. Урок 300.00:06:46
    Logical Operators Exercises
  301. Урок 301.00:17:48
    Logical Operators Exercises Solution
  302. Урок 302.00:01:58
    Section 12 Introduction
  303. Урок 303.00:10:29
    Real World Data Is Messy
  304. Урок 304.00:04:38
    Types of Data Relationships
  305. Урок 305.00:12:34
    One To Many: The Basics
  306. Урок 306.00:12:05
    Working With Foreign Keys
  307. Урок 307.00:07:37
    Cross Join
  308. Урок 308.00:12:46
    Inner Join
  309. Урок 309.00:15:18
    Left Join
  310. Урок 310.00:10:37
    Right Joins Pt 1
  311. Урок 311.00:09:52
    Right Joins Pt 2
  312. Урок 312.00:03:10
    Right and Left Joins: A Common Question
  313. Урок 313.00:06:59
    Our First Joins Exercise
  314. Урок 314.00:09:11
    Our First Joins Exercise SOLUTION
  315. Урок 315.00:09:22
    Our First Joins Exercise SOLUTION PT. 2
  316. Урок 316.00:01:55
    Section 13 Introduction
  317. Урок 317.00:10:49
    Many To Many Basics
  318. Урок 318.00:10:58
    Creating Our Tables
  319. Урок 319.00:04:50
    TV Joins Challenge 1
  320. Урок 320.00:06:23
    TV Joins Challenge 2
  321. Урок 321.00:05:00
    TV Joins Challenge 3
  322. Урок 322.00:06:00
    TV Joins Challenge 4
  323. Урок 323.00:04:57
    TV Joins Challenge 5
  324. Урок 324.00:11:58
    TV Joins Challenge 6
  325. Урок 325.00:07:10
    TV Joins Challenge 7
  326. Урок 326.00:01:20
    Section 14 Introduction
  327. Урок 327.00:08:32
    Introduction To Instagram Clone Schema
  328. Урок 328.00:06:09
    Cloning Instagram's DB: Users Schema
  329. Урок 329.00:06:38
    Cloning Instagram's DB: Photos Schema
  330. Урок 330.00:06:40
    Cloning Instagram's DB: Comments Schema
  331. Урок 331.00:07:42
    Cloning Instagram's DB: Likes Schema
  332. Урок 332.00:07:21
    Cloning Instagram's DB: Followers Schema
  333. Урок 333.00:10:35
    Cloning Instagram's DB: Hashtags Part 1
  334. Урок 334.00:05:27
    Cloning Instagram's DB: Hashtags Part 2
  335. Урок 335.00:01:43
    Section 15 Introduction
  336. Урок 336.00:08:31
    Loading The JUMBO dataset
  337. Урок 337.00:04:54
    Instagram Clone Challenge 1
  338. Урок 338.00:06:42
    Instagram Clone Challenge 2
  339. Урок 339.00:07:23
    Instagram Clone Challenge 3
  340. Урок 340.00:07:06
    Instagram Clone Challenge 4
  341. Урок 341.00:03:14
    Instagram Clone Challenge 5
  342. Урок 342.00:05:30
    Instagram Clone Challenge 6
  343. Урок 343.00:05:16
    Instagram Clone Challenge 7
  344. Урок 344.00:01:37
    Section 16 Introduction
  345. Урок 345.00:09:00
    MySQL and Other Languages
  346. Урок 346.00:07:35
    BUT WHAT ABOUT PHP
  347. Урок 347.00:08:01
    Introduction to JOIN US app
  348. Урок 348.00:06:13
    5 Minute NodeJS Crash Course
  349. Урок 349.00:09:12
    Introduction to NPM and Faker
  350. Урок 350.00:04:54
    Introducing the MySQL Package
  351. Урок 351.00:12:47
    Connecting Node to MySQL
  352. Урок 352.00:06:55
    Creating Our Users Table
  353. Урок 353.00:06:16
    Selecting Using Node
  354. Урок 354.00:11:32
    Inserting Using Node
  355. Урок 355.00:07:42
    Some MySQL/Node Magic
  356. Урок 356.00:08:41
    Bulk Inserting 500 Users - Finally!
  357. Урок 357.00:02:31
    500 Users Exercises
  358. Урок 358.00:11:56
    500 Users Exercises Solutions
  359. Урок 359.00:01:53
    Section 17 Introduction
  360. Урок 360.00:05:41
    Introducing Express
  361. Урок 361.00:06:39
    NPM Init and package.json files
  362. Урок 362.00:16:34
    Our First Simple Web App
  363. Урок 363.00:09:57
    Adding Multiple Routes
  364. Урок 364.00:11:09
    Connecting Express and MySQL
  365. Урок 365.00:16:03
    Adding EJS Templates
  366. Урок 366.00:18:33
    Connecting The Form
  367. Урок 367.00:08:25
    Styling Part 1
  368. Урок 368.00:08:17
    Styling Part 2
  369. Урок 369.00:06:11
    Introduction to Database Triggers
  370. Урок 370.00:07:28
    Writing Our First Trigger Part 1
  371. Урок 371.00:11:37
    Writing Our First Trigger Part 2
  372. Урок 372.00:08:17
    Preventing Instagram Self-Follows With Triggers
  373. Урок 373.00:10:18
    Creating Logger Triggers
  374. Урок 374.00:06:13
    Managing Triggers And A Warning