Carpentry@UiO workshop: Databases and SQL

Hands-on Carpentry@UiO workshop with queries and database principles using SQLite.

Grey background with black Carpentry logo on the left and blue background with orange text of Data Managemnet Week

This workshop is a collaboration between Carpentry@UiO and Data Management Week 2026 Spring Edition

Target audience

Researchers on all levels.

Course description

A one day hands-on workshop to learn the principles of databases and SQL.

The workshop will go through important episodic lesson materials with accompanying exercises using the SQLite query language and database system.

SQLite is very similar to other query languages such as MySql, PostGres, Oracle, so the knowledge gained from this workshop can be used over a broad scope across many disciplines, both of the Sciences and the Arts.

For more detailed Course information click here.

Learning outcomes

  • What relational databases are, and why they are useful for researchers.
  • To use a graphical user interface (similar to Excel).
  • To write queries to find, input, change, import, and export data to and from a database.
  • Table structures and data types.

Prerequisites and required materials

  • No previous knowledge is necessary.
  • Laptop with software installed (DB Browser for Sqlite).
  • Installation details and Setup can be found here.

Price

The course is free of charge

Contact

Kyrre Traavik Låberg

Sign up for this workshop!

Sign up

Other relevant courses

 

Published Jan. 26, 2026 3:06 PM - Last modified Sep. 4, 2026 4:49 PM