Here are some commonly asked SQL interview questions along with brief answers:

1. What is SQL?
- SQL stands for Structured Query Language, used for managing and manipulating relational databases.

2. What are the types of SQL commands?
- SQL commands can be broadly categorized into four types: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).

3. What is the difference between CHAR and VARCHAR data types?
- CHAR is a fixed-length character data type, while VARCHAR is a variable-length character data type. CHAR will always occupy the same amount of storage space, while VARCHAR will only use the necessary space to store the actual data.

4. What is a primary key?
- A primary key is a column or a set of columns that uniquely identifies each row in a table. It ensures data integrity by enforcing uniqueness and can be used to establish relationships between tables.

5. What is a foreign key?
- A foreign key is a column or a set of columns in one table that refers to the primary key in another table. It establishes a relationship between two tables and ensures referential integrity.

6. What is a JOIN in SQL?
- JOIN is used to combine rows from two or more tables based on a related column between them. There are different types of JOINs, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

7. What is the difference between INNER JOIN and OUTER JOIN?
- INNER JOIN returns only the rows that have matching values in both tables, while OUTER JOIN (LEFT, RIGHT, FULL) returns all rows from one or both tables, with NULL values in columns where there is no match.

8. What is the difference between GROUP BY and ORDER BY?
- GROUP BY is used to group rows that have the same values into summary rows, typically used with aggregate functions like SUM, COUNT, AVG, etc., while ORDER BY is used to sort the result set based on one or more columns.

9. What is a subquery?
- A subquery is a query nested within another query, used to return data that will be used in the main query. Subqueries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

10. What is normalization in SQL?
- Normalization is the process of organizing data in a database to reduce redundancy and dependency. It involves dividing large tables into smaller tables and defining relationships between them to improve data integrity and efficiency.

Around 90% questions will be asked from sql in data analytics interview, so please make sure to practice SQL skills using websites like stratascratch. ☺️💪

Minimalist is hiring Growth Analyst 🚀

Qualification : B.Tech
Experience : 0-1 Year
Location : Jaipur

Apply link : https://beminimalist.zohorecruit.in/forms/9dd60837950b822b529718fc1f5244060daf4ea181d7de82dd7b94cc23d0a85f

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Evertreen is hiring Data Analyst 🚀

Experience : 1-2 Year
Location : Remote ( India )

Apply link: https://www.linkedin.com/jobs/view/4231382580

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

LSEG is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s/ MBA
Salary: 5 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Work From Home/ Office

📌Apply Link: https://lseg.wd3.myworkdayjobs.com/en-US/Careers/job/Data-Analyst_R0103339-1

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Microsoft hiring Senior Business Analyst

Apply link: https://careers.microsoft.com/us/en/job/1824266/Senior-Business-Analyst

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Microsoft hiring Senior Product Manager

Apply link: https://careers.microsoft.com/us/en/job/1823097/Senior-Product-Manager

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Blackrock hiring Analyst

Apply link: https://careers.blackrock.com/job/-/-/45831/79906266832

Requirements:

You have a bachelor’s degree in finance, Accounting, Business or Engineering

You have a keen interest in finance and knowledge of financial markets

You are fluent in English and have excellent writing and communication skills

You have experience using Microsoft tools such as Excel, Sharepoint, and Office 365

An interest and understanding of the alternative assets industry

Experience with MS Power Automate/VBA/Python/SQL

Knowledge of data visualization tools like PowerBI/Qlik/Tableau

Prior exposure to project management and stakeholder management responsibilities

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

Citi is hiring!
Position: Business Analytics, Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Freshers (0 - 2 Years)
Location: Bengaluru, India (Hybrid)

📌Apply Now: https://jobs.citi.com/job/bengaluru/business-analytics-analyst-c09/287/80971588720

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

Natwest hiring Data Scientist

Apply link: https://jobs.natwestgroup.com/jobs/16064413-data-scientist?tm_job=R-00256693-OTHLOC-IND-5FCHE051&tm_event=view&tm_company=861&bid=56

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

LTI Mindtree hiring Business Analyst

Apply link: https://www.linkedin.com/jobs/view/4229799823

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

Wipro hiring Data Analyst

Apply link: https://careers.wipro.com/job/Bengaluru-Data-Analyst-L4-560035/1158734355/

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

CGI is hiring!
Position: Financial Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 5 - 12 LPA (Expected)
Experience: Freshers (0 - 1 Years)
Location: Bangalore, India

📌Apply Now: https://cgi.njoyn.com/corp/xweb/xweb.asp?NTKN=c&clid=21001&Page=JobDetails&Jobid=J0425-1949&BRID=1209225&lang=1

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

Rakuten Symphony hiring Data Scientist

Apply link: https://symphony-rakuten.sensehq.eu/careers/jobs/156

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

MTAB Tech hiring Data Analyst Intern

Apply link: https://www.drjobpro.com/job/view/M9LIQFI908XWD04?source=talent

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

JP Morgan Chase hiring Associate - Data Science, Applied AI & ML

Apply link: https://JPMorganChase.contacthr.com/147499518

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

GE Aerospace is hiring!
Position: Data Scientist
Qualification: Bachelor’s/ Master’s Degree
Salary: 8 - 16 LPA (Expected)
Experience: Entry Level
Location: Bengaluru, India

📌Apply Now: https://careers.geaerospace.com/global/en/job/R5005463/Data-Scientist

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

𝐄𝐘 𝐎𝐟𝐟 𝐂𝐚𝐦𝐩𝐮𝐬 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐦𝐞𝐧𝐭 𝐃𝐫𝐢𝐯𝐞!
Position: Associate Analyst
Qualification: Graduate/ Postgraduate/ MBA
Salary: 4.6 - 6.8 LPA (Expected)
Experience: Freshers/ Experienced
Location: Across India

📌Apply Link: https://careers.ey.com/ey/job/Gurgaon-Associate-Analyst-HR-122010/1199495201/

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

Amazon hiring Data Engineer

Apply link: https://www.amazon.jobs/jobs/2985253/data-engineer

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

Optum is hiring!
Position: Data Analyst, Business & Data Analytics
Qualification: Bachelor’s/ Master's Degree
Salary: 6 - 14 LPA (Expected)
Experience: Freshers/ Experienced
Location: India

📌Apply Link: https://careers.unitedhealthgroup.com/job/21912775/data-analyst-2-noida-in/?src=NGP-22510

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍

EXL Services is urgently hiring for a DataAnalyst role at Bangalore and Gurugram offices.

💡 Key Requirements:
✅ Strong hands-on experience with #Python, #SQL, and #DataAnalytics (Note: This is not a reporting role)
✅ Data Science/Modeling experience is a strong plus
✅ Domain exposure to Banking, Insurance, or related industries
✅ Immediate joiners or those with a notice period of up to 30 days only
📍 Location: Bangalore & Gurugram
⬇️ If you're interested, please send your updated CV (highlight projects related to Python, SQL, Modeling, and ML) to Mounika@kriyahconsulting.com

TCS is hiring Business Analyst 🚀

Experience : 2+ Years
Location : Delhi

Apply link: https://www.linkedin.com/jobs/view/4230212703

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

Like for more job opportunities ❤️

All the best 👍👍