SQLVis: Visual query representations for supporting SQL learners

D Miedema, G Fletcher - 2021 IEEE Symposium on Visual …, 2021 - ieeexplore.ieee.org
SQL is a typical query language for performing data analytics. Although its usage is
ubiquitous, learners experience that query formulation in SQL is error-prone and time …

Hidden gold for it professionals, educators, and students: Insights from stack overflow survey

OA Dada, G Obaido, IT Sanusi… - IEEE Transactions …, 2022 - ieeexplore.ieee.org
It is undeniable that technological advancements have taken significant changes in the
nature of work, resulting in the loss of many jobs and the emergence of new ones. As a …

“There is no ambiguity on what to return”: Investigating the Prevalence of SQL Misconceptions

D Miedema, M Liut, GHL Fletcher… - Proceedings of the 23rd …, 2023 - dl.acm.org
In recent years, database education has been receiving more attention, with research in
various directions such as the development of tools for education, the analysis of students' …

Talksql: A tool for the synthesis of sql queries from verbal specifications

G Obaido, A Ade-Ibijola… - 2020 2nd International …, 2020 - ieeexplore.ieee.org
Recent advances in the field of Natural Language Processing (NLP) have led to many
robust user interfaces (UIs) designed as intelligent tutoring systems (ITS) that help students …

Effect of semantic distance on learning structured query language: An empirical study

SS Shin - Frontiers in psychology, 2022 - frontiersin.org
Students of database courses usually encounter difficulties in learning structured query
language (SQL). Numerous studies have been conducted to improve how students learn …

A Cup of ChaiSQL: Benefits of Type Checking for SQL

D Orlov, D Miedema, N Yakovets - kilthub.cmu.edu
Structured Query Language (SQL) remains the main language for database interaction in
industry and education. However, SQL is known to be complex to master and associated …

DBSnap-Eval: Identifying Database Query Construction Patterns

YN Silva, A Loza, H Razente - Proceedings of the 27th ACM Conference …, 2022 - dl.acm.org
Learning to construct database queries can be a challenging task because students need to
learn the specific query language syntax as well as properly understand the effect of each …

PhD thesis: SQL Comprehension and Synthesis

G Obaido - arXiv preprint arXiv:2203.03469, 2022 - arxiv.org
Structured Query Language (SQL) remains the standard language used in Relational
Database Management Systems (RDBMSs) and has found applications in healthcare …

Helping Students with the Most Common Questions in an Introductory Databases Course

P Luik, M Lepp, K Kivilaan - 2023 IEEE Global Engineering …, 2023 - ieeexplore.ieee.org
The course “Introduction to Databases” focuses on teaching Structured Query Language to
non-IT students. As the learners have had no exposure to programming-related courses or …

[PDF][PDF] On Learning SQL: Disentangling concepts in Data Systems Education

DE Miedema - 2024 - research.tue.nl
The relational model was established in 1970 by Codd as a way to organize structured data.
The model stores all data grouped together in a set of tables related to one another by …