From the course: Learning Data Science: Understanding the Basics
Join today to access over 25,100 courses taught by industry experts.
Get data into warehouses using ETL
From the course: Learning Data Science: Understanding the Basics
Get data into warehouses using ETL
- Many data science concepts build on previous work with relational databases. Companies have been capturing and analyzing data for decades. Even today, the relational database management system is the cornerstone of enterprise data. You need to understand our DBMS terms on your data science projects. One place you'll likely run into them is when you're focused on data warehouses. An Enterprise Data Warehouse or EDW is a special type of relational database that focuses on analyzing data. Traditional databases are optimized for online transaction processing or OLTP. A data warehouse is used for analytical processsing or OLAP. Think of it this way. The typical database is focused on working with data in real-time. A data warehouse is focused on analyzing what already happened. Imagine you have a website that sells running shoes. You've hired an engineer to create your database. They've created dozens of different tables and relationships. There's a table for customer address, a table…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.