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

Table of contents

1. 1. The basics of INSERT, UPDATE, and DELETE

   0/18

   Learn the basic data manipulation operations in SQL Server: INSERT, UPDATE and DELETE

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The Dish table
   2. Inserting data
      1. Insert data
      2. Insert partial data
      3. Insert NULL values
      4. Insert multiple rows
      5. Insert data—exercise
   3. Modifying data
      1. Modify data
      2. Modify multiple columns
      3. Modify multiple rows
      4. Modify data—arithmetic operations
   4. Deleting data
      1. Delete data
      2. Delete all rows
   5. CRUD
      1. SUMMARY: CRUD
      2. Exercise 1—create
      3. Exercise 2—update
      4. Exercise 3—delete
      5. Summary

2. 2. Advanced features of INSERT, UPDATE, and DELETE

   0/17

   Practice advanced version of data manipulation operations in SQL Server. Get to know how to return rows from INSERT, UPDATE and DELETE with OUTPUT clause.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The Student table
      3. The Exam table
   2. Inserting and updating NULLs
      1. Review: Inserting partial data
      2. Insert NULL into a column
      3. UPDATE with NULL in SET
      4. IS NULL in UPDATE
      5. IS NULL in DELETE
   3. Conditions in UPDATE and DELETE
      1. UPDATE with conditions: AND, OR
      2. DELETE with conditions: AND, OR
   4. Using values from another column
      1. Update using a value from another column
      2. Change values between columns
   5. Return rows in INSERT, UPDATE, DELETE
      1. Display deleted values
      2. Display inserted values
      3. Display values in UPDATE
      4. Display values when inserting multiple rows
   6. Summary
      1. Summary

3. 3. Auto-filling values in INSERT, UPDATE, and DELETE

   0/18

   Learn how database can automatically fill certain values. Get to know how you can use auto-filling features in INSERT, UPDATE and DELETE.

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. The Author table
      3. The Post table
   2. Default values
      1. DEFAULT—explanation
      2. Inserting a DEFAULT value into one column
      3. Inserting DEFAULT values by omitting columns
      4. INSERT using DEFAULT for all columns
      5. Using DEFAULT for the current date and time
      6. Update a column using a DEFAULT value
   3. How to auto-generate values in a database
      1. Auto-generated values
      2. IDENTITY
      3. NEWID()—explanation
      4. NEWID()—exercise
      5. Generating a GUID in the UPDATE statement
      6. NEWSEQUENTIALID()
      7. SEQUENCE—explanation
      8. INSERT using SEQUENCE
   4. Summary
      1. Summary

4. 4. Referring to other tables in INSERT, UPDATE, and DELETE

   0/15

   Learn how you can refer to other tables in INSERT, UPDATE, and DELETE operations in SQL Server.

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. The Employee table
      3. The Customer table
      4. The Product table
      5. The Purchase table
   2. INSERT with SELECT
      1. Copy data with INSERT
      2. Complex SELECT with INSERT
   3. Referring to other tables
      1. Delete rows by referring to another table
      2. Update rows by referring to another table
   4. INSERT, UPDATE and DELETE with JOIN
      1. Insert rows using JOIN
      2. Update data using JOIN
      3. Removing rows using JOIN
   5. INSERT, UPDATE, and DELETE with subqueries
      1. DELETE with a subquery in WHERE
      2. UPDATE with a subquery in WHERE or SET
   6. Summary
      1. Summary

5. 5. Final Quiz

   0/11

   Check your knowledge of data manipulation in this quiz.

   List of exercises Buy course
   1. Quiz
      1. Introduction
      2. The Animal table
      3. The Employee table
      4. The AdoptivePerson table
      5. Exercise 1
      6. Exercise 2
      7. Exercise 3
      8. Exercise 4
      9. Exercise 5
      10. Exercise 6
      11. Congratulations!

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more