Create an account to use AI

Create a free account to unlock all features:

Ask questions about videos with AI
Use smart search (AI)
Save your favorite videos
Bookmark your favorite categories
Organize your favorite subcategories
Access your personalized favorites page
Access your conversation history
Personalize your homepage with your favorites

Create an account

Already have an account? Log in

SQL Databases with Pandas and Python - A Complete Guide

Rob Mulla

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: https://youtube.com/watch?v=mi9f9zOaqM8&feature=shares

Polars for Data Science: https://youtube.com/watch?v=VHqn7ufiilE&feature=shares

Speed up Pandas Dataframes: https://youtube.com/watch?v=u4rsA5ZiTls&feature=shares

Avoid These Pandas Mistakes: https://youtube.com/watch?v=_gaAoJBMJ_Q&feature=shares

Links to my stuff:

* Youtube: https://youtube.com/@robmulla?sub_confirmation=1

* Discord: https://discord.gg/HZszek7DQc

* Twitch: https://www.twitch.tv/medallionstallion_

* Twitter: https://twitter.com/Rob_Mulla

* Kaggle: https://www.kaggle.com/robikscube

SQL Databases with Pandas and Python - A Complete Guide | Knoovi