{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,18]],"date-time":"2026-07-18T09:22:19Z","timestamp":1784366539477,"version":"3.55.0"},"reference-count":8,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2020,8]]},"abstract":"<jats:p>The SQL query language is the 'lingua franca' of transactional databases, and is essential for scalable data analytics. Learning SQL requires practical exercises with databases, including those parts of SQL with side-effects such as DDL statements, triggers, and stored procedures. Teaching this effectively to a non-technical audience is a challenge, especially in times of COVID-19 without face-to-face classes.<\/jats:p>\n          <jats:p>The Grok Learning platform allows to design self-paced online tutorials with auto-graded exercises - but it was originally built for teaching programming languages. In this demo, we show how we extended the Grok platform to teach SQL for Data Scientists with comprehensive online learning. Grok supports a rich user interface with interactive examples where students can explore and experiment with each example query. This is ideal for learning declarative querying. Each query is executed in its own sandbox on a freshly initialised database instance which allows to teach all parts of SQL including DDL statements, stored procedures, triggers and UDFs. At the same time, the platform scales to thousands of concurrent users, while maintaining interactive response times.<\/jats:p>","DOI":"10.14778\/3415478.3415526","type":"journal-article","created":{"date-parts":[[2020,9,14]],"date-time":"2020-09-14T18:46:35Z","timestamp":1600109195000},"page":"2989-2992","source":"Crossref","is-referenced-by-count":11,"title":["SQL for data scientists"],"prefix":"10.14778","volume":"13","author":[{"given":"Uwe","family":"R\u00f6hm","sequence":"first","affiliation":[{"name":"The University of Sydney, Australia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Lexi","family":"Brent","sequence":"additional","affiliation":[{"name":"The University of Sydney, Australia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Tim","family":"Dawborn","sequence":"additional","affiliation":[{"name":"Grok Learning, Australia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Bryn","family":"Jeffries","sequence":"additional","affiliation":[{"name":"Grok Learning, Australia"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2020,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Grok Learning Platform 2020. https:\/\/groklearning.com\/universities."},{"key":"e_1_2_1_2_1","volume-title":"Managing and Analysing Data with SQL","author":"Roehm U.","year":"2019","unstructured":"U. Roehm. Managing and Analysing Data with SQL, 2019. https:\/\/www.sydney.edu.au\/units\/OLET1301."},{"key":"e_1_2_1_3_1","first-page":"413","volume-title":"Proceedings of ACM SIGCSE2016","author":"Silva Y. N.","year":"2016","unstructured":"Y. N. Silva, I. Almeida, and M. Queiroz. SQL: From traditional databases to Big Data. In Proceedings of ACM SIGCSE2016, page 413--418, 2016."},{"key":"e_1_2_1_4_1","volume-title":"Proc. of the 26th Int'l Conf. on Computers in Education (ICCE)","author":"Stanger N.","year":"2018","unstructured":"N. Stanger. Semi-automated assessment of SQL schemas via database unit testing. In Proc. of the 26th Int'l Conf. on Computers in Education (ICCE), 2018."},{"key":"e_1_2_1_5_1","first-page":"570","volume-title":"SIGMOD2002","author":"Szalay A. S.","year":"2002","unstructured":"A. S. Szalay, J. Gray, A. Thakar, and P. Z. K. et al. The SDSS SkyServer: public access to the sloan digital sky server data. In SIGMOD2002, pages 570--581, 2002."},{"key":"e_1_2_1_6_1","volume-title":"SQL for Data Science","author":"Davis UC","year":"2020","unstructured":"UC Davis. SQL for Data Science, 2020. https:\/\/www.coursera.org\/learn\/sql-for-data-science\/."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/3328778.3372599"},{"key":"e_1_2_1_8_1","volume-title":"DB: Introduction to Databases","author":"Widom J.","year":"2020","unstructured":"J. Widom. DB: Introduction to Databases, 2020. https:\/\/www.classcentral.com\/course\/stanford-openedx-db-introduction-to-databases-1006."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3415478.3415526","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,17]],"date-time":"2025-09-17T02:20:51Z","timestamp":1758075651000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3415478.3415526"}},"subtitle":["designing SQL tutorials for scalable online teaching"],"short-title":[],"issued":{"date-parts":[[2020,8]]},"references-count":8,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2020,8]]}},"alternative-id":["10.14778\/3415478.3415526"],"URL":"https:\/\/doi.org\/10.14778\/3415478.3415526","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2020,8]]}}}