Cracked Myntra as Data Analyst with 1 Year Experience

This podcast is with Saurabh who recently cracked data analyst interview for Myntra . We will discuss following points :

1- How to get calls from product based companies.
2- Resources he used for preparations.
3- Interview questions
4- Resume preparation
5- What else apart from resume

Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #dataengineer

[ankitbansal]

Please like the video. Here are the resources discussed

[shradhaoza]

Luck Really Matters in Corporate. Some may face tough questions while others are Lucky.

[harshkumargupta]

First of all Congrats to Saurabh Prajapat for his achievement. 🎉🎉

Thank you Ankit sir for you valuable content. It is helping me personally in upskilling myself as a fresher. Hopefully i will get an entry in the data field soon.

[kanchankumar]

Great start, looking forward to more such podcasts 🎉🎉

[off]

Hi Ankit, I also want to have this conversation with you and help others in their sql preparation. 3 months back, I cracked a job. I solved every question that you post across different platforms. Thank you for creating a great content.

[livelovelaugh]

Thank you Sir. Please continue this type of podcast 🙏

[bhuralal]

If 100 days of SQL is hard for you I think bro took some help during the interview.

[NavneetKaur-]

Thank you for bringing up this podcast 😊 It's really helpful

[grishmagajjar]

what if there is no clear job description. so how can we make a resume ATS friendly in this situation?

[vansh]

please provide a general link for the template. this is restricted as he changes his resume with this link. this only open with the same account which he used.

[learnearn]

Thank you so much for knowledge share, , really Informative and helpful

[vijaygupta]

Thanks for making valuable podcast.

Please help to make more video like that

[kalai]

I have a doubt. When I try to apply through the website, I can see employee code in the job application which is a required field. What should I fill there? How to apply

[pritammondal]

Hi Ankit, the resume template link is not opening. Request you to please reshare

[sravanigurram]

Hey Ankit, Requesting you to help us the process in resume preparation through overleaf

[AmanBhattarai-xxyb]

What channel name he shared for rca/ business case study

[rishitiwari]

maine bi diya tha iska interview mujhse to kuch jyada hi hard poocha tha

[bhavaniallu]

do we need to purchase 100 days of sql? if yes then pls suggest someone as how can i go forward with that

[DA_Guy]

Sir, kindly share his linkdin profile link

[amalkrishna]

Is he really hired? Seems he is reading everything from the screen