PrepNPlaced
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
๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐—œ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„ ๐—ค๐˜‚๐—ฒ๐˜€๐˜๐—ถ๐—ผ๐—ป๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—˜๐—ป๐˜๐—ฟ๐˜†-๐—Ÿ๐—ฒ๐˜ƒ๐—ฒ๐—น ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—™๐—ฟ๐—ฒ๐—ฒ ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€ ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

https://www.linkedin.com/posts/mandarmpatil_power-bi-interview-questions-for-data-analyst-activity-7232937171408625664-fNnS
๐Ÿ”ฅ1
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.
๐Ÿ‘3โค1๐Ÿ‘1
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. โ€ฆยป
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
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
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
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
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
๐Š๐ข๐ง๐๐ง๐ž๐ฌ๐ฌ ๐ˆ๐ฌ๐ง'๐ญ ๐–๐ž๐š๐ค๐ง๐ž๐ฌ๐ฌ: ๐ˆ๐ญ'๐ฌ ๐š ๐’๐ข๐ ๐ง ๐จ๐Ÿ ๐’๐ญ๐ซ๐ž๐ง๐ ๐ญ๐ก ๐Ÿ’ช ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

https://www.linkedin.com/posts/mandarmpatil_kindnessisstrength-bethechange-spreadpositivity-activity-7233299618023841792-YKoU
๐Ÿ‘1๐Ÿ”ฅ1
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.
๐Ÿ‘5โค1
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โ€ฆยป
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
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