Part 1 of this video - https://youtu.be/p33XTKbFeBE
Blog post for this video - https://nagasudhir.blogspot.com/2021/12/psycopg2-python-module-for-postgresql.html
Playlist URL - https://youtube.com/playlist?list=PLCgehTvigkDORG6Jk471vO6njvQpViOXV
This video contains code samples and tutorial for Bulk Insert with mogrify, Update, Delete rows with error handling
Setup and use PostgreSQL and pgAdmin - https://youtu.be/ErUPLbqXiB8
Setup and use DBeaver - https://youtu.be/QvW1TBpimcs
Setup Python Development Environment - https://youtu.be/w8MPx1EMNNU
Table of contents - https://nagasudhir.blogspot.com/2020/04/taming-python-table-of-contents.html
00:00 - Intro
00:25 - database setup and Insert rows SQL
02:55 - UPSERT explained
05:40 - Insert rows python script
08:18 - SQL parameter substitution with mogrify
12:42 - Delete rows SQL
13:26 - Delete rows python script
14:34 - SQL parameter substitution
15:31 - Update rows SQL
16:42 - Update rows python script
18:20 - Outro
Please subscribe, like and share this video
#database #dev #tutorial #learning #beginners #psycopg2 #taming_python
