Skip to main content Start main content

Workshop: Databases with R

Workshop/ Training/ Webinar

  • Date

    16 Feb 2023

  • Organiser


  • Time

    14:30 - 17:00

  • Venue

    Online via MS Teams  


Date: 16 Feb 2023 (Thu)

Time: 14:30 - 17:00

Venue: Online via MS Teams

Target Audience: All Students

Medium of Instruction: English


  • Basic R programming skill

Course Description:

  • Understand the steps to deploy SQLite database and MongoDB Atlas free cluster (MongoDB in the cloud). 
  • Get hands-on experience on using SQLite and MongoDB with RStudio by R packages RSQLite and mongolite.
  • Understand how to perform SQL statements and MongoDB CRUD operations by R language.


Course Outline:

  1. Relational database (SQL Database)
    1. Introduction to SQLite 
    2. Create and establish a connection to the database and table
    3. Input data from external CSV files to table
    4. Query/ insert/ update/ delete records from the table by R language 

  2. Non-relational database (NoSQL Database)
    1. Introduction to MongoDB 
    2. MongoDB Atlas free cluster
    3. Create and establish a connection to the database and connection
    4. MongoDB CRUD operations: create, read, update, and delete documents from the connection by R language

  3. Practical coursework throughout the workshop



Your browser is not the latest version. If you continue to browse our website, Some pages may not function properly.

You are recommended to upgrade to a newer version or switch to a different browser. A list of the web browsers that we support can be found here