SQL

SQL is a standard language for accessing and manipulating databases and stands for Structured Query Language. In essence, SQL lets you access and manipulate relational databases.

Topic

Slides

Data & Code

Einführung in SQL (german)

Slides

Download task

Datentypen (german)

slides

Download data, SQL code

Grouping and summarizing

Slides

Download data

Joins

slides

Illustration of Joins

Subqueries

slides

Data