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
1. Get all data
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
A little bit of mathematics
Let's practice

Instruction

It's time to run your first SQL query! As you remember, the data in a database are stored in tables.

You can see all data in the user table with this query:

SELECT *
FROM user;

SELECT tells your database that you want to select data. FROM user tells the database to select data from the user table.

Finally, the asterisk (*) tells the database that you want to see all columns in this table.

Remember that it is a good practice to always end your SQL command with a semicolon (;). A semicolon is like a period at the end of the sentence. It tells the database that you're done with your command. Our platform accepts your query submissions both with and without a semicolon, so you can leave it out completely in this course.

Exercise

In our example database there is a car table, which contains information about a few cars.

Select all data from the car table and click Run and check code.

Stuck? Here's a hint!

Type:

SELECT *
FROM car;