Introduction to the Database Query Language SQL

21.05.2024 09:15
Kurs startet
21.05.2024 13:00
Kurs endet
2 Plätze
Verfügbare Plätze
Buchen

courseFurtherInformation

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:
  • 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.
Kontakt
zedif@uni-jena.de
Sprache
English
Inhaltliche Schwerpunkte
  • Writing SQL queries
  • Filtering
  • Sorting
  • Aggregating
  • Joining
Max. Anzahl Teilnehmende
20
Standort
Ernst-Abbe-Platz 2, Linuxpool 1 (Raum 3413)