4:30pm
to
6: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.
Summer 2014 Schedule:
Wednesday, June 18: Basics of R;
Wednesday, June 25: Statistical Analysis in R;
Wednesday, July 2: Graphics in R;
Wednesday, July 9: T-tests, ANOVA, and Rank Based Tests;
Wednesday, July 16: SQL in R;
Wednesday, July 23: Parametric Versus Semi/Nonparametric Regression Models;
Wednesday, July 30: Fractorial Experiments: Blocking, Confounding, and Fractional Factorial Designs;
Wednesday, July 16;
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 on the LISA website (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...
|
540-231-8354