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

See the whole table
2. Read the result
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
A little bit of mathematics
Let's practice

Instruction

As you can see, the car table has 5 columns:

  1. vin – short for vehicle identification number
  2. brand
  3. model
  4. price
  5. production_year.

The names of the columns are at the top of the result.

There are 8 cars in our table: two Ford cars, one Toyota, three Volkswagens, one Fiat and one Opel. You can see that the price of a Toyota is $11,300 and the prices for Fords are $8,000 and $12,500. Note that the price for Opel is not specified – we'll explain that later.

Exercise

Examine the result. When you're done, click Next exercise to continue.