Using R with Databases
|
Learn how to use R with databases to manage and analyze large datasets. Explore the power of R for database operations, from querying to visualization, and leverage SQL integration for efficient data handling and analysis.
At a Glance
The intent of this course is to teach you how to unlock the power and magic of R to analyze data in relational databases. It will show you how to connect to relational databases, access and query the database, update and modify the data, analyze it and perform simple visualizations.
About This Course
- Do you want to leverage the power of R to unlock the value of data in relational databases?
- Are you a SQL professional and looking to get skilled in data science?
- Are the limits of R programming language preventing you from analyzing very large data sets?
Course Syllabus
- Module 1 – R and Relational Databases
- Module 2 – Connecting to Relational Databases using RJDBC and RODBC
- Module 3 – Database Design and Querying Data
- Module 4 – Modifying Data and Using Stored Procedures
- Module 5 – In-Database Analytics with R
Recommended skills prior to taking this course
- None
Grading scheme
- The minimum passing mark for the course is 70%
Requirements
Course Staff
Grant Hutchison
We would like to acknowledge Sandeep Sasha Joy for updating the labs in the course.
User Reviews
Be the first to review “Using R with Databases”
Related Products
Difference in Differences for Causal Inference
Learn how to use the difference in differences method to estimate effects by analyzing trends over time.
Learn R
Learn how to code and clean and manipulate data for analysis and visualization with the R programming language.
Learn the Basics of Causal Inference with R
Learn how to use causal inference to figure out how different variables influence your results.
Creating Nested and Special-purpose Functions in R
This course will teach you the fundamentals of understanding, using, and creating your own custom special purpose functions within R.
R for Programmers
An introduction to the fundamentals of the R programming language for experienced programmers.
Learn ggplot2
Learn how to create visualizations using the popular R package ggplot2
There are no reviews yet.