Relational Database Management Systems

Part of the ModularMaster in Data Science (Healthcare) programme

Relational Database Management Systems (RDBMS) play a crucial role in the initial stage of the data science lifecycle, providing a strong foundation for effective data management and setting the stage for successful data analysis. With RDBMS, data professionals can efficiently handle large volumes of data, ensuring its integrity, consistency, and easy accessibility. The optimized storage, retrieval, and maintenance processes offered by database management systems enhance overall data management efficiency. Additionally, by mastering SQL queries, data professionals can streamline data pre-processing within the database system, ensuring a certain level of data quality before analysis and simplifying the exploratory phase of data analysis projects. Moreover, their understanding of efficient database design, data import, and integration from diverse sources enables seamless data integration, ensuring data consistency and integrity, and facilitating analysis, reporting, and visualization processes.

This course, spanning a duration of five days, is specifically designed to equip participants with the skills in designing, accessing and managing databases using RDBMS tools. Participants will be actively involved in a healthcare-related project throughout the module. The final day, which is split into two half-days on separate weeks, will be dedicated to project consultation and project presentation.

Plan your learning path

This course can be taken as a module on its own or as part of the Graduate Certificate in Fundamentals in Data Science (Healthcare) or ModularMaster in Data Science (Healthcare).

Who Should Attend

Catering to healthcare professionals and individuals aspiring to join the healthcare industry, this course is specifically designed to facilitate a comprehensive understanding of both core concepts and practical application of relational database management systems (RDBMS) in healthcare settings. It is highly recommended for clinicians, administrators, and managers working within healthcare organizations to gain knowledge and techniques to effectively design, access, and manage databases in various healthcare contexts.

Prerequisites

Participants should preferably have passed mathematics at least ‘O’ Level or equivalent.
Participants should be conversant with basic IT skills such as software installation, file c. management and web navigation.
Participants are encouraged to complete the Foundation of Data Science before enrolling for this course
Participants are required to bring their laptops.

Programme Outline

Learning Objectives and Structure

Design databases with best practices, focusing on creating appropriate schemas, defining tables, and establishing relationships between entities.
Write SQL statements for creating, modifying, and retrieving data from databases.
Implement a simple database-driven application by applying the concepts of database management.
Understand healthcare case studies shared by SingHealth faculty members to gain insights into real-world scenarios.
Utilise curated public healthcare datasets to perform hands-on activities and assignments, fostering practical experience and understanding of the subject matter.

Day 1 - Introduction of Database Management System

Types and components of IT infrastructure
Applications of database management system
Phases of database designing (conceptual, logical, physical)
Database normalisation
Evolution of data ecosystem in healthcare
Example of data governance in healthcare

Day 2 - Basic Structured Query Language (SQL)

Creating database with Data Definition Language
Modifying database with Data Manipulation Language
Type of SQL Constraints

Day 3 - Advanced Structured Query Language (SQL)

Retrieving data from single table with Data Query Language
Using functions related text and data searches
Retrieving data from multiple table with Data Query Language
Types of join operators: Inner, Full Outer, Left Outer, Right Outer joins
Creating Views, Triggers, Functions

Day 4 - Practical application of database

Case study in healthcare
Hands-on data exploration for inpatient and outpatient domains

Day 5 - Consultation/ Project presentation

Project Consultation

Each group of participants will present the progress of their projects and have the opportunity to ask questions and clarify any doubts pertaining to their projects.

Project Presentation

Each group of participants will showcase their work and respond to questions during a Q&A session.

Course Fees and Funding

Full course fee inclusive of prevailing GST	You pay S$4,905.00
SkillsFuture Course Fee subsidy (70%) For Singapore Citizens < 40 years old For Permanent Residents	You pay S$1,471.50
Mid-Career Enhanced Subsidy (90%) For Singapore Citizens ≥ 40 years old	You pay S$571.50
Enhanced Training Support for SMEs (90%) For SME - Sponsored employees	You pay S$571.50

The above module fee payable is inclusive of 9% GST.

Register your interest

Name:
Email Address:
Mobile Number:
What are you interested in?: Foundation of Data Science Data Storytelling with Visualisation Relational Database Management Systems Data Wrangling and Preparation with Programming Data Validation and Statistical Analysis with Programming Data Science Modelling with Programming All of the above (for the full (Healthcare) ModularMaster in Data Science)
Where did you primarily hear about the programme from?:
Subscribe to our mailing list : Yes No By subscribing to this mailing list, I agree that SUTD may collect, retain and utilise my Personal information, as furnished herein, for SUTD Academy’s communications including programme information, invitation to events, news updates and other related purposes, in accordance with the Personal Data Protection Act 2012.

Instructor

Thia Wei Soon
Instructor, SUTD Academy

Wei Soon has more than ten years of experience working in the manufacturing and IT sectors. He worked as a data scientist using data analytics and machine learning to deliver actionable insights and drive strategic marketing initiatives. In recent years, as a technology consultant, he successfully helped clients to streamline enterprise operations and achieved cost saving through the adoption of robotic process automation.

Wei Soon has a Master of IT in Business Artificial Intelligence from Singapore Management of University and a B.Eng in Mechanical Engineering from Nanyang Technological University. He is proficient with tools such as Tableau, Jupyter, RStudio, MS Visual Studio, Automation Anywhere, UiPath, and programming languages such as Python, R, C#, HTML5, and JavaScript.

Narayan Venkataraman
Assistant Director, Data Management & Informatics, Changi General Hospital

Narayan (Nari) is a Data Science and Biomedical professional with more than 22 years of experience in healthcare with diverse portfolio spanning data science, health informatics, data governance, medical technology, clinical quality and operational analytics, patient safety and risk management.

He is currently the Assistant Director, Data Management & Informatics at Changi General Hospital, Singapore. Recipient of the Singapore Commendation Medal 2022 for Covid19, he is a member of the CGH Covid19 Taskforce and many strategic committees at CGH and SingHealth (SHS). He has completed many medical projects across the Asia-Pacific region representing Singapore MOH and MFA. He is also an honorary biomed consultant for Smiles Asia and has volunteered for many surgical missions in Asia and Oceania. His current academic interests cover robotic process automation, AI/Machine Learning, data visualisation, risk analytics and enterprise data literacy.

Emileen Chia Siok Chen
Assistant Director, Management Information, Sengkang General Hospital

Emileen obtained both her BEng and MSc from Nanyang Technological University, Singapore. From 2006-2014, she has worked in the Institute of Mental Health and Agency for Integrated Care (AIC). Her stinct in the Institute of Mental Health where she was in charge of hospital data analysis fueled her passion in this area. She joined Sengkang General Hospital in 2014 to set up the Management Information department and is currently holding the designation of Assistant Director, Management Information.

Dr Ho Vui Kian
Head & Senior Consultant Intensive Care Medicine, Anaesthesiology & Perioperative Sciences, Sengkang General Hospital / Head & Senior Consultant, Surgical Intensive Care, Singapore General Hospital

Dr Ho is an Anaesthesiologist and Intensivist. He completed his specialist training in Anaesthesiology in 2012. He was awarded a HMDP fellowship in 2013 for Intensive Care at the Alfred Hospital in Australia, and completed his subspecialty training in Intensive Care Medicine in 2015.

He was appointed Head, Intensive Care Medicine, Sengkang General Hospital in October 2017, and concurrently appointed Head, Surgical Intensive Care, Singapore General Hospital in July 2021.

Policies and Financing Options

SSG Funding Terms and Conditions

Use of Personal Details

In consideration of the subsidy provided by SkillsFuture Singapore Agency (“SSG”) through the SUTD Academy for the Course,

I consent to:

The collection, use and disclosure to relevant third parties of my personal data by the SUTD Academy including but not limited to personal particulars, attendance records, assessment/performance records, for the following purposes:

Reporting of national statistics and conducting of holistic continuing education training research and analysis;
Facilitate the conduct of the relevant surveys and audits in relation to the Course;
General administration of the Course including but not limited to processing of the subsidy provided by SSG;
Publicity and marketing of the Course or other Courses to be provided by SSG or SUTD Academy; and
SSG or its Appointed Auditors or Nominated Representatives to directly contact Course Participant to obtain information deemed necessary for the purposes of conducting effectiveness survey or audits in relation to the Course.

I agree to:

Attend and complete all lectures, class exercises, workshops and assessments;
Complete the Course feedback at the end of the Course;
Complete the post Course survey sent about 3 to 6 months after class attendance; and
Sign up for a personal email account.

SUTD Privacy Statement

For more information on SUTD's privacy statement, please visit https://sutd.edu.sg/Privacy-Statement.

SUTD Terms and Conditions

Methods of Payment

Learn more about the available payment modes.

Cancellation & Refund Policy

If a written notification is sent to sutd_academy@sutd.edu.sg within 24 hours after course registration deadline there will be no cancellation charges. A full refund will be made.
No refund is provided if written notification is more than 24 hours after course registration deadline. SUTD Academy reserves the rights to collect the full fee amount from the participant.

Replacement Policy

Companies may replace participants who have signed up for the course by giving a 3-working day notice before the course commencement date to sutd_academy@sutd.edu.sg. Terms and conditions apply.

Registration Policy

Course may be cancelled due to insufficient participants. SUTD Academy will not be responsible or liable in any way for any claims, damages, losses, expenses, costs or liabilities whatsoever (including, without limitation, any direct or indirect damages for loss of profits, business interruption or loss of information) resulting or arising directly or indirectly from any course cancellation.
Course enrolment is based on a first-come, first-served basis.
SUTD Academy reserves the right to change or cancel any course or instructor due to unforeseen circumstances.

Types of Funding

Funding under Mid-Career Enhanced Subsidy ("MCES")

MCES is an enhanced Subsidy to encourage mid-career individuals to upskill and reskill, thereby helping them to remain competitive and resilient in the job market. With this, all Singaporeans aged 40 and above will receive higher subsidies of up to 90% course fee subsidy for SSG-funded certifiable courses.
Individuals/employers are not required to submit an application for the MCES. Those pursuing SSG-funded programmes will be charged the appropriate subsidised fees by SUTD Academy if they are eligible MCES. Individuals/employers will only need to pay the nett fee (full course fee after SSG's grant).

For more info, please visit SkillsFuture website at http://www.skillsfuture.sg/enhancedsubsidy

Funding under Enhanced Training Support for SMEs ("ETSS")

ETSS is an enhanced funding to enable SMEs to send their employees for training.
SMEs will enjoy subsidies of up to 90% of the course fees when they sponsor their employees for SSG-funded certifiable courses.
In addition to higher course fee funding, SMEs can also claim absentee payroll funding of 80% of basic hourly salary at a higher cap of $7.50 per hour. SMEs may apply for the absentee payroll via the SkillsConnect system.
To qualify, SMEs must meet all of the following criteria:
- Organisation must be registered or incorporated in Singapore
- At least 30% local shareholding by Singapore Citizens or Singapore Permanent Residents
- Employment size of not more than 200 (at group level) or with annual sales turnover (at group level) of not more than $100 million
- Trainees must be hired in accordance with the Employment Act and fully sponsored by their employers for the course
- Trainees must be Singapore Citizens or Singapore Permanent Residents

For more info, please visit SSG website at http://www.ssg.gov.sg/programmes-and-initiatives/funding/enhanced-training-support-for-smes1.html

Funding under Union Training Assistance Programme ("UTAP")

UTAP is a training benefit for NTUC members to defray their cost of training. This benefit is to encourage more union members to go for skills upgrading.

NTUC members enjoy 50% unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP (Union Training Assistance Programme).

For more info, please visit https://e2i.com.sg/individuals/ntuc-education-and-training-fund/.