SQL Database Tutorials for Beginners: 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
On this page of the site you can watch the video online SQL Database Tutorials for Beginners: SELECT, JOINS, GROUP BY, INSERT, UPDATE, WHERE with a duration of hours minute second in good quality, which was uploaded by the user Ulbi TV 17 December 2020, share the link with friends and acquaintances, this video has already been watched 508,347 times on youtube and it was liked by 23 thousand viewers. Enjoy your viewing!
