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
Researchers on all levels.
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 precious knowledge is necessary.
- Laptop with software installed (DB Browser for Sqlite).
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 #DSDays25 participants.
Number of participants
After the soft deadline, a waiting list will be automatically handled upon de-registrations.
Contact
If you have any questions regarding this course, or anything else about the DSDays25 event, please contact us per email: digitalscholarship@ub.uio.no
Sign up for this workshop!