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 :)
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
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
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
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 :)
soon will start that too
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
Yes, correct
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
Enjoyed the session..❤ need more such sessions..❤
many more sessions planned
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'
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
Great video....Please explain clearly as the candidate is on some points not very clear while speaking
Happy to know that you are finding the content helpful. I would appreciate if the good points are considered from the videos.
Please provide the feedback also
will soon start on that as well
Great Session❤❤
thank you
Voice is low
will keep improving
Please provide feedback sir ❤
will start that soon