First things first: Lecture Notes | Slides | Exercises as slides.
This is a course on the Virtual Observatory's main query language ADQL (short for Astronomical Data Query Language), which is a SQL dialect standardised so users do not have to learn new languages each time they want to use a new resource. We also introduce the basic aspects of the Table Access Protocol TAP, which transports ADQL queries, their results, as well as the metadata necessary to write meaningful queries.
The course comes with many exercises, most of which also have solutions. We hope it is suitable for both self-study and as lecture notes in teacher-led situations. Participants should have some basic knowledge of astronomy, and they should have some basic knowledge of the TOPCAT table processor.
The course should work as a day-long block and has been run as this (or even more compressed, but then you need to drop material) at many venues. It is also used as a three-lecture stretch within the semester-long course on using the VO.
The source code of this course is available on Codeberg for git-cloning. Contributions are welcome. All this is distributed under CC0.