SQL Tutorial [MySQL] for BEGINNERS in under ONE hour

Hi everyone, as I was using SQL in many of my Python videos as a way of storing and working with data I thought it would be nice to have a Full Beginner tutorial on SQL syntax, querying but also setting up a DataBase properly. Installation guide: Videos on Python & SQL ----------------------------------------- Backtesting a large amount of stocks: Set up a Finance Database using Python & SQL: Trading Strategy using Python & SQL: Build a whole Stock recommendation system using Python & MySQL: Also I am leveraging SQL in my Cryptocurrency Tradingbots, check out the videos here: Let me know if you need anything else! 00:00 - 01:54 Intro / Why SQL / Prerequisites 01:54 - 02:28 MySQL Workbench Orientation 02:28 - 04:22 Language properties / Create Database or Schema 04:22 - 07:00 Create Table 07:00 - 08:14 First query: SELECT 08:14 - 09:58 Insert Data 09:58 - 10:33 Pulling single columns 10:33 - 12:52 Inserting multiple rows 12:52 - 14:25 Filtering data / WHERE 14:25 - 16:40 UPDATE/(correct) values 16:40 - 17:59 DELETE 17:59 - 19:46 Aggregation functions 19:46 - 20:38 GROUP BY 20:38 - 23:08 Creating a second table (to bring two tables together) 23:08 - 24:04 Combining tables (JOINS) 24:04 - 28:52 INNER JOIN (including Aliasing) 28:52 - 30:05 LEFT JOIN 30:05 - 31:34 RIGHT JOIN ( good to understand the JOIN concept) 31:34 - 31:51 MAKING IT PROFESSIONAL 31:51 - 39:29 PRIMARY KEY 🔑 and Database Design 39:39 - 44:14 FOREIGN KEY 🔑 and why they are important 44:14 - 45:52 Intermediate SQL Query Task - Try it yourself! 45:52 - 50:24 Solution: Keys, Joins, Alias, Group by, (Order by) 50:24 - 50:56 UP NEXT #sql #mysql #tutorial #database #datascience #analytics