????‍???? Anyone who wants to study or review the SQL language must come to the clip where we will teach the SQL language from installing the program to understanding all the basic commands, just like studying at university. It is very suitable for anyone who writes databases or already has basic knowledge about databases. But if you don't have a foundation, it's okay. Because we will explain the SQL language simply for you to understand the most ???? . If anyone wants to do the exercises to receive a Certificate, you can attend the course for free, I repeat, FREE, with the Essential SQL for Everyone course today here https://academy.borntodev.com/p/essen... . Section 1 Introduction 00:00 - Introduce the lesson 00:59 - Get to know the database and SQL language 04:56 - Internal database structure 10:57 - Install the program and SQLite Section 2 Zero to One 13:33 - Basic SQL structure and commands 24:20 - Importing a database file 28:27 - Learning the SELECT command 31:49 - SELECT only some columns 36:05 - Using AS to rename Columns 39:53 - Using WHERE conditions to search for data 47:23 - Sort with ORDER BY 50:08 - Limit the amount of data with LIMIT 51:30 - Basic SQL applications Section 3 One to Two 01:00:12 - INSERT data 01:08:40 - UPDATE data 01:13:59 - DELETE data Section 4 Aggregate Functions 01:16:06 - What are Aggregate Functions? 01:17:25 - Using COUNT to count data 01:19:36 - Find the average and sum with AVG and SUM 01:22:48 - Find the maximum and minimum value with MAX and MIN 01:24:51 - Grouping with Group By 01:29:06 - Grouping with Group By (Advance) 01:33:11 - What is the difference between HAVING and WHERE? 01:37:04 - Applying Aggregate Functions Section 5 TROUBLE IS A FRIENDS 01:46:36 - Managing problems in using SQL 01:51:30 - Learn the sequence of commands in SQL Section 6 Applied Zone 01:55:46 - Applications with other programming languages ​​02:01:14 - Examples of using the SQL language with real work Section 7 Basic SQL Operator 02:10:21 - What is a SQL Operator? 02:11:36 - Learn the NOT command 02:16:13 - Learn the IN command 02:21:37 - Learn the LIKE command 02:28:04 - Learn the BETWEEN command 02:31:48 - Learn the IS NULL command 02:34:32 - Using AND and OR 02:37:19 - Applying the SQL Operator Section 8 JOIN ME TO THE DARKSIDE ! 02:43:18 - What is a JOIN? 02:48:57 - Using INNER JOIN 02:57:04 - Using LEFT JOIN 03:00:08 - Using RIGHT JOIN 03:02:46 - Using FULL OUTER JOIN 03:05:33 - Applying JOIN Section 9 MANY MANY CONDITION 03:13:54 - Define processing conditions with CASE 03:22:36 - Using SubQueries 03:26:14 - Writing Comments in SQL Section 10 LAST FOR THIS COURSE BUT FIRST STEP FOR YOUR FUTURE 03:28:18 - Thank you to everyone who has studied until the end. . ▲ Follow our channel at: http://bit.ly/borntoDevSubScribe ▲ Facebook: / borntodev ▲ Website: http://www.borntodev.com . ????BorntoDev Channel is a YouTube channel that focuses on technology and program development. Along with fun and smiles in both lesson and vlog formats. To change the learning model of programming and technology development that is traditionally niche to be more accessible and understandable. By developing a focus on new presentation formats that are friendly to everyone. ▲ Activities in the BorntoDev Channel are part of the operations of BorntoDev Co., Ltd., which is open to partners who are interested in joining in changing Thai society to be a society of science and technology. If you are interested in supporting and moving forward together, you can contact us today. ▲ Contact for advertising, support and collaboration at: [email protected]