# Week 1

In this session, trainees will be introduced to databases, including why we use them, how data is modeled, and how to interact with a relational database using SQL.

## Learning Goals

See [this module's learning goals](https://program.hackyourfuture.dk/course-content/foundation/databases/..#learning-goals).

## Main Topics

* **What is a database?** Why we use databases, real-life data models, and the role of databases in software systems.
* **Relational data terminology:** Table, row, column, primary key, foreign key.
* **Schemas and entities:** How to design and understand simple schemas.
* **Basic SQL operations:**
  * SELECT: Retrieving data
  * INSERT: Adding data
  * UPDATE: Modifying data
  * DELETE: Removing data
* **Filtering and sorting:** WHERE, LIKE, ORDER BY, LIMIT