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 (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.