## SQL for Beginners in India 2026
SQL (Structured Query Language) is one of the most in-demand skills for data analytics, data science, and business intelligence roles in India. It's on the required skills list for almost every data analyst job in Amritsar, Jalandhar, Bangalore, and Mumbai.
The good news: SQL is one of the easiest programming languages to learn, and you can become job-ready in SQL in 4–6 weeks of consistent practice.
---
What Is SQL and Why Do Data Analysts Need It?
SQL is the language used to query (extract and manipulate) data stored in relational databases. Most business data — sales records, customer data, inventory, HR data, financial transactions — is stored in databases. SQL is how you get to that data.
Real-world example: A company has 5 years of sales data in their database. A business analyst needs to answer "Which product category grew the most in Q3 2026 vs Q3 2025?" The analyst writes an SQL query to extract the relevant data, calculate the growth, and return the answer in seconds — rather than manually searching through thousands of rows.
Why it's essential for data analysts:
Excel has limits — Excel works well up to ~100,000 rows but struggles with millions of rows and complex multi-table joins. SQL handles datasets of any size efficiently.
Every company's data is in a database — whether MySQL, PostgreSQL, Microsoft SQL Server, or cloud databases (BigQuery, Snowflake, AWS Redshift). SQL is the universal language to access all of them.
Recruiters test SQL — most data analyst interviews include a live SQL test or take-home SQL exercise. Being able to write SQL confidently is often the deciding factor in hiring.
---
SQL Commands Every Data Analyst Must Know
Level 1 — Basics (Week 1–2):
SELECT and FROM — extract specific columns from a table: SELECT customer_name, order_value FROM orders;
WHERE — filter rows by condition: SELECT * FROM orders WHERE city = 'Amritsar'; SELECT * FROM orders WHERE order_value > 5000;
ORDER BY — sort results: SELECT * FROM orders ORDER BY order_value DESC;
LIMIT — return only a specific number of rows: SELECT * FROM orders ORDER BY order_value DESC LIMIT 10;
Level 2 — Aggregations (Week 2–3):
GROUP BY with aggregate functions — summarize data by category: SELECT product_category, SUM(revenue) as total_revenue FROM sales GROUP BY product_category; SELECT city, COUNT(*) as customer_count FROM customers GROUP BY city ORDER BY customer_count DESC;
HAVING — filter after grouping (WHERE applies before grouping, HAVING after): SELECT product_category, SUM(revenue) as total_revenue FROM sales GROUP BY product_category HAVING SUM(revenue) > 100000;
Common aggregate functions: SUM(), COUNT(), AVG(), MAX(), MIN()
Level 3 — Joins (Week 3–4):
JOIN is one of the most important SQL concepts — it combines data from multiple tables.
INNER JOIN — returns only rows that match in both tables: SELECT orders.order_id, customers.customer_name, orders.order_value FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;
LEFT JOIN — returns all rows from the left table, and matching rows from the right: SELECT customers.customer_name, orders.order_value FROM customers LEFT JOIN orders ON customers.customer_id = orders.customer_id;
LEFT JOIN is the most commonly used join in business analytics — it preserves all customers even if they haven't placed orders.
Level 4 — Advanced (Week 4–6):
Subqueries — query inside a query: SELECT customer_name FROM customers WHERE customer_id IN (SELECT customer_id FROM orders WHERE order_value > 10000);
CASE WHEN — conditional logic (like if-else in SQL): SELECT customer_name, order_value, CASE WHEN order_value > 10000 THEN 'High Value' WHEN order_value > 5000 THEN 'Medium Value' ELSE 'Low Value' END as customer_segment FROM orders;
Window Functions — calculations across a set of rows related to the current row: SELECT product_name, sales, RANK() OVER (ORDER BY sales DESC) as sales_rank FROM products;
CTEs (Common Table Expressions) — temporary named results that make complex queries readable: WITH monthly_sales AS (SELECT MONTH(order_date) as month, SUM(order_value) as total FROM orders GROUP BY MONTH(order_date)) SELECT month, total FROM monthly_sales WHERE total > 500000;
---
Free Tools to Practice SQL
Browser-based (no installation needed):
SQLiteOnline.com: Run SQL directly in browser. Good for practice queries.
Mode Analytics (mode.com/sql-tutorial): Free SQL tutorial with interactive exercises in browser.
HackerRank SQL practice: Structured SQL challenges from easy to advanced. Creating a free account lets you track progress. Many Indian employers send HackerRank SQL assessments during hiring.
LeetCode SQL problems: 200+ SQL problems. Essential practice for tech company interviews.
Downloadable (install once):
MySQL Community Server (free): The most commonly used database in India. Install MySQL + MySQL Workbench (free GUI tool). Create sample databases and practice.
PostgreSQL + pgAdmin (free): Another popular database. Syntax is 90% the same as MySQL with some differences.
---
Practice Datasets for Indian Context
Learning SQL is faster when you practice with familiar data. Here are approaches:
Kaggle datasets: Kaggle (kaggle.com) has hundreds of free datasets — e-commerce sales, Indian movie data, stock market data. Download as CSV, import into MySQL, practice queries.
Build your own: Create a simple MySQL database for a fictional Indian business — customer table (name, city, phone), orders table (order_id, customer_id, date, amount, product). Practice queries you'd write for real business questions.
Public government data: data.gov.in has many open datasets — census data, agricultural data, etc. — available to download and practice with.
---
How SQL Fits Into the Data Analyst Skill Stack
SQL fits between Excel (for smaller data, reporting) and Python/Power BI (for larger data, ML, visualization):
Excel: Best for data up to 100K rows, quick analysis, pivot tables, presentation-ready formatting. SQL: Best for extracting and transforming data from large databases, multi-table joins, aggregations at scale. Python: Best for large-scale data manipulation, statistical analysis, machine learning. Power BI: Best for building interactive dashboards from data you've already extracted/prepared.
A data analyst in India who knows Advanced Excel + SQL + Power BI covers 80%+ of job requirements for analytics roles in 2026.
---
SQL Learning Path (4–6 Weeks to Job-Ready)
Week 1: SELECT, FROM, WHERE, ORDER BY, LIMIT — practice 30+ queries on sample data Week 2: GROUP BY, aggregate functions, HAVING — practice calculating summaries by category Week 3: JOINS — INNER JOIN, LEFT JOIN — practice combining multiple tables Week 4: Subqueries, CASE WHEN — practice conditional logic and nested queries Week 5–6: Window functions, CTEs — practice HackerRank Medium-level SQL problems
After 6 weeks, you can confidently write the SQL queries that appear in most Indian data analyst interviews and handle the SQL portions of most entry-level analytics jobs.
MITS Academy's Data Analytics course in Amritsar and Jalandhar includes SQL training from beginner to job-ready, with hands-on practice on real datasets.