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.

Practice

1. What is the main purpose of SQL?

easy

A. To design website layouts

B. To manage and manipulate data in databases

C. To write computer games

D. To create graphic designs

Solution

1. Step 1: Understand SQL's role

   SQL is a language used to work with data stored in databases.

2. Step 2: Compare options

   Only To manage and manipulate data in databases describes managing and manipulating data, which is what SQL does.

3. Final Answer:

   To manage and manipulate data in databases -> Option B

4. Quick Check:

   SQL = Data management [OK]

Hint: SQL is for data, not design or games [OK]

Common Mistakes:

• Confusing SQL with programming languages
• Thinking SQL is for web design
• Mixing SQL with graphic tools

2. Which of the following is a correct SQL command to get data from a table named users?

easy

A. GET * FROM users;

B. FETCH ALL users;

C. SELECT * FROM users;

D. SHOW DATA users;

Solution

1. Step 1: Recall SQL syntax for retrieving data

   The correct command to get all data from a table is SELECT * FROM table_name;.

2. Step 2: Match options with correct syntax

   Only SELECT * FROM users; matches the correct SQL syntax for selecting data.

3. Final Answer:

   SELECT * FROM users; -> Option C

4. Quick Check:

   SELECT = retrieve data [OK]

Hint: Use SELECT to get data from tables [OK]

Common Mistakes:

• Using GET instead of SELECT
• Using FETCH or SHOW incorrectly
• Missing FROM keyword

3. What will this SQL query return?

SELECT name FROM employees WHERE age > 30;

medium

A. All employee names with age less than 30

B. An error because of wrong syntax

C. All employee names regardless of age

D. All employee names with age greater than 30

Solution

1. Step 1: Understand the SELECT and WHERE clause

   The query selects the name column from employees where the age is greater than 30.

2. Step 2: Interpret the condition

   The condition age > 30 means only employees older than 30 are included.

3. Final Answer:

   All employee names with age greater than 30 -> Option D

4. Quick Check:

   WHERE age > 30 filters older employees [OK]

Hint: WHERE filters rows by condition [OK]

Common Mistakes:

• Confusing > with <
• Ignoring WHERE clause
• Assuming all rows are returned

4. Identify the error in this SQL statement:

SELEC name FROM customers;

medium

A. Incorrect keyword 'SELEC' instead of 'SELECT'

B. Missing semicolon at the end

C. Table name 'customers' is invalid

D. No columns specified to select

Solution

1. Step 1: Check SQL keywords

   The keyword to get data is SELECT, but here it is misspelled as SELEC.

2. Step 2: Verify other parts

   The table name and column are valid, and the semicolon is optional in many systems.

3. Final Answer:

   Incorrect keyword 'SELEC' instead of 'SELECT' -> Option A

4. Quick Check:

   Correct spelling of SELECT is required [OK]

Hint: Check spelling of SQL keywords carefully [OK]

Common Mistakes:

• Misspelling keywords
• Assuming semicolon is mandatory
• Confusing table and column names

5. You want to add a new user named 'Alice' with age 28 to a table users with columns name and age. Which SQL command should you use?

hard

A. INSERT INTO users (name, age) VALUES ('Alice', 28);

B. UPDATE users SET name = 'Alice', age = 28;

C. SELECT name, age FROM users WHERE name = 'Alice';

D. DELETE FROM users WHERE name = 'Alice';

Solution

1. Step 1: Understand the goal

   You want to add a new row (user) to the table, so you need to insert data.

2. Step 2: Identify the correct command

   INSERT INTO adds new rows; UPDATE changes existing rows; SELECT reads data; DELETE removes data.

3. Final Answer:

   INSERT INTO users (name, age) VALUES ('Alice', 28); -> Option A

4. Quick Check:

   INSERT adds new data [OK]

Hint: Use INSERT to add new rows [OK]

Common Mistakes:

• Using UPDATE to add data
• Confusing SELECT with INSERT
• Deleting instead of adding