Relational Databases and R

Lecturers	Dr. Hannes Mühleisen, CWI & Vrije Universiteit Amsterdam
Certificate	Confirmation of participation
Target audience	Novice and advanced R users from all professional groups.
Costs	CHF 600.- for members of UZH/ETH and associated institutes CHF 800.- for alumni of UZH/ETH, members of other universities, the public sector and non-profit organizations CHF 1200.- for companies Persons without current employment can register for the UZH/ETH fee upon request.
Course language	English
Course description	Much of the world’s information is held in relational database management systems. Their size and complexity make it impractical to transfer their entire contents or even tables for analysis in R. Recent developments in the R package ecosystem and R itself allow for using data stored in SQL databases directly and with surgical precision for complex analysis, model fitting and plotting. This course will consist of two parts, the first part will introduce the standard database query language SQL to enable users to surgically retrieve and reshape data coming from a database. The second part of the course will introduce the R integration with databases, starting with DBI, the dbplyr package for query construction and the dbplot package to directly plot from databases. We will also discuss data management systems embedded into R directly such as RSQLite or MonetDBLite and User-defined functions in data management systems with R. Dr. Hannes Mühleisen is senior researcher at the Database Architectures group at CWI, the national research institute for mathematics and computer science in the Netherlands. Hannes is also Assistant Professor at Vrije Universiteit Amsterdam. Hannes’ research revolves around data management for statistical processing, he is the author of several related R packages, for example the MonetDBLite package. Hannes has also published several scientific papers on the topic of integrating databases with R efficiently.
Dates	June 17-18, 2019 Registration
	After registering you will receive a short automatic confirmation by email. If you received this email you are successfully and bindingly registered for the course. For administrative reasons the written invoice won't be sent out until about two weeks before the course.