Carpentry@UiO Workshop: Databases and SQL

Do you want, or need, to learn how to work with databases for your research, but have little or no previous knowledge? Or, do you want your team members to learn how to use and create databases? If yes, then this workshop is for you and/or your team!

Time and place: –, UiO, Blindern, Georg Sverdrups hus, DSC Oasen
Grey background with black Carpentry logo on the left and blue background with orange text

Carpentry community logo and Data Management Week 2025 Fall edition

This workshop is a collaboration between Carpentry and Data Management Week 2025 (Fall edition)

Target audience

Anyone interested in learning SQL and using databases in their academic studies, research, or work.

Learning outcomes

  • Knowledge of what relational databases are and why they are useful for researchers. Learners will leave the workshop with the skills to use a graphical user interface (similar to Excel), write queries to find, input, change, import, and export data to and from a database, and design a database to best fit their data.
  • 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.

Prerequisites

  • There are no knowledge prerequisites but required material setup (see Setup below)
  • Abiding the Carpentries Code of Conduct
  • Being aware that this workshop focuses on the basics of programming in examples and exercises and is not meant for experienced programmers

Setup

1) Computer where you have administrative access 

2) Install the graphical user interface DB Browser and see that it starts

3) Download the sample database we will use in the workshop

Course information (coming soon)

Programme

  • Introduction to relational databases
  • Selecting data
  • Sorting and Removing duplicates
  • Filtering
  • Calculation
  • Dealing with missing data
  • Aggregation, such as sums and averages
  • Combining data from multiple tables
  • Data hygiene, how to best structure your database
  • Creating, exporting, importing, and modifying data

Number of participants

After the soft deadline, a waiting list will be automatically handled upon de-registrations.

If we receive more sign-ups than our capacity allows, priority is given to UiO/OUS staff and students.

Price

The workshop is free of charge

Instructor

Kyrre Traavik Låberg, Karl Farrugia

Contact

If there are questions related to installation and testing of the software packages needed, feel free to ask us via email at contact-us@carpentry.uio.no

Registration

Sign-up deadline: November 11, 2025 

Sign up

Other relevant courses

 

If you are interested in other Carpentry@UiO workshops, please visit uio.no/carpentry

Organiser

Digital Scholarship Centre
Published Aug. 18, 2025 2:24 PM - Last modified Aug. 4, 2026 1:55 PM
E-mail this page