SQL Tutorial - All 38 Concepts You Need To Know скачать в хорошем качестве

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/professi... 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: [email protected] 👉 NEW React & Next.js Course: https://bytegrad.com/courses/professi... 👉 Professional JavaScript Course: https://bytegrad.com/courses/professi... 👉 Professional CSS Course: https://bytegrad.com/courses/professi... 👉 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)