In the last module, you learned how to select data, which is a very important step in learning how to use SQL Server.
In this module, we are going to build upon this knowledge by using queries to insert, update, and delete data.
After completing this module, you will be able to:
Use literal values in your
UPDATE queries to modify a table using values from another table
DELETE statements using subqueries
In the next lesson, you will get an overview of the
statement, which is used to insert data into your tables.