.png)
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.
Target audience
Everyone can come, all scientific fields, participants can be both internal and external to UiO
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
- No previous knowledge is necessary
- Laptop with software installed (DB Browser for Sqlite)
- Installation details and Setup can be found here (URL coming soon)
Required materials
- Laptop
Lunch
- There will be a complementary buffet-lunch at 12:00-13:00 from the Sverdrups spiseri (Georg Sverdrups Hus, 2nd floor).
- After you get your lunch, join us at Store møterom where we have reserved seats for #DSDays2027 participants.
Number of participants
30
Contact
If you have any questions regarding this course, or anything else about the DSDays 2027 event, please contact us per email: digitalscholarship@ub.uio.no