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 👍👍

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 👍👍

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

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

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.

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

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

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

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

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

Company – Avient Corporation
Role – Data Engineer
Exp. – 2+ yrs
Apply Here – https://avient.referrals.selectminds.com/jobs/data-engineer-7208

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

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

Company – Cynosure Corporate Solutions
Role – Data Scientist
Exp. – 2-6 yrs
Apply Here – https://www.shine.com/jobs/data-scientist/cynosure-corporate-solutions/15224714

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

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

Company – Applied Bell Curve
Role – Data Scientist
Exp. – 2 yrs
Apply Here – https://www.linkedin.com/jobs/view/4004931230

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

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

Company – American Express
Role – Analyst-Data Science
Exp. – 0-4 yrs
Apply Here – https://aexp.eightfold.ai/careers/job/23701696

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

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

Internship Opportunity

Company – DeepThought Edutech Ventures Private Limited
Role – Data Analytics Internship
Exp. – Fresher
Apply Here – https://internshala.com/internship/details/data-analytics-internship-in-hyderabad-at-deepthought-edutech-ventures-private-limited1724564352

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

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

All the best 👍👍

Avalara is hiring for Associate Analyst
Experience: 0 -1 year's
Expected Salary: 3-6 LPA
Apply here:
https://careers.avalara.com/jobs/13677


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


All the best 👍👍

Genpact is hiring Associate Data Analytics
Experience: 0 to 1 year
Qualification: BE/ Btech
Batch: 2023,2024,2025
-Location: Jaipur

Apply: https://genpact.taleo.net/careersection/sgy_external_career_section/jobdetail.ftl?src=DS-10971&job=1393036


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


All the best 👍👍

🚨 Important Update 🚨

Hello, everyone! 👋

Unfortunately, with the recent arrest of Telegram founder Pavel Durov 😔, there's a lot of uncertainty about the platform's future.

To stay connected and keep our community active, please join my WhatsApp channel as well 📲

Here’s the link to join and do share with others: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

𝐇𝐨𝐰 𝐭𝐨 𝐦𝐚𝐤𝐞 𝐀𝐓𝐒 𝐅𝐫𝐢𝐞𝐧𝐝𝐥𝐲 𝐑𝐞𝐬𝐮𝐦𝐞 𝐟𝐫𝐨𝐦 𝐒𝐜𝐫𝐚𝐭𝐜𝐡🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_ats-friendly-resume-making-guide-activity-7233661941989146624-hBL0

Are Your Certifications Worthless on Your Resume? 🌟

I've seen many people, myself included, adding certifications from various platforms to their
resumes. But when it comes to standing out during job opportunities, we need certifications that hold significant industry value. 🏆

After completing numerous certifications (check out my LinkedIn profile for proof!), I realized that certifications from well-known platforms offer the best value. These platforms not only provide knowledge but also rigorously test our understanding through exams, ensuring we meet high standards.

🔍 Why Coursera Plus is a Game-Changer:

Coursera Plus offers an incredible opportunity for skill expansion and career growth:

✅ 50% off your first month for unlimited access to over 7,000 courses from top universities and
companies like IBM, Google, Microsoft, and Vanderbilt.

✅ Whether you're into cybersecurity, data analytics, or any other field, this is your chance to gain new skills and boost your confidence.

✅ 95% of learners on Coursera report personal benefits, from increased confidence to a sense of accomplishment.

📅 Offer valid until August 9, 2024. (Note: Not available in India)

Let’s take charge of our careers together!

🔗 Sign Up for Coursera Plus: https://www.coursera.org/courseraplus/special/evergreenfifty