Learning SQL by practicing on popular movie databases

Abstract

The new Hungarian National Base Curriculum (NAT2020), unlike the previous NAT2012, makes knowledge of the SQL language mandatory for students in the advanced final examination, which poses new challenges for both students and their teachers. An educational portal, sqlsuli.hu, has been developed and launched in order to help students to learn SQL (Structure Query Language). The framework of this site has an extensive grader tool that helps students test their SQL commands without intervention from a teacher, thus providing a flexible learning experience. The created sample databases are based on Harry Potter and Star Wars data, which is expected to increase students’ engagement and motivation for learning. The developed LMS (Learning Management System) offers the authors the ability to improve the courses based on the solved problems and the comments on the forums. The course is available in Hungarian.