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
2. Get to know the Room table
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
Aliases for tables

Instruction

All right! As you can see, there are four columns in the table room: ID, RoomNumber, Beds, and Floor:

  • ID identifies the rooms the room in our table.
  • RoomNumber is the number of the room typically found on the door.
  • Beds tells you how many beds there are in the room.
  • Floor is the number of the floor where the room can be found in the dormitory.

Easy!

Exercise

Study the contents of the table, and click Next exercise when you're done.