Working with SQL databases

Welcome to the OTS beginner's course on SQL databases. To get started install the required software and download the database needed to solve the excercises.

If you have done so, you can start with the first part, the introduction.

Chapter overview

  1. Introduction
  2. SQL basics
  3. The theft of the Mona Lisa
  4. Who was the string puller? - Data quality and aggregation functions
  5. Advanced topics
  6. Entering data


Sample database (to be opened with sqlite)

Installation guide

Solutions to the excercises

SQL wikibook. Very good.

SQL script to create the sample database (not required for the tutorial)