Preparation

We will use SQLite for all exercises, as it requires no installation and works out-of-the-box with most environments.

Prerequisites

We're going to use Dbeaver, a free and open-source database management tool that supports SQLite and many other databases.

• Download and install Dbeaver

  • [Optional] Have a look around the interface https://dbeaver.com/docs/dbeaver/Application-Window-Overview/

• There's also a VSCode extension for SQLite called SQlite Viewer.

Reading list

• Introduction to Databases

• Relational Database Terms

Extra materials

• DBeaver Playlist

• SQLite Tutorial

• w3schools SQL Tutorial