Agile Software Development

Introduction to Linux

Introduction to C++ (for Programmers)

Introduction to Databases

SQL skills are highly demanded in the labour market and are part of most programmer's daily work. In addition, they are paid well, see eg. SQL Programmer Salary. So please stay focused as you study SQL and complete your assignment work.

We'll use SQLite3 which is a reasonably complete implementation of the SQL-92 standard and generally follows PostgreSQL syntax.

Set up your computer to have a working installation of a database browser and an actual database.

  1. Download DB Browser for SQLite (available via apt when using Debian based Linux distributions
  2. Download the Northwind-SQLite3 database, extract it and open it with SQLite DB Browser
  3. To get an understanding of the database, study the entity relationship diagram (ERD) of the northwind database: Northwind ERD
  4. Look at the database structure and try to understand the fields of the 13 tables in the database
  5. Browse the data to get a feeling for the data tables present

To prepare for your exam and get help for our exercises, work through the SQL Tutorial, but execute the examples in your local database (use the Execute SQL tab of DB Brower for SQLite). So far, we covered everything up to and including join. Wikipedia also provides a good introduction to SQL Joins. Note that right join is not supported in sqlite3.

SQL Exercises

Sample Code

Prior Exams


Content of the Curriculum (4th Year)

Curriculum in the Legal Information System (see Attachment 1.5)

Kompetenzmodul 7

Bildungs- und Lehraufgabe

Kompetenzmodul 8

Bildungs- und Lehraufgabe