SQL Querying Basics 🚀¶

Prerequisites: None

Mentor's Note: SQL is the "Universal Language" of data. Whether you use Oracle, MySQL, or Postgres, the basic way you ask for data is almost identical! 💡

🌟 The Scenario: The Digital Filing Cabinet 🗄️¶

Imagine you are the manager of a large school.

The Logic: You have a massive Filing Cabinet (The Database). Inside, you have a drawer labeled "Students" (The Table). 📦
The Action: You want to see only the Names and Roll Numbers of every student.
The Result: You pull out the drawer and look at only those two columns. This is exactly what SELECT and FROM do in SQL. ✅

📖 Concept Explanation¶

1. The `SELECT` Statement¶

The SELECT statement is used to pick which columns (fields) you want to see. - Use SELECT * if you want to see ALL columns. 🌟

2. The `FROM` Statement¶

The FROM statement tells the database which table (drawer) the data is in.

3. Column Aliases (`AS`)¶

Sometimes table columns have technical names like STU_NM. You can rename them in your result using AS to make them readable, like AS "Student Name".

🎨 Visual Logic: The Extraction Flow¶

graph LR
    subgraph Table: ["STUDENTS 📋"]
    C1[ID]
    C2[NAME]
    C3[AGE]
    end
    C1 --- SELECT[SELECT ID, NAME]
    C2 --- SELECT
    SELECT --> Result["Result Set ✅"]

💻 Implementations (Dialect Comparison)¶

Oracle SQLMySQLPostgreSQL

-- 🛒 Scenario: Getting a list of all students
-- 🚀 Action: Extracting ID and Name columns

SELECT student_id, student_name AS "Name"
FROM students;

-- 🛍️ Outcome: A clean list of IDs and Names.

-- 🛒 Scenario: Same logic as Oracle
-- 🚀 Action: Standard SELECT

SELECT student_id, student_name AS Name
FROM students;

-- 🛍️ Outcome: Identical to Oracle.

-- 🛒 Scenario: Same logic as Oracle
-- 🚀 Action: Standard SELECT

SELECT student_id, student_name AS "Name"
FROM students;

-- 🛍️ Outcome: Identical to Oracle.

🧠 Step-by-Step Logic¶

Start 🏁
Point to the Table (FROM clause).
Pick the Columns (SELECT clause).
Run the query.
End 🏁

📊 Sample Dry Run¶

Step	Instruction	Action	Result
1	`FROM employees`	Open Employees table 🗄️	Table ready.
2	`SELECT salary`	Hide all columns except salary 🙈	Salary list.

📉 Technical Analysis¶

Performance: Selecting specific columns is much faster than SELECT * because the database transfers less data over the network. 🏎️

🎯 Practice Lab 🧪¶

Task: The Price List

Task: You have a table named PRODUCTS. Write a query to show only the PRODUCT_NAME and PRICE. Hint: SELECT name, price FROM products; 💡

💡 Interview Tip 👔¶

"Interviewers often ask: 'Can we use SELECT without FROM?' Answer: In MySQL/Postgres, Yes (e.g., SELECT 1+1;). In Oracle, No—you must use the dummy table DUAL (e.g., SELECT 1+1 FROM DUAL;)!"

💡 Pro Tip: "The goal is to turn data into information, and information into insight." - Carly Fiorina

Next: Filtering Data (WHERE) →