1. What Is SQL and Why Analysts Need It
1.1 What Is SQL in Simple Words (Ask Questions of Tables)
Why. Managers ask questions. Tables hold answers. You need a clear way to ask.
What. SQL (Structured Query Language) is the language you use to ask a database for rows that match your question.
How. Think: table = sheet, row = one record, column = one field. SELECT asks for columns; WHERE keeps matching rows.
Steps
- Open the raja_coffee practice database.
- Look at the orders table — each row is one order.
- Ask: Show me city and amount for a few orders.
Examples
Example 1 · dataset: raja_coffee
SELECT city, amount_inr
FROM orders
LIMIT 5;Output
| city | amount_inr |
|---|---|
| Pune | 840.0 |
| Mumbai | 720.0 |
| Goa | 890.0 |
| Pune | 1050.0 |
| Kolhapur | 620.0 |
Meaning. Five sample rows: city and order amount in INR.
Ravindra Bagale's Tip
SQL does not change your data when you only SELECT. Practise freely.
Ravindra Bagale's Tip – मराठी
फक्त SELECT चालवल्यास डेटा बदलत नाही. मोकळेपणाने सराव करा.
Ravindra Bagale's Tip – हिंदी
केवल SELECT चलाने पर डेटा नहीं बदलता। बेफ़िक्र अभ्यास करें।