This repository contains a curated collection of frequently asked SQL interview questions and answers designed specifically for Data Analyst roles. It covers SQL fundamentals, query-based problems, and real-world interview scenarios, making it ideal for freshers, interns, and early-career analysts.
🗂️ Topics Covered:
- SQL Basics & Commands (DDL, DML, DQL, TCL)
- WHERE vs HAVING
- Primary Key & Foreign Key
- DELETE vs TRUNCATE vs DROP
- SQL JOINs (INNER, LEFT, RIGHT, FULL, SELF)
- GROUP BY & ORDER BY
- NULL handling
- Subqueries vs JOINs
- Constraints & Indexes
- Normalization (1NF, 2NF, 3NF)
- Views
- Aggregate Functions
- Interview Queries (Top-N, duplicates, salary problems)
- Date-based queries
- Row to column transformation (CASE / PIVOT)
- Core SQL Concepts
- Joins & Relationships
- CTEs
- Conditional aggregation using CASE
- Window Functions
⭐ If You Found This Helpful, Don’t forget to star ⭐ the repository — it really helps!