Hi Pavan We have started giving reviews at the end of the interview in our recent Data Engineering Mock interview. Please check the playlist for recent videos.
you were telling about delete, we use truncate to delete hole rows data from table and it is quick and for delete we can delete individual row. the drop will be used to triggers, indexes, constraints, and other dependencies. if you are making the interview session please sure the answer are correct because people are watching your videos, slight mistake can put them into confusion rest all is good keep it up
in this project ma'am said that is , they used postgresql sql , which type of data it was ? structured or unstructured??? and if unstructured then why postgresql? according to non sql databases?
I felt the questions asked in interview were easy and straight forward for 2.3 years experience , can we expect these level of questions if we are switching from an analyst role to data engineering role I'm just too afraid to sit for an interview because i feel the interview questions would be difficult
Questions actually depend upon team, company, experience and luck. But let's suppose if you feel that the question which is asked is easy then you should give your answer so brilliantly that the interviewer should get interested in you.
bhai can you give what all things I should learn For Data engineer position currently preparing for data analytics and I know SQL,Power Bi,Python,Excel
@@watan898 start with a good understanding of Data Warehousing and ETL concepts (should be good in atleast one like Snowflake/Databricks). Do practice on medium level SQL questions. Do not rush towards spark if you are new. Trust me most of the Data Engineering roles don't demand spark.
![[LIVE] : ONE ลุมพินี 89 | คู่เอก "ยอดไอคิว vs คิริลล์"](http://i.ytimg.com/vi/Z3vYkHJ_5Ig/mqdefault.jpg)
The SQL part in your interviews are more usefull.Those will improve analytical skills .thank you so much for giving us these interviews
I believe they should put corrected answers as well
Hi Pavan
We have started giving reviews at the end of the interview in our recent Data Engineering Mock interview. Please check the playlist for recent videos.
In inner join it will have on 3 ones ,2 twos as matching so it will have only 5 rows
right
Great work !! 👍🏻👍🏻
you were telling about delete, we use truncate to delete hole rows data from table and it is quick and for delete we can delete individual row. the drop will be used to triggers, indexes, constraints, and other dependencies. if you are making the interview session please sure the answer are correct because people are watching your videos, slight mistake can put them into confusion
rest all is good keep it up
Can you please add right answers at the end
your videos are really helpful!.
Thank you
Great job sis 👌
in this project ma'am said that is , they used postgresql sql , which type of data it was ? structured or unstructured??? and if unstructured then why postgresql? according to non sql databases?
I felt the questions asked in interview were easy and straight forward for 2.3 years experience , can we expect these level of questions if we are switching from an analyst role to data engineering role
I'm just too afraid to sit for an interview because i feel the interview questions would be difficult
Questions actually depend upon team, company, experience and luck. But let's suppose if you feel that the question which is asked is easy then you should give your answer so brilliantly that the interviewer should get interested in you.
Most of the answers are incorrect, could you please upload the video with right answers
It means u know d answer 😅 relax
Yes .she is wrong at drop and delete also
yes
@@AbhinavDairyFarm
Just a mock interview bro...she did her best
how much years of experience interview is being held?
She is having 2.3 yrs of experience
@@nishabansal2978 🤣🤣🤣🤣
Junior level? Sql knowledge is very basic
Yes, it is just the replication round of the interview. Try checking the second round of the mock interview from the playlist.
Can we expect this level of questions for 2 years of experience candidate
Yes
My Organization had a bootcamp of two months and asked harder questions than this :/ Questions were pretty easy.
Many are wrong answers kindly provide correct interview videos
If you need I can volunteer for a Big Data Engineer mock interview. I have 2.1 years of experience and will not charge anything.
bhai can you give what all things I should learn For Data engineer position currently preparing for data analytics and I know SQL,Power Bi,Python,Excel
@@watan898 start with a good understanding of Data Warehousing and ETL concepts (should be good in atleast one like Snowflake/Databricks). Do practice on medium level SQL questions. Do not rush towards spark if you are new. Trust me most of the Data Engineering roles don't demand spark.
@@ShivamGupta_15 so first I should learn snowflake and the. What,i practise SQL on stratascratch and leetcode.
Any free source you would like to recommend to learn, I have already spend 60k on data analytics cource. 😅