REST API to SQL (with Python) | Full Data Project |
💻 Build an ETL pipeline that fetches data from a REST API and loads it into a SQL database (MySQL) using Python.
Follow along at your own pace - feel free to drop any questions or feedback you have in the comments below.
---
📩 Join the waitlist for my private data community here (opening soon!):
https://data100.carrd.co/
---
Become a data analyst using
Analyst Builder - https://www.analystbuilder.com/?via=s...
(Note - I earn a commission when you purchase any qualifying items via these links.
This does *not* cost you anything, but helps in creating more content!)
---
📲 Socials:
TikTok - / sdw.online
Instagram - / sdw.online
LinkedIn - / stephen-david-williams-860428123
Facebook - https://www.facebook.com/profile.php?...
GitHub - https://github.com/sdw-online
Twitter/X - / sdw_online
---
🎁 Free Resources:
Tableau Visual Vocabulary - https://www.tableau.com/en-gb/solutio...
Here are some of the free resources I’ve created that you may find useful for your own data projects:
My articles/ blogs - / sdw-online
How I broke into data - https://datapro.carrd.co/
---
📩 Installation links:
Download these resources mentioned in the project:
SSMS - https://learn.microsoft.com/en-us/sql...
Power BI - https://powerbi.microsoft.com/en-us/d...
---
🎶 Music used:
Morning Routine by Ghostrifter Official | / ghostrifter-official
Music promoted by https://www.chosic.com/free-music/all/
Creative Commons CC BY-SA 3.0
https://creativecommons.org/licenses/...
---
⏲️ Timestamps:
Intro (00:00:00)
ETL pipeline architecture (00:00:08)
Scope the project (00:00:37)
Build mock-up in Excel (00:08:35)
Outline the steps (00:12:29)
API Football overview (RapidAPI) (00:18:10)
Read API docs (00:19:40)
Create GitHub repo (00:22:14)
Create files (00:25:25)
Load libraries into Jupyter notebook (00:27:10)
Grab API credentials (00:29:10)
Send GET request to API (00:36:37)
Explore API response (00:38:18)
Set up rows + cols for dataframe (00:44:54)
Loop through each PL team (00:45:37)
Build dataframe with Pandas (00:52:18)
Grab MySQL credentials (00:53:22)
Connect to server with Python (00:54:42)
Create user in MySQL (00:56:31)
Create database + table in MySQL (00:58:42)
Retry server connection to MySQL (01:02:46)
Connect to database with Python (01:03:49)
Upsert data into PL table (01:09:04)
Check results (01:18:37)
Outro (01:21:15)
Sur cette page du site, vous pouvez voir la vidéo en ligne REST API to SQL (with Python) | Full Data Project | durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Stephen | Data 30 août 2025, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 7,891 fois et il a aimé 285 téléspectateurs. Bon visionnage!
