In the age of big data, understanding databases and warehousing is a necessity. Various organisations are rapidly producing a vast amount of structured and unstructured data. It is harnessed to discover prospects and opportunities for getting better in terms of performance, efficiency, revenues, or anything that it resonates with. These results can be achieved, provided the data storage and handling are strong. For this purpose, data lakes and data warehousing are popularly used. These are two unique terms that help in transforming data, encompassing data entry to cleansing and then processing for machine learning and AI algorithms.