From the course: Complete Guide to Analytics Engineering

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Data warehousing

Data warehousing

From the course: Complete Guide to Analytics Engineering

Start my 1-month free trial Buy for my team

Data warehousing

“

- [Narrator] If a database is a place where you store multiple data tables, then a data warehouse is where you can store multiple databases from different data sources altogether. Why would you need to store multiple databases? Because some organizations, especially large ones, have data that are extremely complicated and you might need to keep them isolated from one another. For example, you might want to grant access to the sales database to one team and access to the HR database to another team. You can accomplish that in the data warehouse. One data warehouse can also store a relational database alongside a non-relational database. Pretend your organization is a social media company. In a relational database, you might store data around your users on the platform, like their usernames, their passwords, their first and last name. You might also have a non-relational database for storing the user's feeds, which wouldn't be possible if you only had access to a relational database…

Contents