Your First SQL Query

Welcome to SQL! SQL (Structured Query Language) is the language used to communicate with databases.

What is a Database?

A database is like a collection of spreadsheets (called tables) that store organized data.

The SELECT Statement

The most basic SQL command is SELECT. It retrieves data from a table.

Syntax:

SELECT * FROM table_name;

- SELECT tells the database you want to retrieve data

• * means "all columns"

• FROM specifies which table to query

  Your Task

  We have a table called products with information about items in a store.

  Write a query to select all data from the products table.