Importing Data from Relational Databases in R 3

Focused View

Dan Tofan

1:44:13

8 View

01 - Course Overview

01 - Course Overview.mp4

01:46

02 - Connecting to a Database

02 - Overview.mp4

01:35

03 - Connecting to a SQLite Database with RSQLite.mp4

05:32

04 - Connecting to a PostgreSQL Database with RPostgreSQL.mp4

03:51

05 - Setting Up an ODBC Data Source.mp4

06:06

06 - Connecting with the RODBC Package.mp4

01:46

07 - Connecting with the odbc Package.mp4

03:15

08 - Troubleshooting Connection Issues.mp4

03:58

09 - Securing Credentials.mp4

05:56

10 - Summary.mp4

01:35

03 - Querying with SQL

11 - Overview.mp4

01:49

12 - Selecting.mp4

03:50

13 - Parameterizing Queries.mp4

04:05

14 - Summary.mp4

01:01

15 - Ordering.mp4

02:53

16 - Filtering.mp4

03:24

17 - Grouping.mp4

04:05

18 - Joining.mp4

04:58

19 - Updating.mp4

01:38

20 - Inserting.mp4

01:03

21 - Deleting.mp4

01:36

22 - Fetching Many Records.mp4

05:00

04 - Querying with dplyr

23 - Overview.mp4

01:47

24 - Selecting.mp4

05:11

25 - Mutating.mp4

03:10

26 - Piping.mp4

02:48

27 - Arranging.mp4

04:13

28 - Filtering.mp4

05:01

29 - Grouping.mp4

04:58

30 - Joining.mp4

04:10

31 - Summary.mp4

02:13

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Microsoft SQL

R Programming

Dan Tofan

Instructor's Courses

Dan started programming decades ago on a Spectrum clone and started his professional programming career in 2003. Eager to learn, Dan moved to Netherlands to study at the University of Groningen. Now, Dan is proud of his PhD thesis on decision making and knowledge acquisition in software architecture, and about a dozen publications with hundreds of citations. Dan used Microsoft technologies for many years, but migrated gradually to Python, Linux and AWS, to learn more of the computing world. Currently, Dan is a full-time Python programmer at the Romania office of a global company in the research domain.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.