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
๐—™๐—ฟ๐—ฒ๐˜€๐—ต๐—ฒ๐—ฟ๐˜€ ๐—ต๐—ถ๐—ฟ๐—ถ๐—ป๐—ด ๐—ณ๐—ผ๐—ฟ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜, ๐——๐—ฎ๐˜๐—ฎ ๐—ฆ๐—ฐ๐—ถ๐—ฒ๐—ป๐—ฐ๐—ฒ ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

https://www.linkedin.com/posts/mandarmpatil_dataanalystjobs-fresherjobs-careeropportunities-activity-7133817594922348544-iVKp
Data Science Opportunities

1. Company- Pinnacle
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3768665803

2. Company- Infosys
Role- Data Engineer
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3755979167

3. Company- Angel One
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3767398067

4. Company- bp
Role- Sr. Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3771889370

5. Company- Jade Global
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3748104320

6. Company- Virtusa
Role- Data Engineer
Experience- 1-2 years
Apply now- https://www.linkedin.com/jobs/view/3771990483

7. Company- Honeywell
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3767373265

8. Company- Crossover
Role- Data Scientist
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3766356640

9.Company- LTIMindtree
Role- Data Engineer
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3764386930

10. Company- Trane Technologies
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3748176877

11. Quantiphi hiring Senior Data Engineer
Experience: 2 Year

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


Company Name: MSD
Role: Data & Analytics Intern
Batch : 2024 passouts

https://jobs.msd.com/gb/en/job/MSD1GBR269314ENGB/Data-Analytics-Intern-Data-Solutions
Software Opportunities

Thomson Reuters is hiring for Software Engineer
Expected CTC: 8-15 LPA
Location: Bangalore

Apply: https://careers.thomsonreuters.com/us/en/job/THTTRUUSJREQ170211EXTERNALENUS/software-Engineer
Company Name: Apple
Role: Software Engineer

Expected CTC: 24-37 LPA

For 2024/2023/2022 Grads

Apply: https://cuvette.tech/app/other-jobs/655ee77e7a05717973aa1200
Company Name: Kroll
Role: SDE Intern
Batch : 2023 & 2024 passouts
Location: Hyderabad

Apply Link: https://careers.kroll.com/job/-/-/25499/57628069184
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