SQL Tutorial - All 38 Concepts You Need To Know

👉 Everything you need to know about SQL - Datacamp's SQL Fundamentals Course (sponsored): https://datacamp.pxf.io/vP2513 (ByteGrad gets commission)
👉 Get certified as an SQL Practitioner (sponsored): https://datacamp.pxf.io/bO7AW6 (ByteGrad gets commission)
👉 NEW React & Next.js Course: https://bytegrad.com/courses/professional-react-nextjs

Hi, I'm Wesley. I'm a brand ambassador for Kinde (paid sponsorship).
👉 Check out Kinde for auth and more https://bit.ly/3QOe1Bh
👉 Work with me: support@bytegrad.com

👉 NEW React & Next.js Course: https://bytegrad.com/courses/professional-react-nextjs
👉 Professional JavaScript Course: https://bytegrad.com/courses/professional-javascript
👉 Professional CSS Course: https://bytegrad.com/courses/professional-css

👉 Web development roadmap 2024 & 2025: https://email.bytegrad.com
👉 Email newsletter (BIG update soon): https://email.bytegrad.com
👉 Discord: all my courses have a private Discord

⏱️ Timestamps:
00:00 Why SQL is so valuable
01:23 4 Common Databases ("DBMS")
01:41 Create database & use
01:51 Tables
02:26 Normalized vs Denormalized
02:39 Singular vs Plural table names
03:23 Data types
04:12 DataCamp
05:05 Constraints
06:38 Relationship with Foreign Key (one-to-one, one-to-many, many-to-many)
08:07 INSERT data (seeding database)
10:35 Relationship visualizer
11:07 SELECT
12:24 Select Columns
12:55 Alias
13:09 WHERE filter
13:47 BETWEEN
14:01 LIKE (%)
14:28 IN / NOT IN
14:40 AND / OR
15:23 EQUAL / NOT EQUAL
15:34 Dynamic date (past week)
16:25 ORDER BY (ASC / DESC)
16:43 LIMIT
16:52 COUNT()
17:11 SUM()
17:21 AVG()
17:29 CASE (if-else logic)
18:02 JOIN
20:08 TRIM() / LTRIM() / RTRIM()
20:40 SUBSTRING()
20:59 LENGTH()
21:16 UPDATE
21:47 DELETE
22:00 CRUD (Create / Read / Update / Delete)
22:12 DROP TABLE (careful!)
22:22 Transactions
24:05 INDEX
25:40 When to use index?
26:06 BI-tools
26:47 Migrations
27:50 ORM (SqlAlchemy)

#webdevelopment #reactjs #nextjs

Note that my videos may contain mistakes. Always verify yourself that your code is safe and does what you want it to do for your specific situation. You agree by watching the videos that you are solely responsible for any mistakes in your code.

This channel and all its content is owned & operated by ByteGrad Sp. z o.o. with Tax ID: PL6762676561 and KRS-number: 0001125554 .
.
TOP resource to LEARN AI for Developers - https://datacamp.pxf.io/RGyxrR (paid sponsorship & ByteGrad Sp. z o.o. gets commission)