Completed
00:00 Why SQL is so valuable
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL Tutorial - All 38 Concepts You Need To Know
Automatically move to the next video in the Classroom when playback concludes
- 1 00:00 Why SQL is so valuable
- 2 01:23 4 Common Databases "DBMS"
- 3 01:41 Create database & use
- 4 01:51 Tables
- 5 02:26 Normalized vs Denormalized
- 6 02:39 Singular vs Plural table names
- 7 03:23 Data types
- 8 04:12 DataCamp
- 9 05:05 Constraints
- 10 06:38 Relationship with Foreign Key one-to-one, one-to-many, many-to-many
- 11 08:07 INSERT data seeding database
- 12 10:35 Relationship visualizer
- 13 11:07 SELECT
- 14 12:24 Select Columns
- 15 12:55 Alias
- 16 13:09 WHERE filter
- 17 13:47 BETWEEN
- 18 14:01 LIKE %
- 19 14:28 IN / NOT IN
- 20 14:40 AND / OR
- 21 15:23 EQUAL / NOT EQUAL
- 22 15:34 Dynamic date past week
- 23 16:25 ORDER BY ASC / DESC
- 24 16:43 LIMIT
- 25 16:52 COUNT
- 26 17:11 SUM
- 27 17:21 AVG
- 28 17:29 CASE if-else logic
- 29 18:02 JOIN
- 30 20:08 TRIM / LTRIM / RTRIM
- 31 20:40 SUBSTRING
- 32 20:59 LENGTH
- 33 21:16 UPDATE
- 34 21:47 DELETE
- 35 22:00 CRUD Create / Read / Update / Delete
- 36 22:12 DROP TABLE careful!
- 37 22:22 Transactions
- 38 24:05 INDEX
- 39 25:40 When to use index?
- 40 26:06 BI-tools
- 41 26:47 Migrations
- 42 27:50 ORM SqlAlchemy
