I worked as the TA and led the lab session for course BA770, Business Analytics Toolbox III - Cloud Computing at BU Questrom, Summer '19.
All materials in this repo are self-designed.
The course mainly introduces relational databases and SQL including filtering, grouping, ordering, joining, along with advanced SQL techniques like correlated subquery, window function, and common table expression. Students learn and practice SQL skills via DataCamp and Google BigQuery. They also learn how to incorporate SQL queries in a Datalab-based Jupyter Notebook using Bigquery magics, and to train basic machine learning models via BigQuery.
(Please find the Datalab How to Guide in wiki)
Lab materials mainly include review slides and Qlab supplementaries:
- DataCamp slides help students review DC assignments and prepare for quizzes.
- Qwiklab slides highlight key takeaway in labs and provides tips. Students work on Qlabs in both lectures and lab sessions.
- Qlab supplementaries help students better understand SQL syntax and how SQL works behind stage.