Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics in MS SQL Server

Get to know the data
4. Get to know the Student table – continued
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
Aliases for tables

Instruction

Excellent. There are only three columns in the Student table: ID, Name, and RoomID. The column ID is the identification number of each student in our table, Name is the full name of a student, and RoomID is the iD of the room in which a student lives. The room ID is, of course, taken from the Room table.

If you examine the Student table close enough, you'll find that some students don't have a room assigned to them. Remember this detail; we'll make use of this information later on.

Okay, let's check the last table.

Exercise

Click Next exercise to continue.