Thank you for the kind words. We have more than 25 mock interviews on our channel. Check the Data Engineering mock interview playlist. Please watch it in your free time, learn from it & let us know your thoughts.
Thank you Pulkit for your encouraging words. We have uploaded more than 22 Data Engineering and big data mock interviews. Do watch it in your free time. You will learn a lot & keep posting your encouraging words. It motivate us a lot.
Check the description. We have provided one link of TopMate for scheduling one call for the interview. We will connect with TopMate and discuss the next process
WITH cte AS ( SELECT user_id, event_id, event_type, event_date, EXTRACT(MONTH FROM event_date) AS months FROM user_actions ), cte2 AS ( SELECT user_id, event_type, months, event_date, dense_rank() OVER (PARTITION BY user_id, months ORDER BY event_date) AS rn FROM cte WHERE months 1 group by mth Sol for SQL problem2 correct me if I am wrong
2nd solution in PostgreSQL. WITH CTE1 AS (SELECT user_id, event_type, EXTRACT(MONTH FROM event_date) as month, DENSE_RANK() OVER(PARTITION BY user_id,EXTRACT(MONTH FROM event_date) ORDER BY EXTRACT(MONTH FROM event_date)) as rk FROM user_actions) SELECT month, COUNT(rk) AS montly_active_users FROM CTE1 WHERE rk = 2 GROUP BY month
we can clearly see here that although she can solve SQL queries but didn't have any practical experience. And why I am saying because she didn't know how to debug.
Hi Rohan She is currently studying in University of Washington for her master & many things have changed in the last three years in Apache Spark. So it's very ok if someone who is on break for their study does not know any of the theoretical concepts like AQE in Spark. Why do we always go in judging someone instead of getting inspiration from someone courage to come out in public and give their best in the interview. It takes lots of courage and calibre. FYI, She had worked in Microsoft and Amazon as SDE and it is actually very much accepted having less theoretical ideas about Data Engineering. She was able to approach all the practical questions like SQL, DSA and even some level of system design questions. So kindly encourage someone, instead of passing judgement comments. On offence, BTW !!!
Nd even if the best coder in the world will go for 10 interviews and at least in 5 interviews, he or she will not be able to answer multiple questions. So judging someone is actually very bad and passing the comment. Instead of judging someone, try discussing some of the questions which were asked in the interview.
@@rohan5713 better to discuss questions and answers here. Why to pass judgement? If someone has been studying for the last two years then obviously some of the theoretical questions will be missed because that particular person is not writing code daily professionally & moreover Apache Spark is just a framework. Not knowing Apache Spark's questions is ok. Better to discuss questions then to pass comments that the interviewee doesn't know something. I hope you will understand what I am trying to convey. Do you have any questions which Kuldeep has asked in the interview and that you want to discuss then kindly comment that question. And, if you know the answer then also it will be great. I hope you will take this in a positive way.
Here we go 🎉
You are doing a fabulous job!! Lately seeing all the videos and it's helping me a lot.
very very helpful contain....
Thank you for the kind words. We have more than 25 mock interviews on our channel. Check the Data Engineering mock interview playlist.
Please watch it in your free time, learn from it & let us know your thoughts.
Definitely I am also preparing for data engineering interview so that will really gone helpful for me
Good one, spark questions were really helpful
Thank you Pulkit for your encouraging words. We have uploaded more than 22 Data Engineering and big data mock interviews. Do watch it in your free time. You will learn a lot & keep posting your encouraging words. It motivate us a lot.
Very informative. Keep it up😊
Is machine learning also asked in Data Engineering interviews?
It depends upon your resume and job profile. But mostly no, it is not asked.
Amazing work Rashmika!
How i can attend a mock interview in this channel?
Check the description. We have provided one link of TopMate for scheduling one call for the interview. We will connect with TopMate and discuss the next process
🎉🎉🎉
Clear accent. Thank you
Good Work Rashmika, Learned a lot from this video.
Glad it was helpful!
WITH cte AS (
SELECT user_id, event_id, event_type, event_date, EXTRACT(MONTH FROM event_date) AS months
FROM user_actions
),
cte2 AS (
SELECT user_id, event_type, months, event_date,
dense_rank() OVER (PARTITION BY user_id, months ORDER BY event_date) AS rn
FROM cte
WHERE months 1
group by mth
Sol for SQL problem2 correct me if I am wrong
2nd solution in PostgreSQL.
WITH CTE1 AS (SELECT
user_id,
event_type,
EXTRACT(MONTH FROM event_date) as month,
DENSE_RANK() OVER(PARTITION BY user_id,EXTRACT(MONTH FROM event_date) ORDER BY EXTRACT(MONTH FROM event_date)) as rk
FROM user_actions)
SELECT month,
COUNT(rk) AS montly_active_users
FROM CTE1
WHERE rk = 2
GROUP BY month
important content is Questions asked 😅😅
we can clearly see here that although she can solve SQL queries but didn't have any practical experience. And why I am saying because she didn't know how to debug.
Hi Rohan
She is currently studying in University of Washington for her master & many things have changed in the last three years in Apache Spark. So it's very ok if someone who is on break for their study does not know any of the theoretical concepts like AQE in Spark.
Why do we always go in judging someone instead of getting inspiration from someone courage to come out in public and give their best in the interview.
It takes lots of courage and calibre. FYI, She had worked in Microsoft and Amazon as SDE and it is actually very much accepted having less theoretical ideas about Data Engineering.
She was able to approach all the practical questions like SQL, DSA and even some level of system design questions.
So kindly encourage someone, instead of passing judgement comments.
On offence, BTW !!!
Nd even if the best coder in the world will go for 10 interviews and at least in 5 interviews, he or she will not be able to answer multiple questions. So judging someone is actually very bad and passing the comment.
Instead of judging someone, try discussing some of the questions which were asked in the interview.
@@TheBigDataShow bro that's why I have commented because she has already worked in Microsoft and Amazon.
@@rohan5713 better to discuss questions and answers here.
Why to pass judgement?
If someone has been studying for the last two years then obviously some of the theoretical questions will be missed because that particular person is not writing code daily professionally & moreover Apache Spark is just a framework.
Not knowing Apache Spark's questions is ok.
Better to discuss questions then to pass comments that the interviewee doesn't know something.
I hope you will understand what I am trying to convey. Do you have any questions which Kuldeep has asked in the interview and that you want to discuss then kindly comment that question. And, if you know the answer then also it will be great.
I hope you will take this in a positive way.