Stop Using Python to Aggregate Data - Use SQL Instead | Better Data Science

Are you using Python to extract raw data from the database? It could be a huge bottleneck in your apps. Use SQL instead.

00:00 Introduction
00:57 Create a synthetic dataset with Python
06:13 Load the dataset into Postgres database
08:10 Option #1 - Load the entire table with Python
12:05 Option #2 - Load the prepared views with Python
15:37 Outro

FOLLOW BETTER DATA SCIENCE

FREE “LEARN DATA SCIENCE MASTERPLAN” EBOOK

GEAR I USE