DATA KE DAKU
DATA KE DAKU
  • Видео 68
  • Просмотров 30 334
👦 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.
Просмотров: 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

Комментарии

  • @pratyushraj9437
    @pratyushraj9437 Месяц назад

    Nice and informative

  • @janhavisah8229
    @janhavisah8229 Месяц назад

    Get going grllll🤩✨

  • @pragyakumari2867
    @pragyakumari2867 Месяц назад

    Very informative 👏

  • @ayushyadav7302
    @ayushyadav7302 Месяц назад

    Kudos Manpreet!!!!!!🎉 Wishing you a great worklife ahead

  • @nandanisharma8521
    @nandanisharma8521 Месяц назад

    "Congratulations, Manpreet. Please help us as well."

  • @divyanshtaneja1701
    @divyanshtaneja1701 Месяц назад

    Informative 🙌

  • @nikhil3191
    @nikhil3191 Месяц назад

    Great

  • @taranjeet1306
    @taranjeet1306 Месяц назад

    Great video thank you 👍

  • @AdityaKumar-pf7mn
    @AdityaKumar-pf7mn Месяц назад

    how to prepare for interview ?

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh Месяц назад

      Book free mentorship 1-1, Google form in description

  • @writayanpaul701
    @writayanpaul701 Месяц назад

    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.

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh Месяц назад

      Try making projects and increase your data size

  • @AnuragGautam-t5o
    @AnuragGautam-t5o Месяц назад

    love you pajji 🧡🧡

  • @HiteshkumarPanda-i4x
    @HiteshkumarPanda-i4x Месяц назад

    Informative

  • @sonamyadav4266
    @sonamyadav4266 Месяц назад

    Girll🔥🔥🔥🔥🔥

  • @Invisible-hu
    @Invisible-hu Месяц назад

    Sir background pharmacy ka hai toh interviewer mujhe kyu lega ?

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh Месяц назад

      The guest in this video is of chemical background, but she has been selected, but behind there are lot of projects and internships.

  • @coder-fr6ko
    @coder-fr6ko Месяц назад

    Great video thanks 🤟

  • @somyagupta5607
    @somyagupta5607 Месяц назад

    Great video

  • @harshitasingh7413
    @harshitasingh7413 Месяц назад

    Nice🎉

  • @adityatomar9820
    @adityatomar9820 Месяц назад

    Very informative ! will help a lot <3

  • @amanpublic9011
    @amanpublic9011 Месяц назад

    Great, Inspiring.

  • @manpreetkourbg1299
    @manpreetkourbg1299 Месяц назад

    Lovely talking with you..All the best to everyone preparing

  • @nothingtolose682
    @nothingtolose682 Месяц назад

    Bhai love your videos...keep bringing great stuff

  • @kunalbhardwaj1541
    @kunalbhardwaj1541 Месяц назад

    Avneesh sir , 3 years ka gap ha. After btech

  • @vijaygupta7059
    @vijaygupta7059 Месяц назад

    Bhai like share ke liye bhit acha bola hai

  • @hau_hau_happu_singh
    @hau_hau_happu_singh Месяц назад

    Hi Paaji, I am planning to go with Snowflakes not with Azure/AWS/GCP. Is it fine?

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh Месяц назад

      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

  • @vinayakseth353
    @vinayakseth353 Месяц назад

    Please keep making videos

  • @coder-fr6ko
    @coder-fr6ko Месяц назад

    Great 👍

  • @tushitverma2256
    @tushitverma2256 Месяц назад

    On point roadmap.

  • @AnuragGautam-t5o
    @AnuragGautam-t5o Месяц назад

    Nice explanation & very Informative video for freshers & experienced folks🫡

  • @sumitrawall
    @sumitrawall Месяц назад

    Followed the full series and it was really helpful. Please make a similar series for Pyspark questions also using dataframes and sparkSQL.

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh Месяц назад

      Bhai Thoda share karo video...watch hours badehenge tabhi bana paunga

  • @sumitrawall
    @sumitrawall Месяц назад

    Great video bhaiya!! bhaiya please make video on resume building for freshers for data engineering.

  • @comeonindia1982
    @comeonindia1982 Месяц назад

    Good vide boss

  • @TechLearnWithAyan
    @TechLearnWithAyan Месяц назад

    nice work

  • @katreji
    @katreji Месяц назад

    Whatsaap grp kese join kre

  • @abhiabhishekverma8
    @abhiabhishekverma8 Месяц назад

    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.

  • @abhiabhishekverma8
    @abhiabhishekverma8 Месяц назад

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

  • @coder-fr6ko
    @coder-fr6ko Месяц назад

    🎉🎉

  • @jiteshjoshisde3154
    @jiteshjoshisde3154 2 месяца назад

    when we do group by 1 ?

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh Месяц назад

      Group by 1 is simply group by column name, the first column in select statement is only referring there as group by 1

  • @ronitbagga7331
    @ronitbagga7331 2 месяца назад

    post some video on full projects for data analysis how to work on them step by step guidance

  • @ronitbagga7331
    @ronitbagga7331 2 месяца назад

    good work

  • @jiteshjoshisde3154
    @jiteshjoshisde3154 2 месяца назад

    Why you used left join specifically here? And can we cange the condition to d2. PointA > d1. PointB

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh Месяц назад

      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?

  • @anuragsahu4574
    @anuragsahu4574 2 месяца назад

    Done

  • @coder-fr6ko
    @coder-fr6ko 2 месяца назад

    First

  • @singh28825
    @singh28825 2 месяца назад

    thank you for this important videos

  • @srishtimakkar6825
    @srishtimakkar6825 2 месяца назад

    Please make a video on joins also

  • @srishtimakkar6825
    @srishtimakkar6825 2 месяца назад

    helpfulll

  • @TarunKumar-yr4dl
    @TarunKumar-yr4dl 2 месяца назад

    पाजी राम राम

  • @studbanda9426
    @studbanda9426 2 месяца назад

    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

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh 2 месяца назад

      Bhai aap sql ka Logic banana sikho rather than syntax and platform, oracle MySQL postgres sab chalega

  • @BharatPatel-eu7or
    @BharatPatel-eu7or 2 месяца назад

    Hello sir kya aap dataford ke SQL solution ka bhi series start karenge it will be very helpful .

    • @DATAKEDAKU-singh
      @DATAKEDAKU-singh 2 месяца назад

      Data ford ki bhi karenge…ap url daal doh

  • @ronitbagga7331
    @ronitbagga7331 2 месяца назад

  • @ronitbagga7331
    @ronitbagga7331 3 месяца назад

    thank you