Notes taken by Abd @ITNA Digital

Links

๐Ÿ”— Link to the Video

๐Ÿ”— Alexey's Notes โฌ‡โฌ‡ โ†’ Docker + SQL (google.com)

Untitled

๐Ÿ”— Github Repo โ†’ data-engineering-zoomcamp/week_1_basics_n_setup/2_docker_sql at main ยท DataTalksClub/data-engineering-zoomcamp (github.com)

Untitled

๐Ÿ”— Yellow tax trip records Jan 2021

๐Ÿ”— Yellow Trip Data Dictionary

๐Ÿ”— Taxi zone lookup table

๐Ÿ”— Introduction to Pandas of MLZoomcamp of Data Talks Club

Keywords

PostgreSQL, PGCli, Jupyter Notebook, Pandas, Batch & Chunks, SQL Alchemy, Connecting to Posgres from Pandas

Table of Contents


Setting up PostgreSQL in Docker

In the video Alexey shows us how to run PostGreSQL and Docker and put data into Postgres. And putting the data in the DB we are going to use Python.

Docker compose is a way to run multiple docker images.

docker-compose.yaml