- Видео 68
- Просмотров 30 334
DATA KE DAKU
Индия
Добавлен 1 мар 2024
👦 Fresher To Business Analyst 💼 In OYO - Non IT Background 🔥 | Podcasts
Hi Guys, In this video we are hosting podcast with Manpreet Kaur, who is currently working as Business Analyst in OYO
For registration for mentorship or mock interviews and resume review fill out a Google form --
docs.google.com/forms/d/e/1FAIpQLSdQOycRS54cjSnwzUQGJTyt1PZOJ-unXatS6uytbyqubd2nFw/viewform?usp=sf_link
Also for any personal mentorship, you can follow and connect with me on LinkedIn too
www.linkedin.com/in/mnansngh/
Manpreet Kaur's Linkedin
www.linkedin.com/in/manpreet-kour-70a6ba24b/
For Short Learning content follow me on Instagram too:
data_ke_daku
Do Like, Share, and Subscribe for more such videos.
For registration for mentorship or mock interviews and resume review fill out a Google form --
docs.google.com/forms/d/e/1FAIpQLSdQOycRS54cjSnwzUQGJTyt1PZOJ-unXatS6uytbyqubd2nFw/viewform?usp=sf_link
Also for any personal mentorship, you can follow and connect with me on LinkedIn too
www.linkedin.com/in/mnansngh/
Manpreet Kaur's Linkedin
www.linkedin.com/in/manpreet-kour-70a6ba24b/
For Short Learning content follow me on Instagram too:
data_ke_daku
Do Like, Share, and Subscribe for more such videos.
Просмотров: 1 357
Видео
Fresher To Data Engineer Roadmap- 2024 🔥 | Must watch
Просмотров 588Месяц назад
Hi Guys, In this video we will discuss the end-to-end data engineering roadmap for fresher and mid-level experience, giving you an edge and focused topics to prepare. For registration for mentorship or mock interviews and resume review fill out a Google form docs.google.com/forms/d/e/1FAIpQLSdQOycRS54cjSnwzUQGJTyt1PZOJ-unXatS6uytbyqubd2nFw/viewform?usp=sf_link Also for any personal mentorship, ...
Leetcode 1517 - Find Users With Valid E-Mails🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 1572 месяца назад
In this Day-50 video, we will discuss Leetcode SQL 1517 - Find Users With Valid E-Mails 🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/find-users-with-valid-e-mails/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/...
Leetcode 1327 - List the Products Ordered in a Period🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 652 месяца назад
In this Day - 49 video, we will discuss Leetcode SQL 1327 - List the Products Ordered in a Period🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/list-the-products-ordered-in-a-period/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google fo...
Leetcode 1484 - Group Sold Products By The Date🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 5962 месяца назад
In this Day - 48 video, we will discuss Leetcode SQL 1484 - Group Sold Products By The Date🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/group-sold-products-by-the-date/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms...
Leetcode 176 - Second Highest Salary🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 2,1 тыс.2 месяца назад
In this Day - 47 video, we will discuss Leetcode SQL 176 - Second Highest Salary🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/second-highest-salary/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/1FAI...
Leetcode 196 - Delete Duplicate Emails🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 2 тыс.2 месяца назад
In this Day - 46 video, we will discuss Leetcode SQL 196 - Delete Duplicate Emails🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/delete-duplicate-emails/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/...
Leetcode 1527 - Patients With a Condition🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 732 месяца назад
In this Day - 45 video, we will discuss Leetcode SQL 1527 - Patients With a Condition🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/patients-with-a-condition/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms...
Leetcode 1667 - Fix Names in a Table🔥 | 50 Days Challenge | Data Analyst ✅.
Просмотров 362 месяца назад
In this Day - 44 video, we will discuss Leetcode 585 - Investments in 2016 🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/fix-names-in-a-table/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/1FAIpQLSdQOycRS54cjSnw...
Leetcode 185 - Department Top Three Salaries🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 602 месяца назад
In this Day-43 video, we will discuss Leetcode 185 - Department Top Three Salaries 🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/department-top-three-salaries/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/for...
Leetcode 585 - Investments in 2016🔥 | 50 Days Challenge | Data Analyst ✅.
Просмотров 1042 месяца назад
In this Day - 42 video, we will discuss Leetcode 585 - Investments in 2016 🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/investments-in-2016/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/1FAIpQLSdQO...
Leetcode 602 - Friend Requests II: Who Has the Most Friends🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 1012 месяца назад
In this Day - 41 video, we will discuss Leetcode SQL 602 - Friend Requests II: Who Has the Most Friends 🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill ou...
Leetcode 1321 - Restaurant Growth🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 892 месяца назад
In this Day - 40 video, we will discuss Leetcode SQL 1321 - Restaurant Growth🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/restaurant-growth/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/1FAIpQLSdQOycRS54cjSnwz...
Leetcode 1341 - Movie Rating🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 532 месяца назад
In this Day - 39 video, we will discuss Leetcode SQL 626 - Exchange Seats🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/movie-rating/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/1FAIpQLSdQOycRS54cjSnwzUQGJTyt1P...
Leetcode 626 - Exchange Seats🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 332 месяца назад
In this Day - 38 video, we will discuss Leetcode SQL 626 - Exchange Seats🔥, going to solve and pass the test cases, Below is the Leet code question URL attached to this. Leetcode Question👇 leetcode.com/problems/exchange-seats/description/?envType=study-plan-v2&envId=top-sql-50 For registration for mentorship or mock interviews, fill out a Google form docs.google.com/forms/d/e/1FAIpQLSdQOycRS54c...
Leetcode 1978 - Employees Whose Manager Left the Company🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 912 месяца назад
Leetcode 1978 - Employees Whose Manager Left the Company🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode 1907 - Count Salary Categories🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 1262 месяца назад
Leetcode 1907 - Count Salary Categories🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode 1204 - Last Person to Fit in the Bus🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 772 месяца назад
Leetcode 1204 - Last Person to Fit in the Bus🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode 1164 - Product Price at a Given Date🔥| 50 Days Challenge | Data Analyst ✅
Просмотров 1552 месяца назад
Leetcode 1164 - Product Price at a Given Date🔥| 50 Days Challenge | Data Analyst ✅
Leetcode 180 - Consecutive Numbers🔥| 50 Days Challenge | Data Analyst ✅.
Просмотров 792 месяца назад
Leetcode 180 - Consecutive Numbers🔥| 50 Days Challenge | Data Analyst ✅.
Leetcode 610 - Triangle Judgement🔥| 50 Days Challenge | Data Analyst ✅.
Просмотров 1282 месяца назад
Leetcode 610 - Triangle Judgement🔥| 50 Days Challenge | Data Analyst ✅.
Leetcode SQL 1789 - Primary Department for Each Employee🔥| 50 Days Challenge | Data Analyst ✅
Просмотров 682 месяца назад
Leetcode SQL 1789 - Primary Department for Each Employee🔥| 50 Days Challenge | Data Analyst ✅
Leetcode SQL 1731 - The Number of Employees Which Report to Each Employee🔥| 50 Days Challenge
Просмотров 1403 месяца назад
Leetcode SQL 1731 - The Number of Employees Which Report to Each Employee🔥| 50 Days Challenge
Leetcode SQL 1045 - Customers Who Bought All Products 🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 723 месяца назад
Leetcode SQL 1045 - Customers Who Bought All Products 🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode SQL 619 - Biggest Single Number 🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 643 месяца назад
Leetcode SQL 619 - Biggest Single Number 🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode SQL 1729 - Find Followers Count 🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 643 месяца назад
Leetcode SQL 1729 - Find Followers Count 🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode SQL 596 - Classes More Than 5 Students 🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 643 месяца назад
Leetcode SQL 596 - Classes More Than 5 Students 🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode SQL 1070 - Product Sales Analysis III 🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 1363 месяца назад
Leetcode SQL 1070 - Product Sales Analysis III 🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode SQL 1141 - User Activity for the Past 30 Days I 🔥 | 50 Days Challenge | Data Analyst ✅
Просмотров 1653 месяца назад
Leetcode SQL 1141 - User Activity for the Past 30 Days I 🔥 | 50 Days Challenge | Data Analyst ✅
Leetcode SQL 2356 - Number of Unique Subjects Taught by Each Teacher 🔥 |50 Days Challenge
Просмотров 1673 месяца назад
Leetcode SQL 2356 - Number of Unique Subjects Taught by Each Teacher 🔥 |50 Days Challenge
Nice and informative
Get going grllll🤩✨
Very informative 👏
Kudos Manpreet!!!!!!🎉 Wishing you a great worklife ahead
"Congratulations, Manpreet. Please help us as well."
Informative 🙌
Great
Great video thank you 👍
how to prepare for interview ?
Book free mentorship 1-1, Google form in description
Bhai mere paas MS EXCEL, SQL, and POWER BI ka knowledge hai have built a few portfolio projects. What other hard skills do I need to learn more if I am not getting any internships? What to do please suggest.
Try making projects and increase your data size
love you pajji 🧡🧡
Informative
Girll🔥🔥🔥🔥🔥
Sir background pharmacy ka hai toh interviewer mujhe kyu lega ?
The guest in this video is of chemical background, but she has been selected, but behind there are lot of projects and internships.
Great video thanks 🤟
Great video
Nice🎉
Very informative ! will help a lot <3
Great, Inspiring.
Lovely talking with you..All the best to everyone preparing
Same Here Manpreet!
Bhai love your videos...keep bringing great stuff
Avneesh sir , 3 years ka gap ha. After btech
Keep working.
Bhai like share ke liye bhit acha bola hai
Hi Paaji, I am planning to go with Snowflakes not with Azure/AWS/GCP. Is it fine?
Snowflake is a datawarehouse, And rest is popular cloud providers, better to take AWS or Azure with Snowflake, will give fuel to your projects and Cv
Please keep making videos
Great 👍
On point roadmap.
Nice explanation & very Informative video for freshers & experienced folks🫡
Followed the full series and it was really helpful. Please make a similar series for Pyspark questions also using dataframes and sparkSQL.
Bhai Thoda share karo video...watch hours badehenge tabhi bana paunga
Great video bhaiya!! bhaiya please make video on resume building for freshers for data engineering.
Good vide boss
nice work
Whatsaap grp kese join kre
Video mein bataya hai
Other Approach: select c.class from (select class,count(student) as cnt from courses group by class) c where c.cnt>=5 Note: Solved using subquery so it will be less efficient.
Using window function(MySql) select product_id,year as first_year, quantity, price from (select *,min(year) over(partition by product_id) as first from sales) s where year=s.first Thank You for this series. It helps in developing approach towards the problem. .
🎉🎉
when we do group by 1 ?
Group by 1 is simply group by column name, the first column in select statement is only referring there as group by 1
post some video on full projects for data analysis how to work on them step by step guidance
Sure
good work
Why you used left join specifically here? And can we cange the condition to d2. PointA > d1. PointB
See here the base table we are referring to table d1, so let's assume any of the records not having duplicates will be missed out so thats why left join, additionally on condition, are you asking on join condition or where filter?
Done
First
thank you for this important videos
Please make a video on joins also
Sure
helpfulll
पाजी राम राम
bhai mujeh ye samjh nahi aata kya karna shai hoga ..........oracleSQL ya mySQL maine pl/sql oracle mei sikhi hai to kya karu? aap batao paaji
Bhai aap sql ka Logic banana sikho rather than syntax and platform, oracle MySQL postgres sab chalega
Hello sir kya aap dataford ke SQL solution ka bhi series start karenge it will be very helpful .
Data ford ki bhi karenge…ap url daal doh
❤
thank you