Start with the basics of databases and tables, then learn SELECT, WHERE, ORDER BY, and GROUP BY before moving on to JOINs and subqueries. Practice writing queries for 30–60 minutes daily instead of only watching tutorials, since SQL is a skill built through hands-on problem solving. Most beginners in India become job-ready within 4–8 weeks of consistent practice. If self-learning feels scattered, a structured class with doubt-clearing keeps you on track far better than random videos.

The best SQL course is one that makes you write queries from day one, uses real business datasets, covers joins, aggregations, subqueries, and window functions, and includes interview-style practice. Look for personal feedback on your queries, because recorded-only courses rarely point out your mistakes. Live or mentor-led classes with a demo session are usually easier to stick with as a beginner. Remember, certificates matter less than being able to solve a query on the spot in an interview.

Yes, Hindi explanations can make concepts like joins, grouping, and subqueries much easier to understand when you are starting out. Just keep in mind that SQL keywords, error messages, and interview terminology are all in English, so learn the commands in English while using Hindi for conceptual clarity. A mixed approach works best for most learners in India — concepts in Hindi, query writing and interview practice in English.

Follow this sequence: first master single-table queries (SELECT, WHERE, ORDER BY), then aggregations (GROUP BY, HAVING), followed by all JOIN types, then subqueries and CTEs, then window functions like ROW_NUMBER, RANK, and LAG, and finally performance basics such as indexes and avoiding SELECT *. With regular practice, this ladder takes around 3–6 months to climb. Work on progressively harder problems and build 2–3 mini projects, like a sales analysis dashboard, to make your learning interview-ready.

Freshers are usually asked the difference between WHERE and HAVING, types of JOINs with examples, PRIMARY KEY vs UNIQUE KEY, DELETE vs TRUNCATE vs DROP, handling NULL values, GROUP BY with aggregate functions, simple subqueries, and classic queries like finding duplicates or the second-highest salary. Expect a live query-writing round, so practice typing queries, not just reading solutions. Prepare a one-line explanation for each concept, since interviewers often ask "why" behind every answer.

Data analyst interviews blend SQL with business scenarios — top N customers by region, month-over-month sales growth, retention or cohort queries, finding and removing duplicates, date-based filtering, and conditional aggregation using CASE. Window functions like RANK, ROW_NUMBER, and LAG appear in almost every analyst interview. Practice questions framed around sales, marketing, or product data, and be ready to explain the business meaning of your result, not just the syntax.

At the experienced level, fundamentals are assumed and the focus shifts to query optimization, indexes and execution plans, complex window function problems, CTE-based data cleanup, handling large datasets, and designing queries from vague business requirements. You may also get tasks like debugging a slow query or rewriting an inefficient one. Prepare real examples where your SQL improved a metric or process — this is what separates experienced candidates from freshers.

Follow a 2–4 week plan: in week one, revise fundamentals like joins, GROUP BY, and subqueries; in week two, practice topic-wise problems daily; in week three, attempt mixed question sets under time pressure while writing queries on a shared screen and explaining your logic aloud; in the final days, revise common theory questions and company-specific scenarios. A mock interview with a mentor or peer is the fastest way to expose gaps in your explanation style. Maintain notes of every query pattern you struggled with and revisit them before the interview.

Use a clear structure: repeat and clarify the requirement, state your assumptions about the tables and columns, describe your approach — which joins, filters, and aggregations you will use — then write the query step by step while explaining your thinking, and finally sanity-check it with a sample row. Even if your final query has a small error, interviewers reward structured reasoning. Thinking aloud throughout is the single biggest differentiator between candidates.

Start with the essential set: SUM, AVERAGE, COUNT/COUNTA, IF and IFS, SUMIF/SUMIFS, COUNTIF/COUNTIFS, VLOOKUP and XLOOKUP, INDEX-MATCH, LEFT/RIGHT/MID, TRIM, CONCAT/TEXTJOIN, and date functions like TODAY and DATEDIF. Learn each with one small example from your own data, for instance =SUMIFS(D2:D100, B2:B100, "North") to total sales for a region. Practicing every formula on a real dataset is far more effective than memorizing a long PDF list.

A formula is any calculation you build starting with an equal sign, such as =A1+B1 or =D2*10/100. A function is a ready-made calculation built into Excel — like SUM, AVERAGE, IF, or VLOOKUP — which you use inside your formulas, for example =SUM(A1:A10). In short, every function is used within a formula, but not every formula needs a function. Knowing when to write a custom formula versus when to use a built-in function is what makes your reports fast and error-free.

To find what percentage one value is of another, divide the part by the total: =A2/B2, then apply the % format from the Home tab, or multiply by 100 with =A2/B2*100. For percentage change between two numbers, use =(new value - old value)/old value, for example =(B2-A2)/A2. To increase a value by a percentage, multiply it by the factor, such as =A2*1.2 for a 20% increase. Always divide or multiply using cell references, not hard-coded numbers, so results update automatically when data changes.

Excel has no SUBTRACT function — you use the minus operator: =A2-B2. For multiple values, extend it as =A2-B2-C2, and to subtract one column from another, write =A2-B2 in the first row and drag it down. To subtract totals of two ranges, combine it with SUM, like =SUM(A2:A10)-SUM(B2:B10). A common mistake is typing numbers directly into the formula instead of cell references, which breaks the calculation whenever the data changes.

Use the asterisk operator: =A2*B2. For multiplying an entire range, use the PRODUCT function, such as =PRODUCT(A2:A10). To multiply every value in a column by one constant, like a tax rate placed in B1, lock the reference with dollar signs — =A2*$B$1 — and drag the formula down. To apply a percentage, multiply by its decimal form, for example =A2*0.2 for 20% of a value. As with subtraction, always reference cells so your results recalculate when inputs change.