IBM
Using R with Databases
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.
Continue readingRP0103EN
R Programming
3k+ EnrolledAt 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
None.
Course Staff
Rav Ahuja
Rav Ahuja is a Senior Manager with IBM Canada Lab specializing in Data Science and Big Data analytics. He is part of the Emerging Technologies team and is involved in incubating offerings for Data and Analytics Professionals. Rav also leads the work on partnerships and private portals for BDU. He presents at events worldwide and has authored numerous papers, articles, books and courses on subjects in managing and analyzing data. Rav holds B. Eng. from McGill University and MBA from University of Western Ontario.
Grant Hutchison
Grant Hutchison had worked with IBM for 18 years as Senior Engineer and Manager at IBM Canada (1991-2009). He held various roles including: Software Development, Support, Quality Assurance, Marketing, Sales, Training, and Product Management. Since 2010, he has been focusing himself as a computer science teacher in Toronto District School Board. He has two Bachelor’s degrees and a Master degree in software engineering from three well-known universities in Ontario, Canada. Grant Hutchison published a book, and holds a patent in software system and database.
We would like to acknowledge Sandeep Sasha Joy for updating the labs in the course.
Estimated Effort
6 hours
Level
Beginner
Language
English