A1 Alkuperäisartikkeli tieteellisessä aikakauslehdessä
Teaching tip : a notation for planning SQL queries (2019)

Taipalus, Toni (2019). Teaching tip : a notation for planning SQL queries. Journal of Information Systems Education, 30 (3), 160-166. http://jise.org/Volume30/n3/JISEv30n3p160.pdf

JYU-tekijät tai -toimittajat

Julkaisun tiedot

Julkaisun kaikki tekijät tai toimittajat: Taipalus, Toni

Lehti tai sarja: Journal of Information Systems Education

ISSN: 1055-3096

Julkaisuvuosi: 2019

Volyymi: 30

Lehden numero: 3

Artikkelin sivunumerot: 160-166

Kustantaja: Information Systems and Computing Academic Professionals

Kustannuspaikka: Wilmington

Julkaisumaa: Yhdysvallat (USA)

Julkaisun kieli: englanti

Pysyvä verkko-osoite: http://jise.org/Volume30/n3/JISEv30n3p160.pdf

Avoin saatavuus: Open access -julkaisukanavassa ilmestynyt julkaisu


Structured Query Language (SQL) is still the de facto database query language widely used in industry and taught in almost all university level database courses. The role of SQL is further strengthened by the emergence of NewSQL systems which use SQL as their query language as well as some NoSQL systems, e.g., Cassandra and DynamoDB, which base their query languages on SQL. Even though the syntax of SQL is relatively simple when compared to programming languages, studies suggest that students struggle with simple concepts due to working memory constraints when learning SQL. This teaching tip presents a novel, simple, and intuitive notation for planning more complex SQL queries, which 1) facilitates the learning of SQL by providing students with a big picture of a particular data demand in regard to the database structure and 2) separates the logic of a data demand from the syntax and semantics of SQL, thus alleviating the strain on the student’s short-term memory. The notation can also be applied when discussing SQL semantics during the teaching process without focusing on the syntactical nuances of the language.

YSO-asiasanat: SQL; kyselykielet; tiedonhallintajärjestelmät; visualisointi; opetus

Vapaat asiasanat: structured query language (SQL); query language; data management; data visualization; teaching tip

Liittyvät organisaatiot

OKM-raportointi: Kyllä

Raportointivuosi: 2019

JUFO-taso: 1

Viimeisin päivitys 2020-09-07 klo 11:53