Yesterday, Benard Wanjiru gave the #Databases lecture about SQL and systematic SQL query construction. Some information about the course can be found at: https://djoerdhiemstra.com/category/course-databases/

(the rest, including the slides and the lecture video is behind the university's BrightSpace "paywall", unfortunately)