Databases and SQL

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.

Time and place: – , GSH: DSC-Oasen (morning) og LINKEN (afternoon)

Register

Program

  1. Introduction to relational databases
  2. Selecting data
  3. Sorting and Removing duplicates
  4. Filtering
  5. Calculation
  6. Dealing with missing data
  7. Aggregation, such as sums and averages
  8. Combining data from multiple tables
  9. Data hygiene, how to best structure your database
  10. 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.

Prerequisites

There are no knowledge prerequisites but required material setup (see the section below)

Target audience

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

Required Materials

Laptop with installed software and sample database (see below). 

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

Organizer

Kyrre Traavik Låberg
Published Dec. 9, 2022 1:18 PM - Last modified Jan. 2, 2023 3:39 PM
E-mail this page