Introduction to the Database Query Language SQL
Course further information
Learn to query relation databases with SQL.
When working with large amounts of tabular data, using a relational database can improve query performance. They also force you to choose and stick to data types for your columns. 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, and
- 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.
Requirements
During the course you will type and click along, following the instructors, preferably on your own machine. For this you need a working installation of DB Browser for SQLite: https://sqlitebrowser.org/dl/ Alternatively, you can use computers provided at the workshop location, where all required software is already installed. But we recommend that you use your own machine, so that you can learn within your usual environment.
Certificate
This course is part of our Data Carpentry Workshops. In order to receive the Data Carpentry Certificate you also have to attend the other two courses.
