Say “Hello” to the Table

Welcome to SQL. In this first lesson, you’ll write a simple query to interact with a table and retrieve data, no setup or background required. Let’s get started with your first real query.

Goal

You’ll aim to:

• Run your first SQL query.

• View a whole table using SELECT *.

• Understand the idea of a table as structured data.

Meet the table

Let’s start with a table called people that stores basic information about different individuals, like their name, age, and city. Here’s what it looks like:

The people table