Data Analyst

EY Data Analyst Interview Insights (0-3 Years)
If you’re preparing for a Data Analyst interview at Deloitte, here are some key SQL-related questions to expect:
🔹 SQL Fundamentals & Queries
1️⃣ What is SQL, and how is it applied in data analysis?
2️⃣ Explain the difference between primary key and foreign key in SQL.
3️⃣ What is a JOIN, and how does it function in SQL queries?
4️⃣ Describe different types of JOINs with examples.
5️⃣ How do WHERE and HAVING clauses differ?
6️⃣ What is the role of GROUP BY in SQL, and why is it useful?
7️⃣ What are subqueries, and in what scenarios would you use them?
🔹 Database Optimization & Design
8️⃣ What is indexing, and how does it improve query performance?
9️⃣ Define normalization and its importance in database structuring.
🔟 What are the different normal forms, and why are they significant?
1️⃣1️⃣ What is denormalization, and when should you consider it?
1️⃣2️⃣ How do you handle NULL values in SQL?
1️⃣3️⃣ What are window functions, and how do they enhance queries?
🔹 Advanced SQL Concepts
1️⃣4️⃣ Differentiate between UNION and UNION ALL.
1️⃣5️⃣ How can you optimize SQL queries for better efficiency?
1️⃣6️⃣ What is a CTE (Common Table Expression), and why use it?
1️⃣7️⃣ Explain ACID properties and their role in SQL transactions.
1️⃣8️⃣ What are stored procedures, and what benefits do they offer?
1️⃣9️⃣ How is error handling implemented in SQL?
2️⃣0️⃣ What distinguishes DELETE from TRUNCATE?
🔹 Data Management & Security
2️⃣1️⃣ What are database views, and how are they useful?
2️⃣2️⃣ How do you perform pattern matching in SQL?
2️⃣3️⃣ What are aggregate functions? Provide examples.
2️⃣4️⃣ How do you import and export data in SQL?
2️⃣5️⃣ What is a self-join, and when would you use it?
2️⃣6️⃣ How do you ensure data integrity in an SQL database?
2️⃣7️⃣ What are triggers, and how do they function?
2️⃣8️⃣ Explain the concept of transactions and their importance.
2️⃣9️⃣ How do you manage user permissions and database security?
3️⃣0️⃣ Can you share an example of a complex SQL query you’ve written and break down its components

*Follow Savar Bajiya Bajiya for more valuable insights and tips on SQL/Power BI*

🔍 *Explore more with Savar Bajiya Bajiya for Data Analysis, Power BI Tips & Tricks*

👍 𝗟𝗶𝗸𝗲 *if you found it helpful!*
🔁 𝗥𝗲𝗽𝗼𝘀𝘁 with your network!
🔖 𝗦𝗮𝘃𝗲 for future use!
📤 𝗦𝗲𝗻𝗱 to your connections!
💬 𝗖𝗼𝗺𝗺𝗲𝗻𝘁 your thoughts below!