Ordering ETL Tasks

You have been hired to manage data at a small online clothing store. Their system is quite outdated because their only data repository is a traditional database to record transactions.

You decide to upgrade their system to a data warehouse after hearing that different departments would like to run their own business analytics. You reason that an ELT approach is unnecessary because there is relatively little data (< 50 GB).

This exercise is part of the course

Database Design

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise