Tables, rows, and columns concept in SQL - Step-by-Step Execution

Concept Flow - Tables, rows, and columns concept

Start: Create Table

↓

Define Columns

↓

Insert Rows

↓

Table with Rows and Columns

↓

Query Table to See Data

↓

Retrieve Rows and Columns

This flow shows how a table is created with columns, rows are added, and then data is retrieved by querying the table.

Execution Sample

SQL

CREATE TABLE Students (
  ID INT,
  Name VARCHAR(50),
  Age INT
);

INSERT INTO Students VALUES (1, 'Alice', 20);
INSERT INTO Students VALUES (2, 'Bob', 22);

SELECT * FROM Students;

This code creates a table named Students with three columns, inserts two rows, and then selects all data from the table.

Execution Table

Step	Action	Table State	Output
1	Create table Students with columns ID, Name, Age	Table created with columns: ID, Name, Age; no rows yet	No output
2	Insert row (1, 'Alice', 20)	Table has 1 row: (1, 'Alice', 20)	No output
3	Insert row (2, 'Bob', 22)	Table has 2 rows: (1, 'Alice', 20), (2, 'Bob', 22)	No output
4	Select all rows from Students	Table unchanged	Rows returned: ID | Name | Age 1 | Alice | 20 2 | Bob | 22
5	End of operations	Final table state with 2 rows	Execution complete

💡 All rows inserted and selected; no more operations

Variable Tracker

Variable	Start	After Step 2	After Step 3	Final
Table Rows	0 rows	1 row: (1, 'Alice', 20)	2 rows: (1, 'Alice', 20), (2, 'Bob', 22)	2 rows: (1, 'Alice', 20), (2, 'Bob', 22)

Key Moments - 3 Insights

Why does the table have columns before any rows are inserted?

Because the table structure is defined first with columns (Step 1 in execution_table). Rows can only be added after columns exist.

What happens if you select from the table before inserting rows?

The query returns zero rows because the table is empty (no data inserted yet), as shown before Step 2.

Are the rows ordered in the table?

Rows are stored in the order inserted here (Step 2 and 3), but SQL does not guarantee order unless ORDER BY is used.

Visual Quiz - 3 Questions

Look at the execution_table, how many rows does the table have after Step 3?

A 2 rows

B 1 row

C 3 rows

D 0 rows

💡 Hint

Check the 'Table State' column at Step 3 in the execution_table.

At which step does the SELECT query return data?

A Step 2

B Step 4

C Step 1

D Step 5

💡 Hint

Look for the 'Output' column showing rows returned in the execution_table.

If we insert a third row after Step 3, how would the 'Table Rows' variable change in variable_tracker?

A It stays at 2 rows

B It resets to 0 rows

C It changes to 3 rows after the next step

D It becomes undefined

💡 Hint

Variable_tracker shows rows increasing after each insert step.

Concept Snapshot

Tables store data in rows and columns.
Columns define the data types and names.
Rows hold actual data entries.
Create table first, then insert rows.
Query to retrieve rows and columns.
Order of rows is not guaranteed without ORDER BY.

Full Transcript

This lesson shows how a database table is created with columns, how rows are added, and how data is retrieved by querying the table. First, the table structure is defined with columns like ID, Name, and Age. Then, rows of data are inserted one by one. Finally, a SELECT query retrieves all rows and columns from the table. The execution table traces each step, showing the table's state and output. Variables track how many rows exist after each insertion. Key moments clarify common confusions such as why columns exist before rows and how row order works. The visual quiz tests understanding of row counts and query results. The concept snapshot summarizes the basics of tables, rows, and columns in SQL.