Registration
Sign-up deadline: June 5th, 2024
Course information
Instructors
Kyrre Traavik LĂ„berg, Espen Rosenquist
Program
-
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
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
Target audience
Anyone interested in learning SQL and using databases in their academic studies, research, or work
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
Prerequisites
- There are no knowledge prerequisites but required material setup (see above)
-
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
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
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.
If you are interested in other Carpentry@UiO workshops, please visit uio.no/carpentry