Importing Data from Relational Databases in R
Offered By: Pluralsight
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.
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 dplyrCodecademy 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