Introduction to the Database Query Language SQL
Course further information
When working with large amounts of tabular data, using a relational database can improve query performance.
The standard language to work with these databases is the Structured Query Language (SQL).
In this course we will look at how to write queries to relational databases in SQL. We will start simple and move towards more complex queries, covering the following topics:
During the course you will type and click along, following the instructors, preferably on your own machine. Please reach out to us, if you need help installing DB Browser for SQLite (https://sqlitebrowser.org/dl/). If necessary, you can also use the on-site computers that have DB Browser for SQLite preinstalled.
The standard language to work with these databases is the Structured Query Language (SQL).
In this course we will look at how to write queries to relational databases in SQL. We will start simple and move towards more complex queries, covering the following topics:
- filtering
- sorting
- aggregating
- joining (data from mutliple tables)
During the course you will type and click along, following the instructors, preferably on your own machine. Please reach out to us, if you need help installing DB Browser for SQLite (https://sqlitebrowser.org/dl/). If necessary, you can also use the on-site computers that have DB Browser for SQLite preinstalled.
Dr. Volker Schwartze
Course instructor
Dr. Philipp Schäfer
Course instructor
Enrolling on the course was not possible: