%0 Conference Paper %1 Hardt_2017 %A Hardt, Ryan %A Gutzmer, Esther %B Proceedings of the 18th Annual Conference on Information Technology Education %D 2017 %I ACM %K SQL %P 147-152 %R 10.1145/3125659.3125688 %T Database Query Analyzer (DBQA) %U https://doi.org/10.1145%2F3125659.3125688 %X While SQL has a relatively simple syntax with a small set of commands, it allows for complex query construction that is deceptively challenging. SQL is often the first declarative programming language learned by students, which requires a different analysis approach than that used to understand the procedural or object-oriented programming paradigms with which students are more familiar. While some tools exist to help assess the correctness of an SQL query or address syntax errors, few tools focus on query semantics. DBQA does so by illustrating the effects that clauses and conditions have on an SQL SELECT statement using a visualized, data-oriented approach. We expect DBQA's approach to query evaluation to feel more familiar to those with experience in procedural or object-oriented programming and to help those users better understand the semantics of complex queries. DBQA includes support for SQL queries containing JOINs and subqueries, which have been shown to be among the most difficult for students to construct.

@inproceedings{Hardt_2017, abstract = {While SQL has a relatively simple syntax with a small set of commands, it allows for complex query construction that is deceptively challenging. SQL is often the first declarative programming language learned by students, which requires a different analysis approach than that used to understand the procedural or object-oriented programming paradigms with which students are more familiar. While some tools exist to help assess the correctness of an SQL query or address syntax errors, few tools focus on query semantics. DBQA does so by illustrating the effects that clauses and conditions have on an SQL SELECT statement using a visualized, data-oriented approach. We expect DBQA's approach to query evaluation to feel more familiar to those with experience in procedural or object-oriented programming and to help those users better understand the semantics of complex queries. DBQA includes support for SQL queries containing JOINs and subqueries, which have been shown to be among the most difficult for students to construct. }, added-at = {2022-01-10T04:04:47.000+0100}, author = {Hardt, Ryan and Gutzmer, Esther}, biburl = {https://www.bibsonomy.org/bibtex/209597dd6c6f640d79614212db992473f/brusilovsky}, booktitle = {Proceedings of the 18th Annual Conference on Information Technology Education}, description = {Database Query Analyzer (DBQA) | Proceedings of the 18th Annual Conference on Information Technology Education}, doi = {10.1145/3125659.3125688}, interhash = {a77621be243cadc2518296076ade02b5}, intrahash = {09597dd6c6f640d79614212db992473f}, keywords = {SQL}, month = sep, pages = {147-152}, publisher = {{ACM}}, timestamp = {2022-01-10T04:04:47.000+0100}, title = {Database Query Analyzer ({DBQA})}, url = {https://doi.org/10.1145%2F3125659.3125688}, year = 2017 }