Базы данных SQL уроки для начинающих. SELECT, JOINS, GROUP BY, INSERT, UPDATE, WHERE

In this video, we'll briefly cover relational database theory and examine the SQL query language using the MySQL database management system as an example. We'll explore the basic language constructs and learn how to create, modify, and retrieve data from tables. Databases for beginners. Database tutorials. SQL tutorials. Basic SQL constructs. My course "Advanced Frontend. In Production with React" - https://ulbitv.ru/frontend Timecodes: 00:00 - Lesson Plan 00:50 - Types of Databases 02:53 - About Relational Databases 03:15 - 1st Normal Form 03:45 - 2nd Normal Form 04:50 - Relationships Between Tables 06:12 - Getting Started with MySQL 06:47 - SHOW DATABASES 07:00 - CREATE DATABASE 07:16 - DROP DATABASE 07:40 - SHOW TABLES 07:55 - CREATE TABLE 08:50 - SHOW COLUMNS 10:10 - INSERT INTO 10:45 - SELECT * 11:15 - SELECT id surname 11:40 - DISTINCT 12:10 - WHERE 12:45 - LIMIT 13:07 - AS 13:30 - ORDER BY 14:04 - ALTER TABLE 14:40 - UPDATE SET 15:30 - LIKE 16:20 - WHERE AND OR 17:25 - BETWEEN 17:45 - DELETE 18:10 - Multiple INSERT 19:10 - Table Joins \ JOINS 20:05 - INNER JOIN 21:00 - LEFT OUTER JOIN 21:15 - RIGHT OUTER JOIN 21:30 - UNION 22:04 - Aggregate Functions 23:10 - GROUP BY You can support me and my channel by following the links below. Qiwi Wallet - http://qiwi.com/n/BODYE821 Yandex Money - https://yoomoney.ru/to/4100116193037469