Skill Pill: Database Manipulation

Skill Pill: Database Manipulation will go over the basics of dealing with databases.

Databases are widely used in many areas: businesses, on the web and, of course, in science, notably in bio-informatics. In this Skill Pill, we will go over the structure of the most common databases (relational databases), how to communicate with them using SQL and more. There is no prior knowledge required as we will cover the basics.

Target audience

This Skill Pill is suitable for anyone.

Teachers

The teachers will be Saiful Haque (IT Manager), Christian Butcher (technician) and Jeremie Gillet (Belgian clown).

Program (Second edition, July 2020)

The Skill Pill will be divided into 3 sessions:

Date Time Topic Lecturer
Tuesday, July 7 10:00 - 12:00 Introduction to Databases Jeremie
Friday, July 10 10:00 - 12:00 SQL Queries Christian
Tuesday, July 14 10:00 - 12:00 SQL Updates and DB Manipulations, Advanced SQL  Saiful

The material of the course is available here.

The footage of the Skill Pill can be found here.

Program (First edition, June 2016)

Date Time Topic Lecturer
Monday,  June 20 5PM ~ 7PM Background and Database theory Guido Klingbeil
Thursday, June 23 5PM ~ 7PM Requests with SQL Jeremie Gillet
Monday, June 27 5PM ~ 7PM DB creation and manipulation with SQL  Cindy Esporlas
Thursday, June 30 5PM ~ 7PM DB used in OIST, Beyond relational DB Julia Janicki, Nausad Hossain Shaikh
 

The material of the course is available here.

More information

  • Location: B701, AKA computer lab, Lab 3.
  • Zoom link: if you prefer joining remotely, or if B701 exceeds 50% capacity, you can join using this link
  • What to bring: a laptop, with a unix terminal. Link for Windows users.
  • YouTube: this Skill Pill might be recorded and uploaded on YouTube, only the teacher will be seen. Contact Jeremie Gillet if you have reservations about this.
  • Drinks: There will be free coffee and tea, bring your cup!

If you are interested in the course but cannot participate to this particular event, let us know and we will contact you for any later occurrence of the Skill Pill.

Thank you very much for your interest.

Have you used some before? How comfortable are you with them?
Why are you interested in this Skill Pill? Is there a particular thing you would like to learn?