SQL Databases with Pandas and Python - A Complete Guide

Published: 13 June 2023
on channel: Rob Mulla

223,012

5.9k

In this Python tuturial we talk all about connecting to SQL Databases with Python and Pandas. Python is the swiss army knife of data anaylsis, and relational databases are the most common way data is stored at small and large companies. Learning how to best connect the two is an essential skill for any data professional.

Timeline:
00:00 Intro
01:02 Setting up A Toy Database with Docker
02:35 DBMS to Pull Data
04:55 Querying Data via Python API
08:35 Querying with Pandas read_sql
11:24 Writing data with Pandas to_sql

Check out my other videos:
Data Pipelines: Polars vs PySpark vs Pandas:    • The BEST library for building Data Pipelin...
Polars for Data Science:    • Polars: The Next Big Python Data Science L...
Speed up Pandas Dataframes:    • This INCREDIBLE trick will speed up your d...
Avoid These Pandas Mistakes:    • 25 Nooby Pandas Coding Mistakes You Should...

Links to my stuff:
Youtube: https://youtube.com/@robmulla?sub_con...
Discord:   / discord
Twitch:   / medallionstallion_
Twitter:   / rob_mulla
Kaggle: https://www.kaggle.com/robikscube

On this page of the site you can watch the video online SQL Databases with Pandas and Python - A Complete Guide with a duration of hours minute second in good quality, which was uploaded by the user Rob Mulla 13 June 2023, share the link with friends and acquaintances, this video has already been watched 223,012 times on youtube and it was liked by 5.9 thousand viewers. Enjoy your viewing!

1,572