Database with R

Date: 15 Mar 2024 (Fri) 

Time: 14:30 - 17:00

Venue: Online via Zoom

Target Audience: All Students

Medium of Instruction: English

Pre-requisite

• Basic R programming skill

What you will learn

• Understand the steps to deploy MySQL database and MongoDB Atlas free cluster (MongoDB on Cloud).
• Get hands-on experience on using MySQL and MongoDB with RStudio.
• Understand how to perform SQL statements and MongoDB CRUD operations by R programming language.
• Coursework will be provided to allow hands-on practice.

Course outline

• Relational database (SQL Database)
  • Introduction to MySQL
  • Create and establish a connection to the database and table
  • Input data from external CSV files to table
  • Query/ insert/ update/ delete records from the table
• Non-relational database (NoSQL Database)
  • Introduction to MongoDB
  • MongoDB Atlas free cluster
  • Create and establish a connection to the database and collection
  • MongoDB CRUD operations: create, read, update, and delete documents from the collection