Watch REST API to SQL (with Python) | Full Data Project | #python #sql #dataengineering #datascience Video Tutorial

💻 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=stephen-david-williams (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 - https://www.tiktok.com/@sdw.online - Instagram - https://instagram.com/sdw.online - LinkedIn - https://www.linkedin.com/in/stephen-david-williams-860428123/ - Facebook - https://www.facebook.com/profile.php?id=61563980937900 - GitHub - https://github.com/sdw-online - Twitter/X - https://twitter.com/sdw_online --- 🎁 Free Resources: - Tableau Visual Vocabulary - https://www.tableau.com/en-gb/solutions/gallery/visual-vocabulary Here are some of the free resources I’ve created that you may find useful for your own data projects: - My articles/ blogs - https://medium.com/@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/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 - Power BI - https://powerbi.microsoft.com/en-us/downloads/ --- 🎶 Music used: Morning Routine by Ghostrifter Official | https://soundcloud.com/ghostrifter-official Music promoted by https://www.chosic.com/free-music/all/ Creative Commons CC BY-SA 3.0 https://creativecommons.org/licenses/by-sa/3.0 --- ⏲️ 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)