Class 4
The ETL process: Relational Databases
Description
This session introduces relational databases and the use of keys, tables, and relationships to organize and combine structured data. Understanding relational data is important because many accounting and business analyses require information to be integrated across transactions, entities, periods, and data sources.
Motivation
How do datasets relate to one another?
Review
The prior session focused on obtaining data from external sources through APIs. This session considers how data can be extracted from structured relational database, extending the extraction process from retrieving individual datasets to understanding relationships among them.