Главная
Study mode:
on
1
Introduction
2
Database Table Maintenance
3
Traditional Solution
4
What is Upsert
5
Why use Upsert
6
PostgreSQL User Interface
7
Create Master Table
8
Import pandas
9
Save pandas table
10
Information Schema
11
Save Transactions
12
Upsert Review
13
Summary
Description:
Learn how to maintain up-to-date data in PostgreSQL tables using the Upsert statement in this 31-minute video tutorial. Explore techniques for inserting, updating, and deleting rows efficiently to ensure data currency for analysis. Discover the advantages of Upsert over traditional methods and gain hands-on experience with PostgreSQL's user interface. Create master tables, import pandas, save pandas tables, work with information schemas, and manage transactions. Access supplementary content on GitHub and related videos for a comprehensive understanding of using SQL with Python and PostgreSQL for data analysis.

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

Bryan Cafferky
Add to list