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

Simple JOINs recap
2. Get to know the Author table
Various kinds of JOINs
Filtering with LEFT JOIN and RIGHT JOIN
Summary

Instruction

Before we start doing exercises, let's get to know the tables we'll be working with.

Today, we'll visit the Bookworm Bookshop. It has lots of books in stock from various authors. Let's take a look at their database, shall we? First, the Author table.

You can view table in the Database tab on the right. Throughout the course, you can always consult the Database tab to check the names of tables and the data they contain.

Exercise

The Author table consists of four columns:

  • Id – the ID of a given author,
  • Name – the name of a given author,
  • BirthYear – the year in which a given author was born, and
  • DeathYear – the year in which a given author died (the field is empty if they are still alive).

Select all data from the Author table.

Type the appropriate SQL query in the Code editor panel and press the Run and check code button.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM Author

If you don't know how to select data from one table, we recommend you first try our SQL Basics in MS SQL Server course before moving on.