What is SQL - Visual Explanation

Concept Flow - What is SQL

Start

↓

Write SQL Query

↓

Send Query to Database

↓

Database Processes Query

↓

Return Results

↓

Use Results

↓

End

SQL is a language to ask databases questions and get answers by writing queries that the database understands and runs.

Execution Sample

SQL

SELECT name FROM employees WHERE age > 30;

This query asks the database to give the names of employees older than 30.

Execution Table

Step	Action	Evaluation	Result
1	Parse Query	Check syntax of SELECT statement	Valid syntax
2	Check Table	Look for 'employees' table	Table found
3	Filter Rows	Apply condition age > 30	Rows with age > 30 selected
4	Select Columns	Pick 'name' column from filtered rows	List of names
5	Return Results	Send data back to user	Names of employees older than 30

💡 Query completes after returning requested data

Variable Tracker

Variable	Start	After Step 3	After Step 4	Final
Query Text	SELECT name FROM employees WHERE age > 30;	Same	Same	Same
Filtered Rows	None	Rows where age > 30	Same	Same
Selected Data	None	None	Names from filtered rows	Names from filtered rows

Key Moments - 2 Insights

Why does the database check the table before filtering rows?

Because the database must find the correct table first to know where to look for data, as shown in execution_table step 2.

What happens if the query syntax is wrong?

The database stops at step 1 with an error and does not continue, so no results are returned.

Visual Quiz - 3 Questions

Look at the execution_table, what is the result after step 3?

A List of names

B Rows with age > 30 selected

C Table found

D Query syntax checked

💡 Hint

Check the 'Result' column in row for step 3 in execution_table

At which step does the database pick only the 'name' column?

A Step 2

B Step 3

C Step 4

D Step 5

💡 Hint

Look at the 'Action' column in execution_table for step 4

If the table 'employees' does not exist, what happens?

A Query stops with error at step 2

B Database finds another table

C Query returns empty results

D Query runs normally

💡 Hint

Refer to execution_table step 2 where the database looks for the table

Concept Snapshot

SQL is a language to talk to databases.
You write queries like SELECT to ask for data.
The database checks syntax, finds tables, filters rows, and returns results.
Queries must be correct to work.
SQL helps get exactly the data you want.

Full Transcript

SQL stands for Structured Query Language. It is used to communicate with databases. When you write a SQL query, the database first checks if the query is written correctly. Then it looks for the table you want to get data from. After finding the table, it filters the rows based on your conditions. Next, it selects the columns you asked for. Finally, it sends the results back to you. If any step fails, like if the syntax is wrong or the table does not exist, the database stops and shows an error. This process helps you get the exact data you need from large collections stored in databases.