PrepNPlaced – Telegram

PrepNPlaced

@dataanalyticsbuddy

26.6K 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

About

Blog

Apps

Platform

26.6K subscribers

Hey hustlers, Very good morning, and I hope you're doing well.

Welcome Day 49 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge.

Today we'll go through basics of SQL and Database and Relational Database concepts.

Use below tutorials for your learning 👇

https://www.w3schools.com/sql/

https://youtu.be/iOW5EWZSQPU?si=4B13Hxx6IHG8d0_r

I look forward to your responses.

Till then keep learning and keep exploring 🙌

Those who are new in this community this is challenge of becoming working Data Analyst that we have started and if you want to learn about this challenge then check all ping message for your reference.

SQL is a standard language for storing, manipulating and retrieving data in databases.

👍3❤1👏1

2.18K views05:00

PrepNPlaced pinned «Hey hustlers, Very good morning, and I hope you're doing well. Welcome Day 49 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge. Today we'll go through basics of SQL and Database and Relational Database concepts. …»

05:00

trivago team as a Data Scientist

https://careers.trivago.com/apply/?gh_jid=7603660002

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

👉Telegram Channel: https://t.me/dataanalyticsbuddy

All the best 👍👍

Careers at trivago

Open Positions | Careers at trivago

Do you want to help us shape the future of the travel industry? Check out our open positions.

👍1👏1

1.64K views10:10

Company – Buddha Education Association Incorporation
Role – Machine Learning Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/details/work-from-home-part-time-machine-learning-internship-at-buddha-education-association-incorporation1724316669

Machine Learning Work From Home Part Time Internship at Buddha Education Association Incorporation

Selected intern's day-to-day responsibilities include:

1. Work on applying and developing ML and AI technologies to solve tech challenges

2. Work on cleaning, managing, extracting, and pre-processing data from various sources having different formats…

👏1

1.45K views10:11

Company – Data Se
Role – Data Analytics
Exp. – Fresher
Apply Here – https://internshala.com/internship/details/work-from-home-data-analytics-internship-at-data-se1724388073

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

Data Analytics Work From Home Internship at Data Se

Selected intern's day-to-day responsibilities include:

1. Data processing, cleaning, calculation for various ecommerce clients

2. Advanced data analysis and insight generation to take strategic decisions

👍1

1.48K views10:11

Company – Work Store Limited
Role – Data Analyst
Exp. – 1-5 yrs
Apply Here – https://www.linkedin.com/jobs/view/4005040365

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

Work Store Limited hiring Data Analyst in Mumbai, Maharashtra, India | LinkedIn

Posted 12:09:27 PM. Job Overview:
As the 'MIS' / 'Data Analyst', you'll design, develop, and maintain impactful…See this and similar jobs on LinkedIn.

👍1

1.34K views10:12

Company – Oil and Gas Job Search Ltd
Role – Junior Business Analyst
Exp. – 1+ yrs
Apply Here – https://oilandgasjobsearch.com/jobs/other-jobs/911905

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

Oilandgasjobsearch

Junior Business Analyst

Description - External Role: Business Analyst: Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions . Lead...

👏1

1.38K views10:12

Company – Siemens Energy
Role – Data Scientist
Exp. – 1+ yrs
Apply Here – https://jobs.siemens-energy.com/en_US/Jobs/FolderDetail?sourceType=PREMIUM_POST_SITE&utm_medium=jobboard&source=LinkedIn&folderId=262500&utm_source=linkedin

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

👍3

1.42K views10:12

Company – United Airlines
Role – Analyst - Data Scientist
Exp. – 2+ yrs
Apply Here – https://careers.united.com/us/en/job/UAIUADUSGGN00001556EXTERNALENUSTALEO/Analyst-Data-Scientist

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

👍1👏1

1.55K views10:13

Company – IndusInd Bank
Role – Data Scientist / Business Analyst
Exp. – 2-4 yrs
Apply Here – https://jigya.co.in/jobs-apprenticeships/indusind-bank/data-scientist-business-analyst-2

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

👍2👏1

1.79K views10:13

Company – NetSPI
Role – Junior Data Engineer
Exp. – 1+ yrs

Apply Here – https://netspi.rec.pro.ukg.net/NET1500NSPI/JobBoard/944d4e9c-f503-4e74-bb8b-f79214e2a5e1/OpportunityDetail?opportunityId=7edc0827-24bf-4c9b-8b03-33c7156c7796

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

👍2

2.02K views10:14

Swiss Re is hiring for Data Analytics Engineer
Experience: 0 - 1 year's

Apply here:
https://careers.swissre.com/job/Hyderabad-Data-Analytics-Engineer-TG/1111760001/

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

👉Telegram Channel: https://t.me/dataanalyticsbuddy

All the best 👍👍

👏1

1.97K views17:11

Kautex is hiring for the role of AI Enginee- Freshers (2024)
Experience: 0 - 1 year's

Apply here: https://unstop.com/jobs/engineer-i-ai-kautex-1140360

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

All the best 👍👍

Join - Kautex as a Engineer I – AI | 1140360 // Unstop

Become a Engineer I – AI at Kautex and get the best salary in the industry. Click the link to apply now and advance your career. | 2024 | 1140360

👍2

2.07K views17:12

𝐊𝐢𝐧𝐝𝐧𝐞𝐬𝐬 𝐈𝐬𝐧'𝐭 𝐖𝐞𝐚𝐤𝐧𝐞𝐬𝐬: 𝐈𝐭'𝐬 𝐚 𝐒𝐢𝐠𝐧 𝐨𝐟 𝐒𝐭𝐫𝐞𝐧𝐠𝐭𝐡 💪 🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_kindnessisstrength-bethechange-spreadpositivity-activity-7233299618023841792-YKoU

Mandar Patil on LinkedIn: #kindnessisstrength #bethechange #spreadpositivity #kindnessmatters…

Why 'Being Too Nice' is the Biggest Lie You’ve Been Told 😡

Ever been told "don't be so nice"? That kindness is a sign of weakness?

Well, let me share a…

👍1🔥1

1.77K views02:39

Hey hustlers, Very good morning, and I hope you're doing well.

Welcome Day 50 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge.

Today we'll go through basics of SQL commands

Use below tutorials and guide for your learning 👇

𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱𝗶𝗻𝗴 𝐒𝐐𝐋 𝐂𝐨𝐦𝐦𝐚𝐧𝐝 𝐓𝐲𝐩𝐞𝐬 𝗮𝗻𝗱 𝘁𝗵𝗲𝗶𝗿 𝘂𝘀𝗲 𝗰𝗮𝘀𝗲𝘀:

1.𝐃𝐃𝐋 (𝐃𝐚𝐭𝐚 𝐃𝐞𝐟𝐢𝐧𝐢𝐭𝐢𝐨𝐧 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞): DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.

𝐂𝐫𝐞𝐚𝐭𝐞: Used to create database objects like tables, indexes, and views.
𝐀𝐥𝐭𝐞𝐫: Modifies the structure of an existing database object.
𝐃𝐫𝐨𝐩: Deletes database objects.
𝐓𝐫𝐮𝐧𝐜𝐚𝐭𝐞: Removes all records from a table, but not its structure.
𝐑𝐞𝐧𝐚𝐦𝐞: Changes the name of a database object.

2. 𝐃𝐌𝐋 (𝐃𝐚𝐭𝐚 𝐌𝐚𝐧𝐢𝐩𝐮𝐥𝐚𝐭𝐢𝐨𝐧 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞): DML commands are used to modify the database. It is responsible for all form of changes in the database.

𝐈𝐧𝐬𝐞𝐫𝐭: Adds new records to a table.
𝐔𝐩𝐝𝐚𝐭𝐞: Modifies existing records in a table.
𝐃𝐞𝐥𝐞𝐭𝐞: Removes records from a table.
𝐌𝐞𝐫𝐠𝐞: Inserts or updates records conditionally.

3. 𝐃𝐂𝐋 (𝐃𝐚𝐭𝐚 𝐂𝐨𝐧𝐭𝐫𝐨𝐥 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞): DCL commands are used to grant and take back authority from any database user.

𝐆𝐫𝐚𝐧𝐭:: Provides users with access privileges.
𝐑𝐞𝐯𝐨𝐤𝐞: Removes access privileges from users.

4.𝐓𝐂𝐋 (𝐓𝐫𝐚𝐧𝐬𝐚𝐜𝐭𝐢𝐨𝐧 𝐂𝐨𝐧𝐭𝐫𝐨𝐥 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞): TCL commands can only use with DML commands like INSERT, DELETE and UPDATE only.

𝐂𝐨𝐦𝐦𝐢𝐭: Saves the changes made in a transaction.
𝐑𝐨𝐥𝐥𝐛𝐚𝐜𝐤: Reverts the changes made in a transaction.
𝐒𝐚𝐯𝐞 𝐏𝐨𝐢𝐧𝐭: Sets a save point within a transaction to which you can roll back.

5. 𝐃𝐐𝐋 (𝐃𝐚𝐭𝐚 𝐐𝐮𝐞𝐫𝐲 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞): DQL is used to fetch the data from the database.

𝐂𝐨𝐦𝐦𝐚𝐧𝐝𝐬:
𝐒𝐞𝐥𝐞𝐜𝐭: Retrieves data from the database.

Tutorial for SQL learning:
https://www.w3schools.com/sql/

https://youtu.be/iOW5EWZSQPU?si=4B13Hxx6IHG8d0_r

I look forward to your responses.

Till then keep learning and keep exploring 🙌

Those who are new in this community this is challenge of becoming working Data Analyst that we have started and if you want to learn about this challenge then check all ping message for your reference.

SQL is a standard language for storing, manipulating and retrieving data in databases.

👍5❤1

1.96K views06:09

PrepNPlaced pinned «Hey hustlers, Very good morning, and I hope you're doing well. Welcome Day 50 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge. Today we'll go through basics of SQL commands Use below tutorials and guide for your…»

06:09

Company – CodeInterns
Role – Data Science Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/work-from-home-part-time-data-science-internship-at-codeinterns1724507862

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

Data Science Work From Home Part Time Internship at CodeInterns

Are you passionate about data analysis, machine learning, and software development? Join us at CodeInterns as a Data Science intern and gain hands-on experience in the cutting-edge field of data science. As a valued member of our team, you will have the opportunity…

👍2

1.45K views08:27

Company – Turing
Role – Delivery Data Analyst
Exp. – Fresher
Apply Here – https://job-boards.greenhouse.io/turingportal/jobs/5272538004

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

👏1

1.63K views08:28

Company – Discoveries Quintessential
Role – Data Analyst
Exp. – 2+ yrs
Apply Here – https://www.linkedin.com/jobs/view/4006951935

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

👍1

1.46K views08:28

Company – AKS ProTalent
Role – Data or Business Analyst
Exp. – 1+ yrs
Apply Here – https://www.linkedin.com/jobs/view/4006702411

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

👍1

1.36K views08:29

Company – Infineon Technologies
Role – Data Science
Exp. – 1-3 yrs
Apply Here – https://www.infineon.com/cms/en/careers/jobsearch/jobsearch/HRC0909666-Senior-Specialist-Data-Science/

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

👉Telegram Link: https://t.me/dataanalyticsbuddy

Senior Specialist - Data Science - Infineon Technologies

Lead / support end-to-end data science projects include cleaning of source data, working with large data sets

👏1

1.45K views08:29