Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Insert, Update, or Delete Data in MS SQL Server

Introduction
1. Welcome
INSERT with SELECT
Referring to other tables
INSERT, UPDATE and DELETE with JOIN
INSERT, UPDATE, and DELETE with subqueries
Summary

Instruction

Welcome to Part 4 of our How to insert, update, or delete data in SQL Server course. Today, we will learn about using INSERT, UPDATE, and DELETE operations that refer to other tables. Knowing how to use these structures will enhance your T-SQL skills.

First, let's familiarize ourselves with the database we will be working with. This is a database of an online store. There are four main tables: Customer, Employee, Product, and Purchase. The store wants to add a reporting and archiving system. In this part, you'll be helping the staff to fill in new reporting and archiving tables.

Exercise

Click Next exercise to continue.