GitHub
LinkedIn
Twitter
YouTube
RSS

Training Course Details

An Introduction to SQL with R

An Introduction to SQL with R

Course Level: Intermediate

Using databases is a fundamental part of a data scientists role. The main focus of this training course is to introduce SQL databases and how R can be used to retrieve and manipulate data stored in a relational database. The course uses both the {DBI} and {dbplyr} packages.

We use the PostgresSQL database as an example for public courses. For in-house training, we are happy to adapt the course to match your database requirements.

An Introduction to SQL with R

Start Date:
Price:
Venue Details:
Time:
Duration:

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.
  • Standard SQL commands: Typical SQL commands when working with a database
  • Data aggregation: A {dplyr} and {dbplyr} 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 using SQL commands
  • how to use {dplyr} and {dbplyr} to access a database
  • that {dplyr} can run commands directly in the data
  • how to create database tables.

Materials

  • Page 1 of example course material for An Introduction to SQL with R
  • Page 2 of example course material for An Introduction to SQL with R
  • Page 3 of example course material for An Introduction to SQL with R
  • Page 4 of example course material for An Introduction to SQL with R
  • Page 5 of example course material for An Introduction to SQL with R

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. In particular, basic knowledge of {dplyr} is assumed.

Attendee Feedback