E-LEARNING SUPPORTED SQL TEACHING

Most database systems that are used in enterprises are based on the database language SQL. As a kind of programming language, SQL cannot only be taught with paper and pencil. Instead, it is evident to use computers so that students can make their own practical experiences. The main problem is that when working with a database students can easily destroy their previous work (tables or data sets) so that they cannot proceed in practicing. Usually, SQL exercises are based upon each other so that following exercises result in a different output than the reference output. Besides, ff students work on the same data base the learning progress of a student can be negatively affected not only by himself but by other students. In this paper, an intelligent tutoring tool is presented that overcomes this situation. It provides a private database environment to each single student separated from other students so that it cannot be influenced by others. In addition, different milestones are provided consisting of data schemes and data sets that allow students to follow the courses ff they did not manage to solve all exercises. The evaluation of the usage of the system shows that it improves the learning process and understanding of students and that students are very pleased with the system.