No Events Currently Scheduled

Sorry, there are no upcoming events for this course, but please get in touch if you would like to be kept informed when events are scheduled in the future.

View our full training course calendar »

Request on-site training details Request on-line training details View all training courses

Course Details

Course Outline
Learning Outcomes
Materials
Prior Knowledge

Course Outline

Introduction to databases: An introduction to relational databases that implement the SQL standard. This will cover standard SQL table queries, as well as a brief discussion into indexing.
Data entry and retrieval: Using R as a means to query and modify data in a SQL database.
Data aggregation: A dplyr front end to data manipulation on a database.
Multiple tables: Dealing with and joining data that resides in multiple tables within a database.

Learning Outcomes

By the end of the day, participants will understand…

how to access relational databases via R
that R can directly query and modify data in a SQL database
how to use dplyr to access a database
that dplyr can run commands directly in the data.

Materials

Prior Knowledge

No knowledge of database software is assumed however familiarity with R programming and use of packages and functions is required. Successful completion of the Introduction to R course offered by Jumping Rivers is sufficient background.

Training Course Details

An Introduction to SQL (with R)

Course Level: Intermediate