Honeywell hiring Data Analyst

Apply link: https://careers.honeywell.com/en/sites/Honeywell/job/HRD264209?mode=location

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Target hiring Data Analyst

Apply link: https://corporate.target.com/job/id/R0000393451?utm_source=LinkedIn%28Organic%29&utm_medium=Organic&utm_campaign=Feed%7CAll+Locations%7CAll+Roles&source=srm_linkedin_org

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Deloitte is hiring!
Position: Associate Analyst
Qualification: Any Graduate or Post-Graduate, MBA
Salary: 5 - 8.6 LPA (Expected)
Experience: Freshers (0 to 1.5 years)
Location: Hyderabad, India

📌Apply Now: https://usijobs.deloitte.com/en_US/careersUSI/JobDetail/USI-EH26-EA-Talent-Services-Learning-Operations-Associate-Analyst/301098

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Mastercard is hiring!
Position: Business Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 6.3 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: Pune, India

📌Apply Now: https://careers.mastercard.com/us/en/job/R-248434/Business-Analsyt-I

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Amazon is hiring Business Analyst 🚀

Experience : 1 Year
Location : Bangalore

Apply link : https://www.amazon.jobs/jobs/2938031/business-analyst?cmpid=SPLICX0248M&utm_source=linkedin.com&utm_campaign=cxro&utm_medium=social_media&utm_content=job_posting&ss=paid

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Collegedunia is hiring Product Analyst 🚀

Qualification : Bachelor's degree
Experience : Freshers / Experienced
Location : Gurugram

Apply link : https://www.linkedin.com/jobs/view/4241209451

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

GlobalLogic is hiring Associate Analyst 🚀

Experience : Freshers
Location : Hyderabad

Apply link : https://www.globallogic.com/careers/associate-analyst-irc266833/?utm_source=LinkedIn&utm_medium=jobboard&utm_campaign=career

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

𝗠𝗼𝘀𝘁 𝗔𝘀𝗸𝗲𝗱 𝗦𝗤𝗟 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗮𝘁 𝗠𝗔𝗔𝗡𝗚 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀🔥🔥

1. How do you retrieve all columns from a table?

SELECT * FROM table_name;


2. What SQL statement is used to filter records?

SELECT * FROM table_name
WHERE condition;

The WHERE clause is used to filter records based on a specified condition.


3. How can you join multiple tables? Describe different types of JOINs.

SELECT columns
FROM table1
JOIN table2 ON table1.column = table2.column
JOIN table3 ON table2.column = table3.column;

Types of JOINs:

1. INNER JOIN: Returns records with matching values in both tables

SELECT * FROM table1
INNER JOIN table2 ON table1.column = table2.column;

2. LEFT JOIN (or LEFT OUTER JOIN): Returns all records from the left table and matched records from the right table. Unmatched records will have NULL values.

SELECT * FROM table1
LEFT JOIN table2 ON table1.column = table2.column;

3. RIGHT JOIN (or RIGHT OUTER JOIN): Returns all records from the right table and matched records from the left table. Unmatched records will have NULL values.

SELECT * FROM table1
RIGHT JOIN table2 ON table1.column = table2.column;

4. FULL JOIN (or FULL OUTER JOIN): Returns records when there is a match in either left or right table. Unmatched records will have NULL values.

SELECT * FROM table1
FULL JOIN table2 ON table1.column = table2.column;


4. What is the difference between WHERE and HAVING clauses?

WHERE: Filters records before any groupings are made.

SELECT * FROM table_name
WHERE condition;

HAVING: Filters records after groupings are made.

SELECT column, COUNT(*)
FROM table_name
GROUP BY column
HAVING COUNT(*) > value;


5. How do you count the number of records in a table?

SELECT COUNT(*) FROM table_name;

This query counts all the records in the specified table.

6. How do you calculate average, sum, minimum, and maximum values in a column?

Average: SELECT AVG(column_name) FROM table_name;

Sum: SELECT SUM(column_name) FROM table_name;

Minimum: SELECT MIN(column_name) FROM table_name;

Maximum: SELECT MAX(column_name) FROM table_name;


7. What is a subquery, and how do you use it?

Subquery: A query nested inside another query

SELECT * FROM table_name
WHERE column_name = (SELECT column_name FROM another_table WHERE condition);




Till then keep learning and keep exploring 🙌

BlackRock is hiring!
Position: Data Analyst
Qualification: Bachelor's Degree
Salary: 6 - 15 LPA (Expected)
Experience: Entry Level
Location: Bengaluru, India (Hybrid)

📌Apply Now: https://careers.blackrock.com/job/bengaluru/data-management-analyst/45831/81540166224

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

NielsenIQ is hiring!
Position: Junior Associate, Power BI
Qualification: Bachelor’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Entry Level
Location: Pune, India

📌Apply Link: https://jobs.smartrecruiters.com/NielsenIQ/744000063280269-jr-associate-bi

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Fam is hiring Product Analyst Intern 🚀

Experience : Freshers
Location : Bangalore

Apply link : https://jobs.lever.co/fampay/8838779b-4eb1-4150-8fa2-a4cd29cadcbe/apply?lever-source=LinkedIn

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Zelestra is hiring Junior Data Scientist 🚀

Qualification : Bachelor's degree
Experience : 0-2 Years
Location :; Gurugram

Apply link : https://careers.solarpack.es/job/Haryana-Junior-Data-Scientist/1162773055/

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Airtel is hiring Business Analyst 🚀

Experience with Excel ✅
Location : Gurugram

Apply link : https://www.linkedin.com/jobs/view/4241888047

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Roblox is hiring Business Analyst 🚀

Experience : 2+ Years
Location : Gurugram

Apply link : https://careers.roblox.com/jobs/6754913?gh_jid=6754913&gh_src=da92d0c91

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Razorpay hiring Analyst - Risk Management

Apply link: https://job-boards.greenhouse.io/razorpaysoftwareprivatelimited/jobs/4573732005

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍