Importing Data from Relational Databases in R 3
This course shows how R’s capabilities can help you retrieve data from relational databases and make it available to R for adding value with other operations, such as analysis and visualization.
What you'll learn
Data is very often stored in relational databases, which are a well-established technology for the last several decades. Your organization might use various relational databases, such as Microsoft SQL Server, Oracle, PostgreSQL, MySQL/MariaDB, or SQLite. In this course, Importing Data from Relational Databases in R, you will learn how R's capabilities can help you retrieve data from relational databases and make it available to R for adding value with other operations, such as analysis and visualization.
First, you will learn about connecting to relational databases. You will discover the possible options for connecting, including the pros and cons of each option. Sometimes things can go wrong, so you will learn some basic connection troubleshooting steps. Then you will explore how to make various SQL queries to a relational database: SELECT statements, filtering data, ordering data, grouping data, inner joins, as well as inserting and deleting values from a table. Additionally, you'll learn how to give parameters to a query and how to fix the security issues around this. Finally, you will determine how to query the database with dplyr, a very popular package for working with data frames that has capabilities of generating SQL queries for you.
Finishing this course will give you the confidence to import precisely the data you need from various relational databases into your R code.
Table of contents
- Version Check 0m
- Overview 2m
- Connecting to a SQLite Database with RSQLite 6m
- Connecting to a PostgreSQL Database with RPostgreSQL 4m
- Setting Up an ODBC Data Source 6m
- Connecting with the RODBC Package 2m
- Connecting with the odbc Package 3m
- Troubleshooting Connection Issues 4m
- Securing Credentials 6m
- Summary 2m