e-learning

SQL with R

View material

Abstract

In this tutorial you'll learn to use SQL via R. Some R and SQL experience is a pre-requisite.

About This Material

This is a Hands-on Tutorial from the GTN which is usable either for individual self-study, or as a teaching material in a classroom.

Questions this will address

  • How can I access databases from programs written in R?

Learning Objectives

  • Write short programs that execute SQL queries.
  • Trace the execution of a program that contains an SQL query.
  • Explain why most database applications are written in a general-purpose language rather than in SQL.

Licence: Creative Commons Attribution 4.0 International

Keywords: Foundations of Data Science, R, SQL, jupyter-notebook, rmarkdown-notebook

Target audience: Students

Resource type: e-learning

Version: 7

Status: Active

Prerequisites:

  • Advanced R in Galaxy
  • Advanced SQL
  • R basics in Galaxy

Learning objectives:

  • Write short programs that execute SQL queries.
  • Trace the execution of a program that contains an SQL query.
  • Explain why most database applications are written in a general-purpose language rather than in SQL.

Date modified: 2023-11-16

Date published: 2021-10-11

Authors: Avans Hogeschool, Helena Rasche, The Carpentries

Contributors: Anthony Bretaudeau, Helena Rasche, Marius van den Beek, Peter van Heusden, Saskia Hiltemann

Scientific topics: Software engineering

Activity log