Cloud Data Engineer Mock Interview | Focusing on SQL, PySpark, Project & Cloud Questions.

[@jatinzorro7038]

Great video...Following this series....Additionally....Can you please also provide the Feedback or answers that can be Improved....No judgement, we all here to learn :)

[@sumitmittal07]

soon will start that too

[@sandhyasandy9072]

Needful series 🙏🙏🙏.Thank you Sumit sir 😊
Databases are for oltp and for real data. data warehouses are for olap where the query execution would take lesser time than the database as it follows the denormalised method. One of the other difference

[@sumitmittal07]

Yes, correct

[@shilashm5691]

but traditional dwh is not for olap, it just stores historical data. Nd dwh does'nt store data in denormalized form, it is based on data warehouse modelling you use for eg. kimball, inmon, data mesh

[@urvxfvdzrnp]

Enjoyed the session..❤ need more such sessions..❤

[@sumitmittal07]

many more sessions planned

[@vikaschavan6118]

WITH CTE AS (
SELECT *,Dense_RANK() OVER (PARTITION BY emp_id ORDER BY time DESC) rnk
FROM org)
SELECT * FROM CTE WHERE rnk=1 AND status='in'

[@PrashantSharma-sw2jr]

WITH CTE AS (
SELECT *,Dense_RANK() OVER (PARTITION BY emp_id ORDER BY time DESC) rnk
FROM org)
SELECT count(*) FROM CTE WHERE rnk=1 AND status='in' and time

[@shubhampuri28]

Great video....Please explain clearly as the candidate is on some points not very clear while speaking

[@sumitmittal07]

Happy to know that you are finding the content helpful. I would appreciate if the good points are considered from the videos.

[@HarshGupta-if2xg]

Please provide the feedback also

[@sumitmittal07]

will soon start on that as well

[@ashutosh_1024]

Great Session❤❤

[@sumitmittal07]

thank you

[@skybluelearner4198]

Voice is low

[@sumitmittal07]

will keep improving

[@vishaldeshatwad8690]

Please provide feedback sir ❤

[@sumitmittal07]

will start that soon