The following list provides links to the slides code used in the guided coding sessions. The solutions to the challenges will be made available through RStudio Server.
SLIDES: Querying large-scale online datasets with SQL and Google BigQuery
Introduction to RMarkdown and Setup (.Rmd file)
Basics of SQL queries (.Rmd file)
Coding challenge 1 (.Rmd file)
Querying multiple tables. Grouping and aggregating operations. (.Rmd file)
Coding challenge 2 (.Rmd file)
Introduction to Google BigQuery (.Rmd file)
Analyzing a billion-row dataset with Google BigQuery (.Rmd file)
Coding challenge 4 (.Rmd file)