YoVDO

Importing Data from Relational Databases in R

Offered By: Pluralsight

Tags

R Programming Courses Data Analysis Courses Data Visualization Courses Relational Databases Courses dplyr Courses

Course Description

Overview

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.

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.

Syllabus

  • Course Overview 1min
  • Connecting to a Database 33mins
  • Querying with SQL 35mins
  • Querying with dplyr 33mins

Taught by

Dan Tofan

Related Courses

Learn dplyr
Codecademy
Learn R
Codecademy
Data Manipulation with dplyr in R
Coursera Project Network via Coursera
Data Visualization using dplyr and ggplot2 in R
Coursera Project Network via Coursera
Analyzing Election and Polling Data in R
DataCamp