How to connect to Postgres using Python | Query SQL Database | Pandas | Postgres
In this video we are covering how to connect to Postgres databases using Python. This is a common question that comes up in the ETL series. So, I decided to cover it and direct viewers to it if they are facing connectivity issues.
There are few prerequisites for this. We need the Postgres database installed and configured. Link: • How to install PostgreSQL on windows...
We use a Jupyter notebook to troubleshoot the database connection. Link to Jupyter Notebook installation: • Install Jupyter Notebook on Windows |...
Python build elt pipeline vidoe: • How to build an ETL pipeline with Pyt...
Link to Python ETL series: https://hnawaz007.github.io/etl.html
In addition, we use the SQLAlchemy and psycopg2 libraries. We can install them using a pip command.
Create Schema and User SQL script: https://github.com/hnawaz007/pythonda...
Link to Channel's site:
https://hnawaz007.github.io/
--------------------------------------------------------------
💥Subscribe to our channel:
/ haqnawaz
📌 Links
-----------------------------------------
#️⃣ Follow me on social media! #️⃣
🔗 GitHub: https://github.com/hnawaz007
📸 Instagram: / bi_insights_inc
📝 LinkedIn: / haq-nawaz
🔗 / hnawaz100
🚀 https://hnawaz007.github.io/
-----------------------------------------
#ETL #python #postgres
Topics in this video (click to jump around):
==================================
0:00 - Introduction postgres connection
0:19 - Prerequisites
0:43 - Install required libraries
0:55 - Import libraries
1:09 - Configure Database Secrets
1:26 - Postgres Data Source Connection
2:16 - SQL Query
2:48 - Query Postgres using Pandas
Auf dieser Seite können Sie das Online-Video How to connect to Postgres using Python | Query SQL Database | Pandas | Postgres mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer BI Insights Inc 07 April 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,413 Mal angesehen und es wurde von 29 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
