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

JOINs in MS SQL Server

Challenge time

Instruction

Okay! Here comes the last part of our course – the challenge.

We'll work with two sets of tables, with five exercises each. There are no hints, and you can expect to encounter any kind of JOIN that we covered throughout this course.

In the first section of the challenge we'll work with data from La Lingua, a small language school. The first table contains lecturers.

Exercise

Select all data from the Lecturer table. It consists of the following columns:

  • Id – the id of a given lecturer,
  • Name – the first and last name of a given lecturer, and
  • Language – the language a given lecturer teaches.