A Lightweight Online Interactive Assessment Platform for SQL Teaching

Practical SQL exercises are important for database course learning and teaching. However, lots of existing database online SQL test platform requires complex environmental construction and can not work across platform. Backend database software running requires high level hardware configuration for large number of concurrencies from students during online test or examination. Light-weight, flexible and open-sourced database SQL exercise and assessment platform with pedagogical features for teaching is rare. This paper thus makes use of the recent frontend database technology to develop an open-sourced SQL assessment platform which is based on JavaScript engine and Node.js server for teaching and scoring of SQL programming skills. With this platform, the student can view the query results immediately after SQL execution and teachers can also collect exercisers’ information at the backend server. Browser fingerprint technique is also used to detect the plagiarism and cheating behaviour.