items

An Introduction to SQL with R

Course Level: Intermediate (6 hours)

Using databases is a fundamental part of a data scientist’s role. The main focus of this training course is to introduce SQL databases, write your first SQL queries, and show 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 PostgreSQL database as an example for public courses. For in-house training, we are happy to adapt the course to match your database requirements.

Download course details

Book Course

  • An Introduction to SQL with R (15 July, Online)

    Starts:
    15 July (13:30)
    Ends:
    16 July (17:00)
    Price:
    £250300 ex VAT per person
    Venue Details:
    Online
    Duration:
    6 hours

    The course will run on 15 July. This course will start on 15 July and end on 16 July. We have an early bird offer of £250, which runs until 31 May. The price is £300 thereafter. The closing date for enrollment is 8 July 2026. The start and end times listed above are in UK local time.

Ask for more details about this course

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.

Request on-site training details Request online training details

Course Details

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

Session 1:

By the end of session 1 participants will…

  • understand the concepts of relational database management.
  • be introduced to the PostgreSQL dialect.
  • understand how to form a connection using {DBI}.
  • have learned how to run basic SQL commands from R:
    • extracting data with SELECT statements
    • filtering and organising data
    • creating tables and inserting data

Session 2:

By the end of session 2 participants will…

  • understand how to access a database using {dplyr} and {dbplyr}.
  • have learned how to run {dplyr} commands within the database.
  • understand how to join tables by matching variables.

This course does not include:

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

  • “Great insight into SQL databases in R. Content delivery was excellent and the knowledge acquired will be very useful in my job.”