Working with Databases in R – Video Presentation from NairobiR and R-Ladies Nairobi

[This article was first published on R Consortium, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

During this Working with Databases in R online presentation, Christopher Maronga shares his years of practical experience in accessing and working with Databases in R. R Consortium assisted by providing access to Meetup.com Pro as a platform for information sharing

John Mutiso, a statistician and member of Nairobi R, introduces the presentation on Working with Databases in R and points to the support of the R-Ladies Nairobi Organizers and NairobiR Organizers. 

Christopher Maronga, a data manager, then shares his practically gained experience on how we can turn R into a powerful tool for accessing MySQL databases and writing SQL code, pulling and querying data from within the R environment.

Maronga structured this session to be mainly hands-on learning by using coding examples and implementations. In his presentation he teaches how to efficiently connect R to RDBMS, query data stored in the RDBMS via R, connect and export data from REDCap and API security. He introduces what RDBMS is and how it is used for storage and management of data. He then goes on to explain REDCap and how it is a secure web application for building and maintaining online surveys and databases. Maronga then jumps into practical examples illustrated through the use of a local SQL database.

In the concluding section, it is emphasized that just knowing how to get data into R efficiently is half the battle in the path towards using R in data science. The speaker ended the session on the note that we should expect to see many more collaborations between R-Ladies Nairobi Organizers and NairobiR Organizers in the future.

We’re looking forward to it!

Full video here

By section:

The post Working with Databases in R – Video Presentation from NairobiR and R-Ladies Nairobi appeared first on R Consortium.

To leave a comment for the author, please follow the link and comment on their blog: R Consortium.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)