How to Manage a Database with Python, Pandas & SQL - UPDATE a DB professionally [DO NOT SKIP THIS!]

Опубликовано: 13 Ноябрь 2022
на канале: Algovibes

12,324

443

In this video I will go over updating a Database (taking both stock price data and cryptocurrency intraday data) with Python, Pandas and SQL.
I got some requests going over that again in coherence with my stock recommendation series.
After this video you will be able to efficiently update a SQL Database and leverage that to store and analyze big datasets.

Get the Notebook/Source code by becoming a Tier-3 Channel member or get other perks like Discord to exchange with like minded people here:
   / algovibes

Useful PREREQUISITES:
Video on the python Binance lib:
   • Introduction To Automated Trading Wit...

Python & SQL playlist:
   • Python & SQL

sqlalchemy for other DBMS:
https://docs.sqlalchemy.org/en/14/cor...

Disclaimer: This video is not an investment advice and is for informational and educational purposes only.

00:00 - 01:01 What will be covered and why?
01:01 - 03:12 Data / Creating table / Requesting data
03:12 - 05:00 New data: Why you CAN'T just use pandas
05:00 - 06:40 What you SHOULD do instead!
06:40 - 09:46 Making it scalable (must watch)
09:46 - 13:28 Making it REALLY scalable! (must watch)
13:28 - 17:11 Making it REALLY REALLY scalable! (must watch)
17:11 - 23:44 Leveraging to Intraday Crypto Data

#SQL #Python #pandas