Sql server merge смотреть последние обновления за сегодня на .
This video covers how to use the merge statement with t-sql.
Text version of the video 🤍 Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. 🤍 Slides 🤍 All SQL Server Text Articles 🤍 All SQL Server Slides 🤍 All Dot Net and SQL Server Tutorials in English 🤍 All Dot Net and SQL Server Tutorials in Arabic 🤍 What is the use of MERGE statement in SQL Server Merge statement introduced in SQL Server 2008 allows us to perform Inserts, Updates and Deletes in one statement. This means we no longer have to use multiple statements for performing Insert, Update and Delete. With merge statement we require 2 tables 1. Source Table - Contains the changes that needs to be applied to the target table 2. Target Table - The table that require changes (Inserts, Updates and Deletes) The merge statement joins the target table to the source table by using a common column in both the tables. Based on how the rows match up as a result of the join, we can then perform insert, update, and delete on the target table. Merge statement syntax MERGE [TARGET] AS T USING [SOURCE] AS S ON [JOIN_CONDITIONS] WHEN MATCHED THEN [UPDATE STATEMENT] WHEN NOT MATCHED BY TARGET THEN [INSERT STATEMENT] WHEN NOT MATCHED BY SOURCE THEN [DELETE STATEMENT] Example 1 : In the example below, INSERT, UPDATE and DELETE are all performed in one statement 1. When matching rows are found, StudentTarget table is UPDATED (i.e WHEN MATCHED) 2. When the rows are present in StudentSource table but not in StudentTarget table those rows are INSERTED into StudentTarget table (i.e WHEN NOT MATCHED BY TARGET) 3. When the rows are present in StudentTarget table but not in StudentSource table those rows are DELETED from StudentTarget table (i.e WHEN NOT MATCHED BY SOURCE) Create table StudentSource ( ID int primary key, Name nvarchar(20) ) GO Insert into StudentSource values (1, 'Mike') Insert into StudentSource values (2, 'Sara') GO Create table StudentTarget ( ID int primary key, Name nvarchar(20) ) GO Insert into StudentTarget values (1, 'Mike M') Insert into StudentTarget values (3, 'John') GO MERGE INTO StudentTarget AS T USING StudentSource AS S ON T.ID = S.ID WHEN MATCHED THEN UPDATE SET T.NAME = S.NAME WHEN NOT MATCHED BY TARGET THEN INSERT (ID, NAME) VALUES(S.ID, S.NAME) WHEN NOT MATCHED BY SOURCE THEN DELETE; Please Note : Merge statement should end with a semicolon, otherwise you would get an error stating - A MERGE statement must be terminated by a semi-colon (;) In real time we mostly perform INSERTS and UPDATES. The rows that are present in target table but not in source table are usually not deleted from the target table. Example 2 : In the example below, only INSERT and UPDATE is performed. We are not deleting the rows that are present in the target table but not in the source table. Truncate table StudentSource Truncate table StudentTarget GO Insert into StudentSource values (1, 'Mike') Insert into StudentSource values (2, 'Sara') GO Insert into StudentTarget values (1, 'Mike M') Insert into StudentTarget values (3, 'John') GO MERGE INTO StudentTarget AS T USING StudentSource AS S ON T.ID = S.ID WHEN MATCHED THEN UPDATE SET T.NAME = S.NAME WHEN NOT MATCHED BY TARGET THEN INSERT (ID, NAME) VALUES(S.ID, S.NAME);
The `MERGE` statement probably one of the most powerful features in SQL Server, especially for data engineering tasks. Using the `MERGE` statement, we can insert, update, or delete rows based the differences found in a source and a target tables. Very similar to UPSERT if you are coming from other database systems or you have worked with web APIs. In this video, I want to go over how to use the `MERGE` statement in MS SQL Server. ► Buy Me a Coffee? Your support is much appreciated! - ☕ Paypal: 🤍 ☕ Venmo: 🤍Jie-Jenn 💸 Join Robinhood with my link and we'll both get a free stock: 🤍 ► Support my channel so I can continue making free contents - 🛒 By shopping on Amazon → 🤍 👩💻 Follow me on Linked: 🤍 🌳 Becoming a Patreon supporter: 🤍 ✉️ Business Inquiring: YouTube🤍LearnDataAnalysis.org #sql #sqlserver #dataengineering
MERGE in SQL Server to insert, update and delete at the same time #RDZenTech
Intellipaat SQL course: 🤍 In this merge statement in SQL video you will learn how to merge statements in SQL. You can merge any table's data from one source table to the targeted table using the merge statement syntax. We have covered the hands on demo so that you can learn the concepts well. Watch other videos of this SQL tutorial series: 🤍 Following topics are covered in this video: 00:12 - what is merge 00:53 - sql server merge syntax 02:31 - demo on how to merge tables data with merge statement syntax Interested to learn SQL still more? Please check similar SQL blogs here:- 🤍 Are you looking for something more? Enroll in our MS SQL Server course and become a certified sql professional (🤍 It is a 16 hrs instructor led training provided by Intellipaat which is completely aligned with industry standards and certification bodies. If you’ve enjoyed this how to merge statements in SQL server tutorial, Like us and Subscribe to our channel for more similar informative SQL course tutorials. Got any questions about SQL merge statement syntax? Ask us in the comment section below. Intellipaat Edge 1. 24*7 Life time Access & Support 2. Flexible Class Schedule 3. Job Assistance 4. Mentors with +14 yrs 5. Industry Oriented Course ware 6. Life time free Course Upgrade Why should you watch this SQL tutorial video? The SQL is one of the most important programming languages for working on large sets of databases. Thanks to the Big Data explosion today the amount of data that enterprises have to deal with is humongous. We are offering the top SQL tutorial that can be watched by anybody to learn SQL. Our SQL tutorial has been created with extensive inputs from the industry so that you can learn SQL easily. Who should watch this SQL tutorial? If you want to learn SQL server to become fully proficient and expert in managing the database solutions, managing various operations on databases, migrating it to the cloud and scale on demand then this Intellipaat explanation on SQL is for you. This Intellipaat SQL tutorial is your first step to learn SQL. Since this SQL video can be taken by anybody, so if you are a Software developers and IT professionals, SQL and database administrators, Project Managers, Business Analysts and Managers, Business Intelligence professionals, Big data and Hadoop professionals or someone aspiring for a career in SQL development then you can also watch this SQL tutorial to take your skills to the next level. Why should you opt for a SQL career? SQL optimization has always been a popular topic in database management. SQL Database optimization can be an extremely difficult task, in particular for large-scale data wherever a minute variation can result or impact drastically on the performance. So learning this skill will definitely help you grab the best jobs in top MNCs after finishing Intellipaat SQL online training. The entire Intellipaat SQL course is in line with the industry needs.There is a huge demand for SQL certified professional. The salaries for SQL professional are very good. Hence this Intellipaat tutorial on how merge works in SQL is your stepping stone to a successful career! #MergeStatementInSQL #SQLMergeStatement #SQLServerMergeSyntax For more Information: Please write us to sales🤍intellipaat.com, or call us at: +91- 7847955955 Website: 🤍 Facebook: 🤍 LinkedIn: 🤍 Twitter: 🤍
Video talks about MERGE IN SQL SERVER MERGE STATEMENTS IN SQL Use Merge in SSIS Merge statements provide a flexible approach to manipulate data in destination table based on a join to a source table. Also Part of SQL Training concepts and SQL Server Training Videos.
🧠 Es muy común realizar updates o deletes pero a la vez hacer uniones con otras tablas, en este video vamos a ver de que manera se hace. Script: 🤍
SQL Server has a MERGE statement that lets you do multiple actions in one statement - possibly inserts, updates, and deletes all at once. Here's an example that shows this in action. Blog entry: 🤍 View code on GitHub: 🤍
SQL Server DBA Interview Question "What exactly merge replication is in SQL Server?" Complete list of SQL Server DBA Interview Questions by Tech Brothers 🤍
Without additional optimizations, SQL Server's Merge Join algorithm is the fastest physical join operator available. In this episode we dive into the internals to understand how the merge join algorithm works, as well as what it means for our query performance. Subscribe and turn on notifications to never miss a weekly video: 🤍 Related blog post about Merge Joins: 🤍 Be sure to check out part 1 on nested loops joins: 🤍 And part 3 on hash match joins: 🤍 The pessimistic costing of merge joins: 🤍 Going further in-depth with merge joins: 🤍 Follow me on Twitter: 🤍
Всем привет! С вами Гаус и в этом видео мы познакомимся с операцией MERGE По всем вопросам: truegausstv🤍gmail.com Присоединяйся к нашей группы в контакте, где можно пообщаться с единомышленниками: 🤍 Или в дискод канале: 🤍 Там интересно! Следи за обновлениями: 🤍 Здравствуй, друг! Мы рады тебя приветствовать на канале ГАУС. Каждую неделю у нас выходят новые видео, т.к. обучение программированию, полезные советы (faq), различные шоу (Все логично, Топ 5). Так же мы каждую неделю проводим онлайн трансляции, так что скучать мы тебе точно не дадим! Ссылки, где вы сможете нас найти Подписывайтесь на канал: 🤍 Группа в контакте: 🤍 Twitch: 🤍 #гаус #sql #обучение
33% off Personal Annual and Premium subscriptions! Sign up to expand your technology skills and save TODAY!: 🤍 Watch the full HD course: 🤍 Just like in real life, in SQL Server to execute efficiently, you need a good plan. In this video excerpt from Joe Sack's new course SQL Server: Query Plan Analysis you'll see what to look out for in Merge Joins and how to tell if your query is creating overhead you didn't intend. In the full course Joe also covers how to capture and interpret query plans, common operators and their affects on execution plans, and some noteworthy patterns to follow. -~-~~-~~~-~~-~- Push your limits. Expand your potential. Smarter than yesterday- 🤍 -~-~~-~~~-~~-~-
This video helps you understand what is merge statement in ms sql server and how to use merge statement for synchronize data in source and target table. MS SQL Hindi Playlist : 🤍 MS SQL English Playlist : 🤍 Power BI DAX Hindi Playlist : 🤍 Power BI DAX English Playlist : 🤍 Power BI Hindi Playlist : 🤍 Power BI English Playlist : 🤍 Please subscribe our new channel Lotus Spiritual Ocean 🤍
MS SQL Server. DML. 06. Оператор MERGE. Эти видеоролики по T-SQL записаны для студентов механико-математического факультета Белорусского государственного университета. Соответственно материал разбит на два типа: основной и дополнительный. Список тем приведен ниже № Название видеоролика Продолжительность Тип 1 MS SQL Server. Инструкция Select. 01. Предложение Select 27:44 Основной материал 2 MS SQL Server. Инструкция Select. 02. Предложение Where 38:26 Основной материал 3 MS SQL Server. Инструкция Select. 03. Предложение Group by 21:51 Основной материал 4 MS SQL Server. Инструкция Select. 04. Предложение Group by (RollUp, Cube, Grouping Sets). 45:53 Дополнительный материал 5 MS SQL Server. Инструкция Select. 05. Предложение Having. 07:06 Основной материал 6 MS SQL Server. Инструкция Select. 06. Предложение Order by 12:24 Основной материал 7 MS SQL Server. Работа с несколькими таблицами. 01. UNION, EXCEPT, INTERSECT 09:03 Основной материал 8 MS SQL Server. Работа с несколькими таблицами. 02. Оператор Join 55:31 Основной материал 9 MS SQL Server. Работа с несколькими таблицами. 03. Подзапросы 21:12 Основной материал 10 MS SQL Server. Работа с несколькими таблицами. 04. Производные таблицы 09:49 Основной материал 11 MS SQL Server. Работа с несколькими таблицами. 05. Обобщённое табличное выражение 08:02 Основной материал 12 MS SQL Server. Работа с несколькими таблицами. 06. Рекурсивное обобщённое табличное выражение 09:58 Дополнительный материал 13 MS SQL Server. Работа с несколькими таблицами. 07. Представления 04:42 Основной материал 14 MS SQL Server. Работа с несколькими таблицами. 08. Встроенные табличные функции 05:50 Дополнительный материал 15 MS SQL Server. Работа с несколькими таблицами. 09. Оператор Apply 08:05 Дополнительный материал 16 MS SQL Server. Работа с несколькими таблицами. 10. Оператор Pivot 15:34 Дополнительный материал 17 MS SQL Server. Работа с несколькими таблицами. 11. Оператор UnPivot 06:53 Дополнительный материал 18 MS SQL Server. Оконные функции. 01. Агрегатные оконные функции. 39:45 Дополнительный материал 19 MS SQL Server. Оконные функции. 02. Функции ранжирования ROW NUMBER. 10:47 Дополнительный материал 20 MS SQL Server. Оконные функции . 03. Функции ранжирования Rank Dense rank, Ntile. 08:53 Дополнительный материал 21 MS SQL Server. Оконные функции. 04. Аналитические функции Lag, Lead, First value, Last value. 11:35 Дополнительный материал 22 MS SQL Server. DML. 01. Инструкция INSERT. 16:13 Основной материал 23 MS SQL Server. DML. 02. Особенности INSERT при наличии столбца со свойством IDENTITY. 06:33 Дополнительный материал 24 MS SQL Server. DML. 03. Инструкции DELETE и TRANCATE. 07:16 Основной материал 25 MS SQL Server. DML. 04. Инструкция UPDATE. 03:56 Основной материал 26 MS SQL Server. DML. 05. Предложение OUTPUT. 14:50 Дополнительный материал 27 MS SQL Server. DML. 06. Оператор MERGE. 18:51 Дополнительный материал 28 MS SQL Server. Работа с транзакциями. 01. Основы. 45:24 Дополнительный материал 29 MS SQL Server. Работа с транзакциями. 02. ACID. 57:30 Дополнительный материал
SUBSCRIBE FOR MORE AND PRESS BELL ICON TO GET LATEST VIDEO UPDATES...
APRENDA A PROGRAMAR EM SQL SERVER Gostou? Like ✔ Quer mais? Inscreva-se ✔ Se inscreva aqui no canal, é Grátis! 🤍 Obrigada e até mais! #microsoft #sql #sqlserver #bancodedados #query
My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: 🤍 98-364: Database Fundamentals (Microsoft SQL Server): 🤍 70-462 SQL Server Database Administration (DBA): 🤍 Microsoft SQL Server Reporting Services (SSRS): 🤍 SQL Server Integration Services (SSIS): 🤍 SQL Server Analysis Services (SSAS): 🤍 Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): 🤍 In this view, we have the following views: CREATE VIEW view1 as SELECT object_id, name, create_date, schema_id FROM sys.objects WHERE object_ID BETWEEN 1 AND 9 GO CREATE VIEW view2 AS SELECT object_id, name, modify_date, schema_id FROM sys.objects WHERE object_ID BETWEEN 6 AND 17 GO Each of these videos have got 6 rows, 4 of which are in both views. In this video, I am going to merge these 2 views together, so that there is a total of 8 views. However, there will also be 8 columns, such as 2 object_id columns and 2 name columns. There will be a lot of NULLs where the rows are not in both views. The next task is to merge the two object_id columns together, so that we get rid of the NULLs and have just one object_id. In this video, I will use three different ways of doing this, using the CASE, ISNULL and CASE WHEN ... IS NULL.
Canal oficial de la Escuela de Informática y Telecomunicaciones de DoucUC, Chile. Ejemplo simple de la utilización de una sentencia MERGE en ORACLE.
I explain the basics of a #mergejoin in #SQL. How does it perform? Are there any prerequisites? When is it good? Examples! Discord: 🤍 #comparison
If you are interested to learn more about SQL Server merge command, this is the correct video to watch! This video is all about SQL Server merge command. I will show by example how to use this incredible command: -SQL merge two tables with same columns -merge statement in SQL example Source Table - A table that contains all the changes. Target Table - A different table that will receive all those changes. Perform Insert, Update and Delete in one statement. This video only shows Insert and Update. Thank you for dropping in, I hope you'll find all the information you'll need to successfully use this command. Source code for this video. create table web ( order_id int, has_shipped bit ) insert into web(order_id,has_shipped) values (1,'true'), (2,'true'), (3,'true'), (4,'true') create table production ( order_id int, has_shipped bit ) insert into production(order_id, has_shipped) values (1,'false'), (2,'false'), (3,'false') merge production as T using web as S on (t.order_id = s.order_id ) when matched then update SET T.has_shipped = S.has_shipped when not matched by target then insert (order_id, has_shipped) values (S.order_id, S.has_shipped);
This video illustrated a simple example of merging records from two tables in two different databases to insert new records from source, update the common and deleted which are not common. Credits: Music: YouTube Audio Library Technology : MS SQL Server
12 minute demo of configuring merge replication on Microsoft SQL Server
Having current data is critical for data analysis but how do you keep data up to date? In this video, you will learn how to insert, update, and delete rows to update tables using the SQL Server Merge statement. By integrating with pandas, this is super easy to code and implement. Content available at: 🤍 Video: Master Using SQL with Python: Lesson 3 - Using Enterprise Databases with ODBC Demonstrates using SQL Server with ODBC 🤍 Video: Master Using SQL with Python: Lesson 6 - Create a Data Warehouse Using SQL Server as a Source 🤍
Learn Yourself using pen drive in offline video link 🤍 *Online Classes Starts on First Week of every Month : For Details Contact 9676905431 * #edusoft4u #edusoftlearningsystems#vijaykumarparvathareddy Download Subject related examples & Exercises at: 🤍 This video is part of Edusoft Learning Systems Computer software training in Telugu video series. This video explained by VIJAY KUMAR PARVATHAREDDY. This video explains about MERGE Statement in SQL Server. Touch with us at: 🤍 🤍 🤍 🤍 Visit 🤍 Call us at : 9676905431
В этом уроке мы научимся использовать оператор MERGE (Оператор слияния таблиц), т.е. с помощью этого оператора можно добавлять\обновлять\удалять в таблице данные исходя из данных в другой таблице (выборке). Код пишем на T-SQL. Материалы к уроку Вы найдете по ссылке: 🤍 После прохождения всего курса (уроков) у Вас будет маленькая система учета товаров на складе в Excel, работающая с Базой Данных. Вы сможете написать ее сами, а также расширять по своему усмотрению. Несколько отрывков из этого видеокурса: 🤍 Если Вы чувствуете, что Вам не хватает знаний по SQL, тогда пройдите мой другой курс для начинающих на SQL: 🤍 - объясняю просто и доступно. А также если Вы чувствуете, что Вам не хватает знаний по VBA, тогда пройдите мой курс для начинающих на VBA 🤍 - объясняю просто и доступно "до тошноты" :) Мои видеокурсы: Программирование для Начинающих - 🤍 SQL для Начинающих - 🤍 Видеокурс "Погружение в язык VBA" - 🤍 - Профессиональное программирование на VBA Видеокурс "Погружение в SQL+vba" - 🤍 - Профессиональное программирование на SQL+ADO+VBA Наш официальный Сайт: 🤍 Наша Группа ВКонтакте: 🤍 Наш Инстаграм: 🤍 Мой C#.NET Инстаграм: 🤍 #robotobor #программирование #ityoutubersru #code #sql #output #vba #ado #recordset #activexdataobjects #погружение #storedprocedure #sqlserver #merge #update
MERGE en SQL Server para Insert, Delete y Update. La instrucción MERGE básicamente une datos de un resultado de origen a una tabla destino. Se envían los datos al MERGE, el los compara (por la llave primaria / Columna en común), si existe los actualiza y si no existe los ingresa, también podría ser que si no cumple con los requisitos los pueda borrar. Para ello se insert, update y delete en una sola instrucción. /*PARA EL EJEMPLO CREATE TABLE [dbo].[Venta]( [CodVenta] [int] NOT NULL, [FEmision] [datetime] NULL, [CodEmpleado] [char](4) NULL, [CodCliente] [char](6) NULL, [CodTComprobante] [int] NULL, [Serie] [nchar](3) NULL, [NroDoc] [varchar](6) NULL, [Subtotal] [numeric](18, 2) NULL, [IGV] [numeric](18, 2) NULL, [Total] [numeric](18, 2) NULL, [Estado] [int] NULL ) GO CREATE TABLE [dbo].[VentaHistorial]( [CodVenta] [int] NOT NULL, [FEmision] [datetime] NULL, [CodEmpleado] [char](4) NULL, [CodCliente] [char](6) NULL, [CodTComprobante] [int] NULL, [Serie] [nchar](3) NULL, [NroDoc] [varchar](6) NULL, [Subtotal] [numeric](18, 2) NULL, [IGV] [numeric](18, 2) NULL, [Total] [numeric](18, 2) NULL, [Estado] [int] NULL ) GO */
Text version of the video 🤍 Slides 🤍 All SQL Server Text Articles 🤍 All SQL Server Slides 🤍 Full SQL Server Course 🤍 All Dot Net and SQL Server Tutorials in English 🤍 All Dot Net and SQL Server Tutorials in Arabic 🤍
Support me by watching the ads, tapping Super Thanks, sending Super Chats & Super Stickers thank you so much. Follow me on my social media accounts 🤍 On this video you will learn how to combine SQL databases into one. Donate me direct: Paypal paypal.me/prettymegumi Gcash 09098210091 Join my YouTube channel membership to get access to perks: 🤍 #dontskipads #sql #microsoftsql #database #combiningdatabase
In this SQL Server Quickie I'm talking about the Merge Join operator in SQL Server. You can find the scripts that were used for the demonstration here: 🤍
In this video you will learn how to create Merge replication in SQL Server using SQL Server management studio as well as using T-SQL script. You will also learn how to configure the publication for Merge replication, best practices of configuring publications for Merge replication, how to add database and it's articles in Merge replication, configuring Publication agent security and best practices of security configuration of Publisher as well as Subscriber. It also demonstrates consideration while creating Merge Replication, walk through article, publisher and distributor properties. Blog post link for the video: 🤍 Visit our website to check out SQL Server DBA Tutorial Step by Step 🤍
This video explains merge replication for MS SQL Server 🤍
In this video, I show you the Merge statement. Official documentation for the Merge statement can be found here: 🤍 Evil Programmer Merchandise: 🤍 🤍 Never surf the net without a VPN. Get a great offer on Nord VPN here: 🤍 Nord VPN has a no logs policy so all your activity is private.
This session will help you understand the following concepts : 1. What is Merge Join 2. How the Merge join algorithm worked 3. Criteria used by Optimizer to choose the Merge join operator in joining data from two datasets. #sql #sqlserver #sqlforbeginners #sqlqueries #sqltraining What its previous videos in series : Part 1 Difference between Logical and Physical Join Operators in SQL SERVER 🤍 Part 2 Nested Loop Joins in SQL SERVER 🤍 Thanks for Watching SQL Training Sessions SQL
In this tutorial, we discuss 3 ways to perform Upsert Operations in SQL Server. Timeline - Method 1 - EXISTS - 1:00 Method 2 - ROWCOUNT - 14:40 Method 3 - Merge - 18:27 The SQL code for sample data and tutorial can be found here - 🤍 How to install SQL Server for practice? 🤍 Check out the complete list of SQL Query Interview Questions - 🤍 Best Data Science / Analytics / SQL courses Learn SQL Basics for Data Science Specialization 🤍 Data Science Fundamentals with Python and SQL Specialization 🤍 Python for Everybody Specialization 🤍 Google Data Analytics Professional Certificate 🤍 Coursera Plus - Data Science Career Skills 🤍 Please do not forget to like, subscribe and share. For enrolling and enquiries, please contact us at Website - 🤍 Instagram - 🤍 Facebook - 🤍 Linkedin - 🤍 Email - learn🤍knowstar.org
🧠 Aprende a utilizar el MERGE con resultados de salida, lo que quiero decir es que después de un merge exitoso te regrese valores de salida. Script: 🤍
LinkedIn Learning is the next generation of Lynda.com. Grow your skills by exploring more SQL Server courses today: 🤍 #SQLServer #HowTo #LinkedIn
Nessa aula aprenderemos com um exemplo prático como usar o MERGE no SQL Server
Merge statements are the one of the powerful feature in sql server.It allows developer to write insert update and delete in query .Merge in SQL Server - Part 2 is the second part of the this session. Merge in SQL Server - Part 2||Merge|| SQLSERVER||SQLISEASY #sqlserver #merge #sql
Merge replication is used to replicate data from a publisher to a subscriber database and vice-versa. When a transaction occurs at the Publisher or Subscriber, the change is written to change tracking tables. The Merge Agent checks these tracking tables and sends the transaction to the distribution database where it gets propagated. The merge agent has the capability of resolving conflicts that occur during data synchronization. Part 1 : Introduction to Replication 🤍 Part 2 : Snapshot Replication 🤍 Part 3 : Transactional Replication 🤍 Part 4 : Peer to Peer Replication 🤍