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