How to build a Stock Recommendation System with Python - Part I: Database Setup [MySQL]

Hi and thanks for watching :-) Get the Notebook/Source code by becoming a Tier-2 Channel member: https://www.youtube.com/channel/UC87aeHqMrlR6ED0w2SVi5nw/join This video is the first part of a larger scale stock recommendation system built with Python with the example of three indices (Nifty50, Bovespa and RTSI) which are screened for technical indicators in the upcoming videos. I am covering the MySQL Installation, the Python MySQL connection using pymysql and the population of the Database in this video. In specific we are requesting online stock price data and store this data into the MySQL database. I am keeping it scalable so that you can take even more indices. If you are interested in topics like that please subscribe and like the video. MySQL Download: https://dev.mysql.com/downloads/ First video on building a stock recommender: https://youtu.be/AuZmsv6dQCM Pandas and SQL: https://youtu.be/OjMDXTlVOYU Building a SQL database with SQLite: https://youtu.be/5bUn-D4eL4k Windows Installation: https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html 0:00 - 01:24 Introduction 01:24 - 05:28 MySQL Installation on MacOS (both Server and Workbench) 05:28 - 06:51 Mini Walkthrough MySQL Workbench 06:51 - 07:33 Requirements setup (sqlalchemy and PyMySQL) 07:33 - 11:05 Create schemas 11:05 - 15:55 Getting ticker symbols for the indices (+ amendments) 15:55 - 16:25 Getting stock prices with yahoo finance 16:25 - 21:45 Populating the Database with online stock prices 21:45 - 24:25 Check data in MySQL and outlook for next vid #Python #MySQL #Stockmarket