SQL Workshop
  • Overview
  • Readings
  • Code & Slides

Course outline and readings

Recommended readings

  • Munzert, S., Rubba, C., Meißner, P., & Nyhuis, D. (2014). Automated data collection with R: A practical guide to web scraping and text mining. John Wiley & Sons.

  • Beaulieu, A. (2009). Learning SQL: Master SQL Fundamentals. O’Reilly Media, Inc.

  • Stephens, R., Plew, R., & Jones, A. D. (2009). Sams teach yourself SQL in one hour a day. Sams Publishing.

  • Google BigQuery: Legacy SQL Functions and Operators.

Other online resources

  • RStudio Server Amazon Machine Image.

  • Workshop materials: collecting and analyzing social media data with R, by Pablo Barberá. LSE, January 2018.

© Jeffrey Arnold, 2016, Creative Commons Attribution 4.0 International License.