This lesson is in the early stages of development (Alpha version)

From a Spreadsheet to a Database: Glossary

Key Points

Loading data directly into the database
  • Most databases allow people to load data from csv

  • The default settings on data loading are OK for a quick look at the data

Combining datasets
  • A VIEW can be used to create saved queries which can be used like tables.

  • We can quickly load multiple CSVs into the same database.

  • csvs can be linked if we can find the right key.

Extracting Data
  • Spreadsheets are inflexible and can present challenges when needing to answer novel questions.

  • Any programming language can be used to transform data into a different format which is better for analysis.

Transforming and Loading Data into a database
  • Explain why inferences drawn from uncleaned data are always approximate.