Psst! Check what courses we have in our offer, and get them all here to save \$727. Tick-tock—this deal ends on 3/21.
Introduction
1. Introduction
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

## Instruction

Welcome to Part 2 of the course. Today, we'll teach you some advanced features of INSERT, UPDATE, and DELETE operations in T-SQL.

You will learn how to:

• Insert, update, and delete with NULL.
• Use the IS NULL operator in the WHERE condition of INSERT, UPDATE, and DELETE statements.
• Write INSERT, UPDATE, and DELETE statements with complicated conditions.
• Use expressions with mixed columns in INSERT, UPDATE, and DELETE queries.
• Display column values during INSERT, UPDATE, and DELETE operations.
• Use an INSERT statement with SELECT to insert many records with just one query.

We're going to work with some data we've acquired from a university on its official examinations, which include written and oral exams. In the oral exam, points are often recorded immediately, while the written exam's result is recorded after the exam has been scored by the teacher.

Let's find out more.

## Exercise

Click to continue.