5:30pm to 7:30pm |
|
LISA Statistics Short Course: SQL in R
(Academic)
LISA SHORT COURSES IN STATISTICS
LISA (Virginia Tech's Laboratory for Interdisciplinary Statistical Analysis) is providing a series of evening short courses to help graduate students use statistics in their research. The focus of these two-hour courses is on teaching practical statistical techniques for analyzing or collecting data. See www.lisa.stat.vt.edu/?q=short_courses for instructions on how to REGISTER and to learn more.
Fall 2014 Schedule:
Tuesday, October 7: Design of Experiments;
Tuesday, October 14: SQL in R;
Tuesday, October 21: Survey;
Tuesday, October 28: Introduction to R;
Tuesday, November 4: Generalized Linear Models and Categorical Data Analysis in R;
Tuesday, November 11: Graphics in R;
Tuesday, November 18: A tutorial for shiny in R;
Tuesday, December 2: Data Analysis in SAS;
Tuesday, October 14;
Instructor: Xinran Hu;
Title: SQL in R;
Course Information:
Structured Query Language (SQL) is the prevailing language to communicate with datasets today. In the era of big data, SQL assumes a vital role in many fields. However, SQL by itself provides very limited statistical functionality. Fortunately, many popular statistical packages have integrated SQL as a built-in part or add-on package.
The topics will be covered in this short course include basic SQL concept, querying commands from a single dataset (select, where), aggregate function (group by, having, sum, avg, max, min), querying commands from multiple dataset (join). Attendees can practice these commands with an online SQL learning source, sqlzoo.net. We will also introduce package sqldf in R and demonstrate its effectiveness with the individual household electric power consumption dataset from UCI data repository, http://archive.ics.uci.edu/ml/datasets/Individual+household+electric+power+consumption.
This short course is an introductory course for researcher who wants to learn the basic SQL commands. Prior experience with SQL or programming is NOT required. Experience with R is preferred but NOT required. More LISA short courses about R can be found at www.lisa.stat.vt.edu/?q=short_courses.
Follow us on Facebook (www.facebook.com/Statistical.collaboration) or Twitter (www.twitter.com/LISA_VT) to be the first to know about LISA events! More information...
|