𝗦𝗤𝗟 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗔𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁𝘀 (𝗘𝗻𝘁𝗿𝘆-𝗟𝗲𝘃𝗲𝗹) 📊

Preparing for a data analyst role? Sharpen your SQL skills with these fundamental interview questions:

1. What is SQL, and how is it used in data analysis?

2. Difference between SQL and NoSQL databases?

3. How to retrieve unique values from a column in SQL?

4. Explain the JOIN clause in SQL with examples.

5. What is the purpose of the GROUP BY clause in SQL?

6. How to handle NULL values in SQL?

7. Write a SQL query to find the second highest salary in a table.

8. What is a subquery, and how is it different from a JOIN?

9. How to update data in a SQL table?

10. Explain the ACID properties of a transaction in SQL.

11. What is the HAVING clause in SQL? When would you use it?

12. Difference between INNER JOIN and LEFT JOIN in SQL?

13. How to calculate the total count of rows in a table?

14. Write a SQL query to find duplicate records in a table.

15. What is normalization and denormalization in SQL?

16. Explain the concept of indexing in SQL and its types.

17. How to perform a SQL query optimization?

18. What are triggers in SQL, and when would you use them?

19. Difference between UNION and UNION ALL in SQL?

20. Write a SQL query to get the third maximum value from a table.

🌟 Free SQL Learning Resources:

📘 W3Schools.com SQL Tutorial: https://lnkd.in/dYCh4T9T


📘 Mode Analytics SQL Tutorial: https://lnkd.in/dPcG9WuD

📘 SQLZoo Interactive SQL Tutorial: https://lnkd.in/dSd8C9Fj

📘 Khan Academy - Intro to SQL: https://lnkd.in/dhTkEeNW

1️⃣ MASTER SQL in 16 pages- https://lnkd.in/dA9mxz56

2️⃣ Most Asked SQL Questions - https://lnkd.in/d2mtGWWi

3️⃣ Ace Your SQL Interview with 150 Practice Queries! - https://lnkd.in/dpaiW83g

4️⃣100 Most Asked SQL QnA - https://lnkd.in/dYbw3c4J

5️⃣ SQL Interviews with FREE LeetCode Solutions! - https://lnkd.in/dJtQnUTV

𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗵𝗶𝗿𝗶𝗻𝗴 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_dataanalystjobs-fresherjobs-careeropportunities-activity-7134178922321129473-thlx

Data Science Opportunities

1. Myntra is hiring for the role of Data Analyst
Experience: Fresher
Location: Bangalore

https://unstop.com/jobs/data-analyst-myntra-822449

2. Accenture is hiring for the role of Analyst
Experience: Fresher
Location: Gurgaon, Bengaluru, Mumbai

https://unstop.com/jobs/analyst-accenture-822494

3. S&P Global is hiring for the role of Data Analyst
Experience: Fresher
Location: Hyderabad

https://unstop.com/jobs/data-analyst-sp-global-inc-827959

4. Wood Mackenzieda is hiring for the role of Data Associate
Experience: Fresher
Location: Gurgaon

https://unstop.com/jobs/data-associate-wood-mackenzie-825248

5. Flipkart is hiring for the role of Business Analyst
Experience: 1+ Years
Location: Bangalore

https://unstop.com/jobs/business-analyst-flipkart-818843

6. Cognizant is hiring for the position of Senior Process Executive - Data
Experience: Experience: 1+ Year
Location: Chennai

https://unstop.com/jobs/senior-process-executive-data-cognizant-824992

7. Myntra is hiring for the role of Associate - Data Analyst
Experience: 2+ years
Location: Bengaluru

https://unstop.com/jobs/associate-data-analyst-myntra-827965

8. Invest India is hiring for the role of Data Analyst
Experience: 2+ years
Location: Delhi

https://unstop.com/jobs/data-analyst-invest-india-827772

9. ABB is hiring for the role of Junior Data Analyst
Experience: 2 years
Location: Bangalore

https://unstop.com/jobs/junior-data-analyst-abb-group-820158

10. S&P Global is hiring for the role of Lead Data Analyst
Experience:3+ Year
Location: Ahmedabad

https://unstop.com/jobs/lead-data-analyst-sp-global-inc-827978

11. Cisco is hiring for the role of Data Scientist
Experience: 3+ years
Location: Bangalore

https://unstop.com/jobs/data-scientist-cisco-825407

12. Kotak Mahindra Bank is hiring for the role of Senior Data Analyst
Experience: 3+ years
Location: Bengaluru

https://unstop.com/jobs/senior-data-analyst-kotak-mahindra-bank-ltd-820319

13. Elanco is hiring for the role of Associate Manager - Advanced Analytics
Experience: 4+ years
Location: Bengaluru

https://unstop.com/jobs/associate-manager-advanced-analytics-elanco-822209


Mad Street Den is hiring for Dataanalysts
Role: Data analyst
Location: Chennai, India
Type: onsite & Fulltime based

https://www.madstreetden.com/careers/


Goldman Sachs is hiring!
Position: Financial Analyst/ Associate
Qualifications: Bachelor’s/ Master’s Degree
Salary: 7 - 10 LPA (Expected)
Experience: 0 - 3 (Years)
Location: Bangalore/ Hyderabad

📌Apply Link: https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/117029?

https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/116060

Software Opportunities

BharatPe is Hiring Software Engineer Freshers!

Expected Salary: INR 17 - 20 LPA
Job Location: Gurgaon
Experience Required: 0 - 2 Years

Apply Link: https://rb.gy/u8l98l


Apple India Hiring for Full Stack + Front Engineers

https://jobs.apple.com/en-us/details/200519641/full-stack-software-engineer-data-apps-frontend


Company name: Autodesk
Batch: 2023 & 2024 passouts
Role: Software Engineering Apprentice
Location: Bengaluru

Apply Link : https://autodesk.wd1.myworkdayjobs.com/en-US/Ext/job/Bengaluru-IND/Apprentice--Software-Engineer_23WD73763-1

BlackLight Studio hiring Fullstack Developer Job
Noida, India

Job Type: In-Office
Job Offer: ₹ 6LPA - 12LPA
Experience: 3+ years

✅Apply here👉 https://cuvette.tech/app/public/job/65605758c756a7f66e2f5dd0

Bloomont is hiring #Freshers for below roles.
- Trainee Software Tester
- IT project coordinator
Trainee Application Analyst.
- Trainee Dot Net Developers (2019-2023 passed outs)

Interested candidates can share their resumes at hr@bloomont.com

Nagarro is Hiring !!

Role: Engineer, Frontend React
Expected CTC: 6-12 LPA
Location: Bangalore

Apply here: https://jobs.smartrecruiters.com/Nagarro1/743999906499204-engineer-frontend-react

Sony is Hiring !!

Role: Web UI Developer
Expected CTC: 8-15 LPA
Location: Bangalore
Apply here- https://sonyglobal.wd1.myworkdayjobs.com/SonyGlobalCareers/job/Bangalore/Web-UI-Developer_JR-115386-1

AliveCor is Hiring !!

Role: Software Engineer - Frontend
Experience: 1- 4 year's
Expected CTC: 15-20 LPA
Location: Bangalore

Apply here: https://jobs.jobvite.com/alivecor/job/oELOpfwm

Internship Opportunities


Mobile App Developer Internship
Axai | Bangalore, India

Stipend per month: ₹ 10K - 15K
Duration: 6 Months(5-7 Hrs/day)
Job Offer: 6LPA - 11LPA

✅Apply here👉 https://cuvette.tech/app/public/internship/65608b12ed5cf781b7eea174

𝗜𝗕𝗠 𝗮𝗻𝗱 𝗠𝗲𝘁𝗮 𝗼𝗳𝗳𝗲𝗿𝗶𝗻𝗴 𝗪𝗲𝗯 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗲𝘃𝗲𝗿𝘆𝗼𝗻𝗲🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_sql-handwritten-notes-activity-7134367669620752384-qvpQ

𝗚𝗶𝘁 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁 𝗮𝗻𝗱 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_git-cheat-sheet-activity-7134488459771076608-HF35

Connecting with remote developer who are interested for fulltime contractual positions in IT and freelancer who can spend 8 hours a day can also connect.

https://www.linkedin.com/posts/jagruti-patil-3b7881112_connections-remote-fulltime-activity-7134477688806723584-gvkO

Git Cheat Sheet and Free Resources for learning

https://www.w3schools.com/git/

https://www.simplilearn.com/tutorials/git-tutorial/git-tutorial-for-beginner

https://www.geeksforgeeks.org/git-tutorial/

https://www.datacamp.com/tutorial/github-and-git-tutorial-for-beginners

https://www.gitkraken.com/learn/git/tutorials

https://www.mygreatlearning.com/academy/learn-for-free/courses/git-tutorial

https://www.upgrad.com/blog/git-tutorial/

𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗵𝗶𝗿𝗶𝗻𝗴 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁, 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_dataanalystjobs-fresherjobs-careeropportunities-activity-7134538882519285760-vM9N

Data Science Opportunities

1. Company: Cadila Zydus Healthcare Ltd
Role: Data Analyst
Exp: 0-1 Years
Apply Now: https://www.linkedin.com/jobs/view/3768554238

2. Myntra is hiring for the role of Data Analyst
Experience: Fresher

https://unstop.com/jobs/data-analyst-myntra-822449

3. Myntra is hiring for the role of Data Science
Experience: Fresher

https://unstop.com/jobs/data-scientist-myntra-813873

4. Company: Turing
Role: Data Analyst
Exp: Freshers
Apply Now: https://www.linkedin.com/jobs/view/3742067842

5. Company: Maruti Suzuki India Limited
Role: Data Analyst - R&D
Exp: 1+Years
Apply Now: https://www.linkedin.com/jobs/view/3674500546

6. Company: Tiger Analytics
Role: Senior Analyst-Data Science
Exp: 2+ Years
Apply Now: https://www.linkedin.com/jobs/view/3746382122

7. Company: HCDS Technologies
Role: Data Analysis
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3772760041

8. Company: MiStay - India's Largest Hourly Hotels
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3761411694

9. Company: Vivriti Capital
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3761567330

10. Company: Trexquant Investment LP
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3677952236

11. Company: KLA
Role: AI/ML Intern
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3751492721

12. Company: UM IT Services & Consulting
Role: Data Analytical
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3768916829

Awign is hiring for a Fresher Product Analyst!

Experience - 0+ years

https://www.linkedin.com/posts/vibvibgyor_freshersjob-hiring-openings-activity-7134490203066445824-lhSe


Machine Learning Engineer

For 2023/2022 Grads

Expected CTC: 8-15 LPA

Apply: https://tinyurl.com/4x8bjfpe

Data Analyst Internships👩‍⚖️👩‍⚖️

📌Company: Cisco
👩‍💻Job role: Data Analyst
📍Location: Bengaluru
🔗Link: https://bitly.ws/33drM

📌Company: Wipro
👩‍💻Job role: Data Analyst
📍Location: Maharashtra
🔗Link : https://bitly.ws/33dsF

📌Company: Virtusa
👩‍💻 Job role: Data Analyst
📍Location: Andhra Pradesh
🔗Link : https://bitly.ws/33dto

📌Company: S&P Global
👩‍💻Job role : Data Analyst
📍Location: Ahmedabad
🔗Link : https://bitly.ws/33du9


Blinkit is hiring Business Analyst

https://www.linkedin.com/jobs/view/3772373723

Software Opportunities

Company : Zeta
Role : SDE Intern
Batch : 2024

Link : https://docs.google.com/forms/d/e/1FAIpQLSelAjzPgaV9mNsNtN2okz78E2HVrqhWcj5Gin9RT5YxpfRMhw/viewform


Fullstack Developer Job

For 2023/2022 Grads

Expected CTC: 6-12 LPA

Apply: https://tinyurl.com/3bnumybe



Zoho is hiring for the role of Software Developer!

Expected Salary: INR 5 - 13 LPA (via Glassdoor)

Apply link- https://unstop.com/jobs/software-developer-zoho-826234


Ecolab is Hiring !!

Role: Application Engineer
Expected CTC: 5-10 LPA
Location: Jharkhand
Apply here: https://ecolab.contacthr.com/126289064

Victoria's Secret is Hiring !!

Role: FRONT END WEB DEVELOPER
Experience: 1-3 year's
Expected CTC: 8-12 LPA
Location: Bangalore
Apply here- https://careers.victoriassecret.com/job/17974143/


LoKal is Hiring !!

Role: Backend Developer Intern
Stipend: 35K per month
Location: Bangalore
Apply here- https://instahyre.com/job-222111-backend-developer-internship-at-lokal-bangalore/


Genpact is Hiring !!

Role: Electrical Engineer
Experience: 0-2 year's
Expected CTC: 5 - 10 Lpa
Apply here- https://unstop.com/jobs/electrical-engineer-genpact-822679


Hyland is currently hiring Angular Developer.

https://www.linkedin.com/posts/rohit-mondal-070624145_hyland-hiring-kolkatajobs-activity-7133123466991472640-GZlb


Godrej Infotech are looking to onboard Freshers (B.E /B.Tech) 2023 passout

https://www.linkedin.com/posts/swati-sapra_freshersjob-bangalorejobs-bangalore-activity-7134222611936423936-pJh7

𝗦𝗤𝗟 𝗥𝗼𝗮𝗱𝗺𝗮𝗽 𝘄𝗶𝘁𝗵 𝗙𝗥𝗘𝗘 𝗰𝗼𝘂𝗿𝘀𝗲𝘀 🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_master-sql-in-16-pages-activity-7134730051878551552-iY2e

𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗘𝘅𝗰𝗲𝗹 𝗙𝗿𝗲𝗲 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_excel-exceltips-dataanalysis-activity-7134850853689016320-XlmT

𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗵𝗶𝗿𝗶𝗻𝗴 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁, 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_dataanalystjobs-fresherjobs-careeropportunities-activity-7134912622742634496-RXjf

Data Science Opportunities

1. HSBC Hiring Data Analyst
Experience: Freshers

https://mycareer.hsbc.com/en_GB/external/PipelineDetail/Data-Analyst-Engineer/206088

2. SquadStack is hiring for the role of Business Analyst
Experience: Fresher
Location: Noida, Goa

https://unstop.com/jobs/business-analyst-squadstack-811937

3. Accenture is hiring Data Analyst/ Reporting Roles

1) https://www.accenture.com/in-en/careers/jobdetails?id=298237_india_2

2) https://www.accenture.com/in-en/careers/jobdetails?id=303153_india_2

4. Meesho Hiring Business Analyst
Experience: 1+ year

https://jobs.lever.co/meesho/89fea73b-26f2-444d-83aa-80096e44c0c5

5. KPMG is hiring for the role of Risk Advisory Data Analytics Analyst
Experience: 1+ Year
Location: Mumbai

https://unstop.com/jobs/risk-advisory-data-analytics-analyst-kpmg-818211

6. Teikametrics is hiring for the role of Data Specialist
Experience: 2+ Year
Location: Work From Home

https://unstop.com/jobs/data-specialist-teikametrics-819311

7. Microsoft is hiring for the role of Data Engineer
Experience: 2+ Year
Location: Hyderabad

https://unstop.com/jobs/data-engineer-microsoft-812299

8. Bunge is hiring for the role of Business Analyst
Experience: 3+ Year
Location: Punjab

https://unstop.com/jobs/business-analyst-bunge-819139

GreenStitch Data Science Internship
Bangalore, India

Stipend per month : ₹ 15K - 25K
Duration : 3-6 Months

https://cuvette.tech/app/public/internship/655afe9edd9ed358f8656447


News corp is hiring for Dataanalysts
Role: Data analyst
Location: Bangalore, India
Type: onsite & Fulltime based

https://dowjones.wd1.myworkdayjobs.com/en-US/News_Corp_Careers/job/Bangalore/Data-Analyst_Job_Req_39768


Consilio is Hiring !!

Role: Associate, Data Operations
Experience: 0-2 years ( Fresher )
Expected CTC: 4-8 Lpa
Qualification: BCA and BSC (computers or information science) fresher graduates.
Apply here- https://careers-consilio.icims.com/jobs/2815/job


Awign is hiring for a Fresher Product Analyst!

Experience - 0+ years

Send your CV to srijon.banerjee@awign.com