This website is designed for the course Management Information System 33:136:370 offered at Rutgers Business School. Due to the COVID-19 pandemic, database teaching faces new challenges. For most students, the concept "database" is quite abstract if the instructor can't create a real playground for them; it's even harder to make the query meaningful. This website is a playground for students to practice their SQL skills.
This website is a pure front-end solution, can be held by free Github Pages, easy to share, easy to use, and free from risks. I have tried a Linux + Nginx + PHP + MySQL
solution, which I have used for my companies and research projects for a long time. But the server is not always free, and a real production environment should be free from the green hands. That's why I chose Github Pages + AlaSQL
to establish this playground. I also used Bootstrap as the framework and CodeMirror for code highlight.
The data models and questions in Practice 1 and Practice 2 are from Prof. Chon Lintakoon. Generating fake data, especially some polygraphs, is really time-consuming. It will be welcomed if you want to contribute to this platform with a well-defined test database and related query questions. It's easy to import the data and customize a new page for the new database.
You can practice your SQL skill here, just similar to the sqlzoo.net, but all the questions are from our slides, quizzes, assignments, and exams.
This website is memory-less. Once you refresh the page, all the tables will be restored to the default status, and all the queries history will be cleaned. So, please record queries by yourself if needed.
If you want to access a real production database, I have several choices. Please email me, and I will decide to grant the privileges or not.
We have the following databases
Class The database for the SQL lecture.
Practice 1: Grocery store scenario.
Practice 2: Tiny university scenario.
Exam II The last question in Exam II (Not Available Now)
In this page, we only have one table cities
. Click on the Submit button to submit your query, and see how it works.
You can modify the query, the result will be updated once you Submit.
If your query results in an error, the corresponding error message will be displayed.