|
|
2014 » Papers » Volume 2 » E-Learning supported SQL Teaching 1. E-LEARNING SUPPORTED SQL TEACHING Authors: Siepermann Markus, Lackes Richard, Borgermann Chris Volume 2 | DOI: 10.12753/2066-026X-14-124 | Pages: 446-453 | Download PDF | Abstract
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. But then, students may "get lost" in the database: They can destroy the underlying data base scheme or delete too many data sets. Then, case studies or exercises that build upon each other cannot be solved correctly or students cannot verify if they solved the exercises correctly because they work on a modified data base different to the one that is assumed for the reference output of SQL queries. Besides, if 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. The e-learning system presented here solves this situation. It provides a database environment to each single student separated from other students so that it cannot be influenced by others. There, students can build their own "private" data base with which they can work during the courses. Predefined databases and schemes are provided for case studies and consecutive exercises so that students can always return to different milestones provided in the learning process. We analysed the usefulness of the system concerning the learning progress of students. In bachelor as well as master courses, the use of the system has clearly led to a better understanding of SQL. | Keywords
database exercises; e-learning exercises; intelligent tutoring systems; SQL |
|
|
|