Learn to leverage the power of R to unlock the value of data in a relational database. Discover how to create database objects, populate a database, and issue SQL queries to retrieve and modify data with R. Understand how to utilize in-database analytics using R.
Master the basics of this important language and boost your data science career.
5 weeks, online
3-4 hours/week
R has become one of the top 5 programming languages for data analysis. It is used by organizations to analyze data in relational databases,, amongst other things. And this means individuals with strong skills in R are in high demand.
During this course you will be introduced to the benefits of using R with databases. You will learn how to connect to databases from R and how to create database objects. You will discover how to populate a database and issue SQL queries to retrieve and modify your data from R. Plus you will investigate more advanced topics such as using stored procedures and utilizing in-database analytics with R.
Overall, this course is intended to enable you to leverage the power of R to unlock the value of data in relational databases and overcome the limits of R for analyzing very large data sets.
This FutureSkills Prime/IBM course comprises five purposely designed modules that take you on a carefully defined learning journey.
It is a self-paced course, which means it is not run to a fixed schedule with regard to completing modules or submitting assignments. To give you an idea of how long the course takes to complete, it is anticipated that if you work 4 hours per week, you will complete the course in 5 weeks. However, as long as the course is completed by the end of your enrollment, you can work at your own pace. And don’t worry, you’re not alone! You will be encouraged to stay connected with your learning community and mentors through the course discussion space.
The materials for each module are accessible from the start of the course and will remain available for the duration of your enrollment. Methods of learning and assessment will include videos, reading material, and online exam questions.
As part of our mentoring service you will have access to valuable guidance and support throughout the course. We provide a dedicated discussion space where you can ask questions, chat with your peers, and resolve issues. Depending on the payment plan you have chosen, you may also have access to live classes and webinars, which are an excellent opportunity to discuss problems with your mentor and ask questions. Mentoring services will vary across packages.
Once you have successfully completed the course, you will earn your Certificate of Completion.
After completing this course, you will be able to:
This course is aligned with industry-approved occupational standards set by SSC NASSCOM. Once youve successfully completed this course, you will receive a Certificate of Completion that confirms you have:
The national occupational standards to which this course is aligned relate to the following job roles:
Once you have completed this course, you will earn your certificate.
We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.
1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.
Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.
Designed by the industry for the industry so you can build job-ready skills.
Competency building and global certifications employers are actively looking for.
Certificate of completion, IBM certificate
05 Modules
06 Skills
Discussion space
12 Hands-on labs
24 Videos
05 Review questions
01 Final exam
Creating and querying database objects from R
Creating and modifying database objects using R
Installation of MySQL
Review using Jupyter and R Dataframes
Setup your database instance
Accessing a database using R
Accessing your database using RJDBC
Accessing your Db2 Warehouse on Cloud database with RODBC
Creating and querying database objects from R (Optional)
Creating and modifying database objects using R
Using stored procedures from R
Modifying data using R
In-database analytics with R
Subscribe to get the latest tech career trends, guidance, and tips in your inbox.
There are multiple advantages to using R for data analysis.
This certificate earned through FutureSkills Prime:
Certificate of completion, IBM certificate
05 Modules
06 Skills
Discussion space
12 Hands-on labs
24 Videos
05 Review questions
01 Final exam
Creating and querying database objects from R
Creating and modifying database objects using R
Installation of MySQL
Review using Jupyter and R Dataframes
Setup your database instance
Accessing a database using R
Accessing your database using RJDBC
Accessing your Db2 Warehouse on Cloud database with RODBC
Creating and querying database objects from R (Optional)
Creating and modifying database objects using R
Using stored procedures from R
Modifying data using R
In-database analytics with R
Subscribe to get the latest tech career trends, guidance, and tips in your inbox.