From the course: Complete Guide to Analytics Engineering

Databases, data lakes, and data warehouses…oh my!

From the course: Complete Guide to Analytics Engineering

Start my 1-month free trial Buy for my team

Databases, data lakes, and data warehouses…oh my!

“

- [Instructor] Databases, Data Lakes and Data Warehouses, home, sweet home for the analytics engineer. In this chapter, we'll peek behind the curtain of database architecture, which will continue to build our knowledge foundation that will aid us when it comes time to start building with our data. When it comes to designing and building a house, there are lots of techniques and methods that are perfectly safe and viable for a home. The same goes for designing and building a database and data warehouse. Some designs are tried and true, and haven't changed much in decades. Other designs are more modern, and leverage techniques that aren't frequently seen in older warehouses, but are more fitting for present day applications. We'll explore the traditional data warehouse and a few more modern architectures in this chapter, but know that there are many, many more organizational designs that are possible. These are just the more common ones. First, we'll explore relational databases.

Contents