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. Introduction
Inserting data
Modifying data
Deleting data
CRUD

Instruction

Welcome to our "How to Insert, Update, or Delete Data in MS SQL Server" course, where you will learn how to manage data in SQL Server!

Data in any database is constantly changing. You will learn how to add new information to a database, modify database information, and remove information from a database.

We assume that you already know how to create SQL queries and how to work with them. If you don't, feel free to take a look at our SQL Basics in MS SQL Server course first.

We'll provide you with easy to understand examples based on a simple table named User:

User (Id, Name, Age)

Each user has a unique Id, a specific Name, and an Age. Easy, right?

To make things more exciting, however, you'll be working with another table, Dish. Let's take a look at it.

Exercise

Select all data from the Dish table, and explore the contents.

When you're done, click Run and check code to continue.

If you don't know how to SELECT data from a table, take a look at our SQL Basics in MS SQL Server course.

Stuck? Here's a hint!

Type

SELECT
  *
FROM Dish;