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:
https://www.simplilearn.com/tutorials...
Videos on Python & SQL
-----------------------------------------
Backtesting a large amount of stocks:
• Backtesting Rayner Teos 1689% Bollinger Ba...
Set up a Finance Database using Python & SQL:
• Create your own Finance DataBase with Pyth...
Trading Strategy using Python & SQL:
• Trading strategy and Backtest with Python ...
Build a whole Stock recommendation system using Python & MySQL:
• Stock recommendation system with Python/SQL
Also I am leveraging SQL in my Cryptocurrency Tradingbots, check out
the videos here:
• Stock recommendation system with Python/SQL
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