Master SQL with Python: Lesson 12 – Maintaining Data in PostgreSQL using Upsert
Having current data is critical for data analysis but how do you keep data up to date? In this video, you will learn how to insert, update, and delete rows from PostgreSQL tables to keep them current. We will use the Upsert statement to do this in the most efficient manner possible.
Content available at:
https://github.com/bcafferky/shared/tree/master/PythonPostgreSQLUpsert
Video: Using SQL with Python: Lesson 8 – Introducing PostgreSQL
https://www.youtube.com/watch?v=UzD9FJ3HBd4&t=937s
Video: Using SQL with Python: Lesson 9 – Using PostgreSQL for Data Analysis
https://www.youtube.com/watch?v=FQzzQnYERBc&t=970s
Comments are closed.