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 PostgreSQL

Get to know the data
1. Introduction
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
Aliases for tables

Instruction

Hi! Welcome to another part of our course. You're already pretty skillful in SQL, so this time we're going to go down into details.

By the end of this part, you'll know how to exercise real control over your JOIN clauses. Don't worry if you don't remember JOINs precisely – we're going to review them anyway.

Before we start, you should get to know the data. We're going to work with three brand-new tables: student, room, and equipment. Are you ready?

Exercise

Let's study the first table: room. Get all the data from it.

Stuck? Here's a hint!

Type:

SELECT *
FROM room;