PrepNPlaced
26.5K subscribers
219 photos
6 videos
313 files
9.4K links
๐Ÿš€ Welcome to the Elite Data Engineering & Agentic AI Hub! ๐Ÿš€

๐Ÿ‘‘ Community Creator: Mandar Patil
๐Ÿ‘จโ€๐Ÿ’ป Admin & Mentor: Durgesh Yadav

The era of basic data tasks is over. With Agentic AI evolving the industry, up to 60% of traditional Data Analyst roles
Download Telegram
Company Name: Seagate
Role: C/C++ Python Intern
Batch : 2024 & 2025 passouts

Apply Link: https://seagatecareers.com/job/Pune-Intern-CC%2B%2B-Python-Programmer/1081271300/
Company Name: Philips
Role: SDE Intern
Batch : 2024 & 2025 passouts

Apply Link: https://philips.wd3.myworkdayjobs.com/jobs-and-careers/job/Bangalore/Intern---Software-Development-Engineer_476470/
Swiggy hiring Associate Software Development Engineer
Experience: 0-2 years (2022, 2023 batch)

https://www.linkedin.com/posts/gursimarsm_referral-swiggy-freshers-activity-7133807050408554497-J0Fs
๐Ÿ‘1
Internship Opportunities

Backend Developer Internship
For2025/ 2024/2023 Grads
Expected Stipend: 8-8.5k per month

Apply: https://tinyurl.com/ye298trk
๐— ๐—ถ๐—ฐ๐—ฟ๐—ผ๐˜€๐—ผ๐—ณ๐˜ & ๐—Ÿ๐—ถ๐—ป๐—ธ๐—ฒ๐—ฑ๐—œ๐—ป ๐—ฟ๐—ฒ๐—น๐—ฒ๐—ฎ๐˜€๐—ฒ๐—ฑ ๐—ฎ ๐—ฝ๐—ฟ๐—ผ๐—ณ๐—ฒ๐˜€๐˜€๐—ถ๐—ผ๐—ป๐—ฎ๐—น ๐—ฐ๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ฒ ๐—ถ๐—ป ๐—š๐—ฒ๐—ป๐—ฒ๐—ฟ๐—ฎ๐˜๐—ถ๐˜ƒ๐—ฒ ๐—”๐—น๐Ÿคฉ

https://www.linkedin.com/posts/mandarmpatil_sql-basics-for-beginners-activity-7134005282157834241-Dp66
edX is offering free online courses.

There is no fee or application needed.

Here are 15 FREE courses you don't want to miss:

1. Introduction to ChatGPT

๐Ÿ”— https://www.edx.org/learn/artificial-intelligence/edx-introduction-to-chatgpt

2. Prompt Engineering and Advanced ChatGPT

๐Ÿ”— https://www.edx.org/learn/computer-programming/edx-advanced-chatgpt

3. How to Use ChatGPT in Business

๐Ÿ”— https://www.edx.org/learn/computer-programming/edx-how-to-use-chatgpt-in-business

4. Linear Algebra - Foundations to Frontiers

๐Ÿ”— https://www.edx.org/learn/linear-algebra/the-university-of-texas-at-austin-linear-algebra-foundations-to-frontiers

5. Machine Learning with Python: From Linear Models to Deep Learning

๐Ÿ”— https://www.edx.org/learn/machine-learning/massachusetts-institute-of-technology-machine-learning-with-python-from-linear-models-to-deep-learning

6. CS50's Introduction to Artificial Intelligence with Python

๐Ÿ”— https://www.edx.org/learn/artificial-intelligence/harvard-university-cs50-s-introduction-to-artificial-intelligence-with-python

7. Generative AI for Business Leaders

๐Ÿ”— https://www.edx.org/learn/computer-programming/edx-generative-ai-for-business-leaders

8. Programming for Everybody

๐Ÿ”— https://www.edx.org/learn/python/the-university-of-michigan-programming-for-everybody-getting-started-with-python

9. Google Cloud Computing Foundations: Cloud Computing Fundamentals

๐Ÿ”— https://www.edx.org/learn/cloud-computing/google-cloud-google-cloud-computing-foundations-cloud-computing-fundamentals

10. Machine Learning with Python: A Practical Introduction

๐Ÿ”— https://www.edx.org/learn/machine-learning/ibm-machine-learning-with-python-a-practical-introduction

11. Data Science: Machine Learning

๐Ÿ”—https://www.edx.org/learn/machine-learning/harvard-university-data-science-machine-learning

12. C++ Programming: Basic Skills

๐Ÿ”— https://www.edx.org/learn/c-programming/codio-c-programming-basic-skills

13. Computer Science for Web Programming

๐Ÿ”— https://www.edx.org/learn/computer-science/harvard-university-cs50-s-introduction-to-computer-science

14. Introduction to Computer Science and Programming

๐Ÿ”— https://www.edx.org/learn/computer-science/tokyo-institute-of-technology-introduction-to-computer-science-and-programming

15. Introduction to Computer Science and Programming Using Python

๐Ÿ”— https://www.edx.org/learn/computer-programming/massachusetts-institute-of-technology-introduction-to-computer-science-and-programming-7

16. Machine Learning with Python: From Linear Models to Deep Learning

๐Ÿ”— https://www.edx.org/learn/machine-learning/massachusetts-institute-of-technology-machine-learning-with-python-from-linear-models-to-deep-learning

Happy Learning ๐ŸŒŸ
๐Ÿ‘1
๐—ฆ๐—ค๐—Ÿ ๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„ ๐—ค๐˜‚๐—ฒ๐˜€๐˜๐—ถ๐—ผ๐—ป๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—™๐—ฟ๐—ฒ๐—ฒ ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€๐Ÿ”ฅ๐Ÿ”ฅ

https://www.linkedin.com/posts/mandarmpatil_sql-interview-questions-book-activity-7134126086069571584-A9cz
๐—ฆ๐—ค๐—Ÿ ๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„ ๐—ค๐˜‚๐—ฒ๐˜€๐˜๐—ถ๐—ผ๐—ป๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—”๐˜€๐—ฝ๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜๐˜€ (๐—˜๐—ป๐˜๐—ฟ๐˜†-๐—Ÿ๐—ฒ๐˜ƒ๐—ฒ๐—น) ๐Ÿ“Š

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
๐Ÿ‘1
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
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
๐Ÿ‘1
๐—œ๐—•๐—  ๐—ฎ๐—ป๐—ฑ ๐— ๐—ฒ๐˜๐—ฎ ๐—ผ๐—ณ๐—ณ๐—ฒ๐—ฟ๐—ถ๐—ป๐—ด ๐—ช๐—ฒ๐—ฏ ๐——๐—ฒ๐˜ƒ๐—ฒ๐—น๐—ผ๐—ฝ๐—บ๐—ฒ๐—ป๐˜ ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—ฒ๐˜ƒ๐—ฒ๐—ฟ๐˜†๐—ผ๐—ป๐—ฒ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

https://www.linkedin.com/posts/mandarmpatil_sql-handwritten-notes-activity-7134367669620752384-qvpQ
๐—š๐—ถ๐˜ ๐—–๐—ต๐—ฒ๐—ฎ๐˜ ๐—ฆ๐—ต๐—ฒ๐—ฒ๐˜ ๐—ฎ๐—ป๐—ฑ ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

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