On-demand Learning
The session introduces the MERGE statement, SQL Server’s command that runs INSERT, UPDATE, or DELETE operations on a target table from the results of a join with a source table. Webinar participants will learn how to:
- Craft MERGE statements using all three match conditions (MATCHED, NOT MATCHED BY TARGET, NOT MATCHED BY SOURCE)
- Implement common upsert patterns (update-or-insert operations used extensively in APIs and data loading)
- Master data synchronization scenarios for ETL processes including one-way synchronization and incremental loading patterns.
Understanding MERGE is vital for any data professional. In this session we cover reusable production-ready patterns and showcase complete stored procedure examples for enterprise-grade MERGE implementations including table-valued parameters and error handling.
Instructor
Hristo Hristov is a seasoned data professional with experience spanning the intersection of data engineering and smart manufacturing solutions. Since 2017, he specializes in implementing advanced analytics solutions for bridging the IT/OT gap.
A technical writer with over fifty published articles on data and AI technologies, Python development, and cloud solutions. Passionate about transforming complex data into business value through innovative applications of Azure Data Platform, Python, IoT solutions, databases, and other cloud technologies.
Currently applying Industry 4.0 best practices, focusing on IoT connectivity, and implementing data and AI systems in manufacturing. Hristo holds a degree in Data Science and several Microsoft certifications covering SQL, Power BI, and related technologies.
For 20+ years, MSSQLTips.com has been delivering comprehensive technical solutions on a daily basis for the Microsoft SQL Server platform. In that time, an innovative team of over 300 authors from around the globe have delivered over 7000 articles and 1000 webcasts ranging from beginner topics to advanced solutions. Our community prides itself on delivering human only generated content.
