Free courses from frontend to fullstack and AI
Become an AI & ML Engineer with Cal Poly EPaCE — IBM-Certified Training
Overview
Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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