Data warehouses are used to store and analyze data from multiple sources. They provide a central repository for integrated data, which can be used to create analytical reports for decision-making. Data is uploaded from operational systems and may require cleansing before it is stored in the warehouse. ETL and ELT are the two main approaches used to build a data warehouse system.
Carnegie Mellon University
Fall 2016
This course introduces databases, data models, SQL, database design, query optimization, indexing, and transaction management. It aims to impart understanding of when and how to use database management systems. The course is heavily based on the textbook "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke.
No concepts data
+ 20 more concepts