I am learning flutter from JustAcademy, They provide very much great environment where people gather and work simultaneously. totally project based training institute.
Awesome Experience. I am a Front-end Web Designer working at Star India for 3 years now. I applied for Full-stack development and my experience has been phenomenal & they really do help with placements exceptionally. Thank you Roshan sir so much.
If there is one skill that every hiring manager tests without exception, it is SQL. Whether you are applying for your first junior analyst role or gunning for a senior position, SQL interview questions for data analysts will appear in almost every technical round. This guide covers everything — from basic queries to advanced SQL interview questions with answers — so you walk in prepared and walk out with an offer.
SQL is the language of data. Every company — from early-stage startups to Fortune 500 enterprises — stores data in relational databases, and analysts are expected to query, clean, and transform that data independently. In a database interview, SQL is not just one section — it often is the entire technical round.
Knowing SQL well does not just help you pass interviews. It makes you genuinely faster and more effective on the job from day one.
Before diving into the questions, understand what interviewers are actually evaluating:
Most companies test SQL in one of three formats — a live coding round where you write queries in real time, a take-home assignment on a sample dataset, or a whiteboard round where you explain your logic verbally.
These are the foundational questions that appear in almost every screening round. Do not underestimate them — even senior roles test these basics to check your fundamentals.
1. What is SQL and why is it used in data analytics?
SQL stands for Structured Query Language. It is used to communicate with relational databases — to store, retrieve, update, and delete data. In data analytics, SQL is the primary tool for extracting raw data, aggregating it, and preparing it for analysis or reporting.
2. What is the difference between DDL, DML, DCL, and TCL?
DDL (Data Definition Language) defines the structure of the database — CREATE, ALTER, DROP. DML (Data Manipulation Language) handles data within tables — SELECT, INSERT, UPDATE, DELETE. DCL (Data Control Language) manages access permissions — GRANT, REVOKE. TCL (Transaction Control Language) manages transactions — COMMIT, ROLLBACK, SAVEPOINT.
3. What is a primary key?
A primary key is a column or combination of columns that uniquely identifies each row in a table. It cannot contain NULL values and must be unique across all rows. Every table should have one primary key.
4. What is a foreign key?
A foreign key is a column in one table that refers to the primary key in another table. It is used to establish and enforce a relationship between two tables, ensuring referential integrity in the database.
5. What is the difference between CHAR and VARCHAR?
CHAR is a fixed-length data type — it always uses the defined number of characters, padding with spaces if needed. VARCHAR is variable-length — it only uses as much space as the actual data requires. VARCHAR is more storage-efficient for variable-length strings.
6. What is a NULL value in SQL?
NULL represents the absence of a value — it is not zero, not an empty string, and not a space. NULL means the value is unknown or not applicable. You cannot compare NULL using = or != — you must use IS NULL or IS NOT NULL.
7. What is the difference between COUNT(*) and COUNT(column)?
COUNT() counts all rows including those with NULL values. COUNT(column) counts only rows where that column is not NULL. Use COUNT() to count total rows and COUNT(column) when NULLs should be excluded.
8. What is the ORDER BY clause?
ORDER BY sorts the result set by one or more columns in ascending (ASC) or descending (DESC) order. It is always applied after WHERE, GROUP BY, and HAVING in the query execution order.
9. What is the difference between = and LIKE in SQL?
The = operator checks for exact matches. LIKE is used for pattern matching with wildcards — % matches any sequence of characters and _ matches a single character. Use LIKE when you need partial string matching.
10. What is an alias in SQL?
An alias is a temporary name given to a table or column using the AS keyword. It makes queries more readable and is especially useful when dealing with long column names, calculated fields, or when joining multiple tables with similar column names.
These come up in technical rounds for analyst and junior-to-mid level roles. Expect to write these live.
11. What are the different types of JOINs in SQL?
INNER JOIN returns only rows where there is a match in both tables. LEFT JOIN returns all rows from the left table and matching rows from the right — NULLs fill unmatched right-side columns. RIGHT JOIN does the opposite. FULL OUTER JOIN returns all rows from both tables regardless of matches. CROSS JOIN returns every combination of rows from both tables.
12. What is the difference between WHERE and HAVING?
WHERE filters individual rows before any grouping or aggregation occurs. HAVING filters groups after the GROUP BY clause has been applied. You cannot use aggregate functions like SUM or COUNT in a WHERE clause — that is what HAVING is for.
13. What is a subquery and when would you use one?
A subquery is a query nested inside another query, enclosed in parentheses. Use it when the result of one query is needed as input for another — for filtering, calculating, or comparing values. Subqueries can appear in SELECT, FROM, or WHERE clauses.
14. What is a CTE and how is it different from a subquery?
A CTE (Common Table Expression) is defined using the WITH clause and acts as a named temporary result set. Unlike a subquery, a CTE is defined once and can be referenced multiple times in the same query. CTEs are more readable, easier to debug, and support recursion.
15. How do you find duplicate records in a table?
Group by the columns that should be unique and use HAVING COUNT(*) greater than 1. For example:
SELECT email, COUNT() as count FROM users GROUP BY email HAVING COUNT() > 1
This returns all email addresses that appear more than once.
16. How do you find the Nth highest value in a column?
Use a subquery with ORDER BY and LIMIT, or use DENSE_RANK() as a window function. The window function approach is more flexible:
SELECT salary FROM (SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) as rnk FROM employees) ranked WHERE rnk = N
17. What is the difference between UNION and UNION ALL?
UNION combines the results of two queries and removes duplicate rows. UNION ALL combines results and keeps all duplicates including repeated rows. UNION ALL is faster because it skips the deduplication step. Use UNION ALL unless you specifically need unique rows.
18. How do you calculate a running total in SQL?
Use SUM() as a window function with the OVER clause and ORDER BY:
SELECT date, revenue, SUM(revenue) OVER (ORDER BY date) as running_total FROM sales
19. What is the difference between DELETE, TRUNCATE, and DROP?
DELETE removes specific rows based on a WHERE condition and can be rolled back. TRUNCATE removes all rows from a table instantly and cannot be rolled back in most databases. DROP removes the entire table including its structure and data permanently.
20. What is a self join and when would you use it?
A self join joins a table to itself. It is useful when a table has a hierarchical relationship within itself — for example, an employees table where each employee has a manager who is also an employee. You use aliases to distinguish the two instances of the same table.
These advanced SQL interview questions with answers are tested at mid to senior levels and at top-tier companies. Mastering these separates strong candidates from average ones.
21. What are window functions and how are they different from GROUP BY?
Window functions perform calculations across a set of rows related to the current row without collapsing them into a single grouped row. GROUP BY aggregates and reduces rows. Window functions retain all original rows while adding calculated columns alongside them. Common window functions include RANK(), ROW_NUMBER(), DENSE_RANK(), LAG(), LEAD(), SUM() OVER(), and AVG() OVER().
22. What is the difference between RANK(), DENSE_RANK(), and ROW_NUMBER()?
ROW_NUMBER() assigns a unique sequential number to every row regardless of ties. RANK() assigns the same rank to tied rows but skips subsequent ranks — so after two rows ranked 1, the next rank is 3. DENSE_RANK() assigns the same rank to ties but does not skip — so after two rows ranked 1, the next rank is 2.
23. What is the difference between LAG() and LEAD()?
LAG() accesses the value of a column from a previous row within the result set. LEAD() accesses the value from a subsequent row. Both are window functions commonly used to calculate period-over-period changes — for example, comparing this month's revenue to last month's.
24. How do you calculate month-over-month growth using SQL?
Use LAG() to bring the previous month's value alongside the current month, then calculate the percentage change:
SELECT month, revenue, LAG(revenue) OVER (ORDER BY month) as prev_revenue, (revenue - LAG(revenue) OVER (ORDER BY month)) / LAG(revenue) OVER (ORDER BY month) * 100 as growth_pct FROM monthly_sales
25. What is query optimization and how do you approach it?
Query optimization is the process of rewriting or restructuring SQL queries to improve performance and reduce execution time. Key approaches include using indexes on frequently filtered columns, avoiding SELECT * in favor of selecting only needed columns, filtering early with WHERE before joining, avoiding functions on indexed columns in WHERE clauses, using EXISTS instead of IN for large subqueries, and analyzing execution plans using EXPLAIN or EXPLAIN ANALYZE.
26. What is an index and how does it improve performance?
An index is a database object that speeds up data retrieval by creating a separate data structure pointing to rows in a table — similar to an index in a book. Without an index, the database performs a full table scan. With one, it can jump directly to the relevant rows. Indexes significantly improve SELECT performance but can slow down INSERT, UPDATE, and DELETE operations.
27. What is a materialized view?
A materialized view is a database object that stores the result of a query physically on disk, unlike a regular view which is just a saved query that runs every time it is accessed. Materialized views improve query performance for complex, frequently run queries but need to be refreshed periodically to reflect updated data.
28. What is the difference between a view and a table?
A table stores data physically in the database. A view is a virtual table — it is a saved SQL query that presents data from one or more tables without storing it separately. Views simplify complex queries, improve security by restricting access to underlying tables, and ensure consistency across reports.
29. What is normalization and what are the normal forms?
Normalization is the process of organizing a database to reduce redundancy and improve data integrity. The main normal forms are:
30. What is denormalization and when is it used?
Denormalization is the deliberate introduction of redundancy into a database to improve read performance. It is commonly used in data warehouses and analytical databases where read speed matters more than write efficiency. Instead of joining multiple normalized tables, denormalized tables allow faster queries with fewer joins.
These are real-world SQL queries problems commonly given in take-home tests and live coding rounds.
31. Write a query to find customers who have placed more than 3 orders.
SELECT customer_id, COUNT(order_id) as total_orders FROM orders GROUP BY customer_id HAVING COUNT(order_id) > 3
32. Write a query to find the top 5 products by total revenue.
SELECT product_id, SUM(revenue) as total_revenue FROM sales GROUP BY product_id ORDER BY total_revenue DESC LIMIT 5
33. Write a query to find employees who earn more than the average salary of their department.
SELECT e.employee_id, e.name, e.salary, e.department_id FROM employees e WHERE e.salary > (SELECT AVG(salary) FROM employees WHERE department_id = e.department_id)
34. Write a query to find users who signed up but never made a purchase.
SELECT u.user_id, u.name FROM users u LEFT JOIN orders o ON u.user_id = o.user_id WHERE o.order_id IS NULL
35. Write a query to calculate the 7-day rolling average of daily sales.
SELECT date, revenue, AVG(revenue) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as rolling_avg_7day FROM daily_sales
36. Write a query to find the first purchase date for each customer.
SELECT customer_id, MIN(order_date) as first_purchase_date FROM orders GROUP BY customer_id
37. Write a query to identify customers who made purchases in consecutive months.
Use LAG() to get the previous order month per customer, then filter where the difference between the current and previous month is exactly one.
38. Write a query to pivot rows into columns.
Use conditional aggregation with CASE WHEN inside SUM() or COUNT() to transform row values into column headers. This is a common technique when the database does not natively support a PIVOT function.
39. Write a query to find the percentage contribution of each product to total revenue.
SELECT product_id, SUM(revenue) as product_revenue, SUM(revenue) * 100.0 / SUM(SUM(revenue)) OVER () as revenue_pct FROM sales GROUP BY product_id
40. Write a query to detect gaps in a sequential ID column.
SELECT id + 1 as gap_start FROM orders o WHERE NOT EXISTS (SELECT 1 FROM orders WHERE id = o.id + 1) ORDER BY gap_start
41. What is ACID in databases?
ACID stands for Atomicity, Consistency, Isolation, and Durability. These are the four properties that guarantee reliable database transactions. Atomicity ensures all steps in a transaction succeed or none do. Consistency ensures data remains valid. Isolation ensures concurrent transactions do not interfere. Durability ensures committed transactions survive system failures.
42. What is the difference between OLTP and OLAP?
OLTP (Online Transaction Processing) systems handle real-time transactional data — insertions, updates, deletions. They are optimized for fast write operations. OLAP (Online Analytical Processing) systems are optimized for complex read-heavy analytical queries across large datasets. Data warehouses are OLAP systems.
43. What is a data warehouse and how is it different from a database?
A database is designed for transactional workloads — storing and retrieving current data quickly. A data warehouse is designed for analytical workloads — storing historical data from multiple sources in a structure optimized for fast querying and reporting. Examples include Snowflake, BigQuery, and Amazon Redshift.
44. What is a schema in SQL?
A schema is a logical container that organizes and groups database objects like tables, views, and indexes within a database. Common schema patterns in data warehousing include star schema and snowflake schema, which structure fact and dimension tables for efficient analytical queries.
45. What is the difference between a star schema and a snowflake schema?
In a star schema, a central fact table is connected directly to multiple dimension tables — simple and fast for queries. In a snowflake schema, dimension tables are normalized into sub-dimensions, reducing redundancy but increasing query complexity. Star schemas are preferred in most analytical environments for their simplicity and speed.
46. What is partitioning in SQL?
Partitioning divides a large table into smaller, more manageable pieces based on a column value — typically a date or region. It improves query performance by allowing the database to scan only the relevant partition rather than the entire table. It is especially useful in large-scale data warehouses.
47. What is the difference between horizontal and vertical scaling in databases?
Horizontal scaling adds more machines or nodes to distribute the load. Vertical scaling adds more resources — CPU, RAM, storage — to the existing machine. Most modern cloud databases support horizontal scaling to handle growing data volumes.
48. What is an ETL pipeline?
ETL stands for Extract, Transform, Load. It is the process of pulling data from source systems, cleaning and transforming it into the required format, and loading it into a data warehouse or database for analysis. Understanding ETL basics is increasingly expected of data analysts, especially those working with large datasets.
49. What is query execution order in SQL?
SQL queries are executed in this order regardless of how they are written: FROM and JOIN first, then WHERE, then GROUP BY, then HAVING, then SELECT, then DISTINCT, then ORDER BY, and finally LIMIT or OFFSET. Understanding execution order helps debug unexpected query results and write more efficient queries.
50. What are stored procedures and when are they useful?
A stored procedure is a precompiled set of SQL statements stored in the database that can be executed on demand. They improve performance for repeated operations, enforce consistency, reduce network traffic by running logic server-side, and can accept parameters for flexible execution. They are commonly used for reporting, data transformation, and automation tasks.
Preparing for SQL interview questions for data analysts on your own takes time. A structured bootcamp gives you mentored practice, real datasets, mock interview sessions, and placement support — cutting your preparation time significantly.
For classroom training in Mumbai with live projects
For live online training available across India and globally
Download the full course brochure
Full Stack Java Developer Bootcamp — Mumbai
Full Stack QA Automation Bootcamp — Mumbai
MERN Stack Developer Bootcamp — Mumbai
SQL is not going anywhere. It has been the backbone of data work for decades and remains the single most tested skill in every data analyst interview and database interview in 2026. The candidates who get hired are not just the ones who know SQL — they are the ones who practiced enough to write clean, optimized queries under pressure.
Go through every question in this guide. Write out the queries. Test them on real data. Then walk into your next interview knowing that SQL will not be what holds you back.
Selenium WebDriver Interview Questions and Answers for Freshers and Experienced Testers in 2026
UI UX Interview Questions and Answers for Freshers and Beginners Covering Design Thinking, Figma, Wireframing, and UX Research in 2026
Figma Interview Questions and Answers for UI UX Designers, Freshers, and Experienced Designers in 2026
SQL, ORM, and Database Interview Questions and Answers for Python Backend Developers and Freshers in
OOP Concepts, Python Classes Interview Questions and Answers for Beginners and Freshers in 2026
REST API, FastAPI, and Django REST Framework Interview Questions and Answers for Python Freshers and Developers in 2026
Flask API, Python Backend Interview Questions and Answers for Beginners and Freshers in 2026
Django Interview, Python Backend Questions and Answers for Freshers and Beginners in 2026
Python DSA, Coding Interview Questions and Answers for Freshers and Beginners in 2026
Version Control, GitHub Interview Questions and Answers for Python Developers and Freshers in 2026
