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
2. The Student table
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

Instruction

Let's check out the first table, Student.

Exercise

Select all columns from the Student table. It's a pretty small table that contains only four columns:

  • The student identifier (Id).
  • The first name of the student (FirstName).
  • The middle name of the student (MiddleName).
  • The last name of the student (LastName).

Note: Not every student has a middle name.