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 SQL Server Using Merge - Lesson 13

Bryan Cafferky via YouTube

Overview

Learn how to maintain up-to-date data in SQL Server using the Merge statement in this 23-minute video tutorial. Discover the importance of current data for analysis and explore techniques to insert, update, and delete rows efficiently. Integrate pandas with SQL Server to simplify coding and implementation. Follow along with practical demonstrations, including creating the necessary environment. Access additional resources and related videos to further enhance your understanding of using SQL with Python and working with enterprise databases.

Syllabus

Introduction
Agenda
Database Table Maintenance
Traditional Solution
Merge Statement
Why use Merge
Demo
Creating the environment
Wrap up

Taught by

Bryan Cafferky

Reviews

Start your review of Master SQL with Python: Maintaining Data in SQL Server Using Merge - Lesson 13

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.