Carpentry 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

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 [docs.carpentries.org/topic_folders/policies/code-of-conduct.html]

  • 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

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.

Instructors

Kyrre Traavik Låberg

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: October 16th, 2024 

Sign up

 

 

 

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

Published Aug. 28, 2024 1:16 PM - Last modified Jan. 5, 2026 1:14 PM
E-mail this page