Learn how to use R with Databases

Posted on October 08, 2020 by Jacky Tea

Posted on February 15, 2017 by Rav Ahuja

R is a powerful language for data analysis, data visualization, machine learning, statistics. Originally developed for statistical programming, it is now one of the most popular languages in data science.

If you are a database professional (Data Engineer, DBA, Database Developer, etc.) and looking to leverage the power of R to analyze and visualize data in relational databases (RDBMSes), Cognitive Class has a free, self-paced online course to get you going quickly: Using R with Databases.

And if you are not yet familiar with R, there is also a free crash course in R to get you started: R 101.

If you are a Data Scientist or a Data Analyst, chances are that you are already familiar with the richness of the R programming languages and are already leveraging it for modeling, classification and clustering analysis, creating great graphs and visualizations, etc. But you may be hitting the memory limits of R when utilizing it for very large data sets.

Utilizing R with databases and data warehouses that are known for scalability and performance with large amounts of data is one mechanism to overcome the memory contraints of R. And the free course – Using R with Databases – will show you how.

This course starts with a comparison of R and Databases and discusses the benefits of using R with databases. It teaches you how to setup R for accessing databases and demonstrates how to connect to databases from R, specifically using interfaces like RJDBC and RODBC.

The course then goes on to show you how to query data from databases, get the results and visualize the analysis. It also covers some advanced topics like modifying and saving saving data in databases from R, as well as using database stored procedures from R.

Some databases also support in-database analytics with R, so you can benefit from the large amounts of memory and parallel processing features of databases while employing R for analysis. This course also helps you to learn about using in-database analytics with R.

Like other courses in Cognitive Class, each module in Using R with Databases, comes with hands-on labs so you can practice what you learn in the course and try out your own variations.

More over, the hands-on lab environment, called Cognitive Class Labs, is free, cloud-based, ready to use, and integrated within BDU so you don’t have to register for a new account or worry about installing software.

The course consists of 5 learning modules and after each module there are review questions. At the end of the course there is final exam.

Successfully passing the course (by proving your proficiency with review questions and final exam), marks your achievement with a a course completion certificate.

This course is part of Data Science with R learning path on BDU, and when you complete all courses in this learning path, you also earn an IBM badge that can be shared on your social profiles.

Enroll now for free and start Using R with Databases!

Tags: DatabaseDatabasesR