Must Watch Live Mock Interview For Data Engineers | System Design | Data Modeling

[@sonuparmar5836]

Incase someone have doubts regarding joins she answered, her answers are right. All will have 6 records as output.

[@apoorvgupta1993]

Yes, she is absolutely right😁

[@badrinathansathiyamurthy8390]

If you have same entity. Just multiply.

[@mohithakrishna3125]

This was really helpful and would be very useful to start preparing for data engineer interviews. Thank you Apoorv for giving us an interviewer pov. Looking forward to more such content!

[@shreyaspurankar9736]

Valuable insights. Helpful for me.

[@AnuragVardhan-lt3rc]

Great eye opener and great knowledge shared

[@gaganpratap7016]

Valuable insights appuu sir❤❤

[@VenkatBala-jv2yh]

Great questions....

[@ranjitdhiwar8545]

Nice insights Apoorv.!

[@vanshikagupta2782]

Very insightful 😃

[@shivatrivedi6964]

Great

[@yudhveersingh8177]

Please suggest a chennal for pyspark

[@apoorvgupta1993]

What exactly are you looking to learn?

[@prasadmuthyala9625]

I have 2.7 years of experience in Salesforce development but I want to transition to data engineer. As per I know job opportunities and growth is more in data engineering compared to salesforce CRM. Actually I tried to get job in Salesforce but getting calls 2-3 per month it's been 6 months . I also worked 2 projects in service and experience cloud. Have skills like lwc, integration, admin, Apex, triggers, SOQL and SOSL. If I'm trying to transition to other I understood that CRM domain have less flexibility compared to data domain. So I need suggestions like is it good to change my domain to data side?????

[@maninderbhambra3796]

Sir plz hav someone 10 + years guy interview...it will help a lot

[@RohitSharma-ny1oq]

inner join ==3 records

[@apoorvgupta1993]

Ideally it should be 6 records as you will get a matching record every single time😬

[@RohitSharma-ny1oq]

@@apoorvgupta1993 thanks Sir , so duplicate combinations also included

[@apoorvgupta1993]

Yes, in sql we can definitely get duplicate records.. that’s why we have the DISTINCT keyword to get only the distinct records if we want

[@dhanushkumarpalani424]

when i tried i got around 9 records for cross join kindly confirm it

[@GudduKumar-wy1hi]

Cross join with give at max 6 rows, means no. of rows on table 1* no. of rows in table 2

[@GudduKumar-wy1hi]

Please arrange an interview with more experience guy @sumit mittal