Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Master SQL with Python: Maintaining Data in PostgreSQL Using Upsert - Lesson 12

Bryan Cafferky via YouTube

Start learning Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → University of the People Ad

Earn Your Business Degree, Tuition-Free, 100% Online!

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This lesson teaches how to maintain current PostgreSQL tables from Python by inserting, updating, and deleting rows with the SQL UPSERT statement. It covers table setup, pandas data import, information schema, and transactions.

Syllabus

Introduction
Database Table Maintenance
Traditional Solution
What is Upsert
Why use Upsert
PostgreSQL User Interface
Create Master Table
Import pandas
Save pandas table
Information Schema
Save Transactions
Upsert Review
Summary

Taught by

Bryan Cafferky

Reviews

Start your review of Master SQL with Python: Maintaining Data in PostgreSQL Using Upsert - Lesson 12

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.