Relational Database Management Systems (RDBMS)

Part of the ModularMaster in Data Science programme

Participants will learn to access and communicate with databases using RDBMS tools over the first four days. Participants will be equipped with the skills necessary to store a large structural dataset within an RDBMS tool and enable them to efficiently prepare the dataset for data analysis. The last day will be allocated for a project where participants are given the opportunity to demonstrate their skills and knowledge.


Course Details

Full-Day class (9am - 5pm)
8, 15, 22, 29 Jul 24, 5, 19, Aug 24

Sign Up Now

Closing date: 10 Jun 24


Evening/Weekend class - Online virtual sessions
7 pm-10.30 pm / 9 am-12.30 pm)

1, 5, 8, 12, 15, 19, 22, 26, 29 Oct 24
5 Nov 24

Closing date:
2 Sep 24

 

Who Should Attend

 
  • Aspiring data analysts, database administrators or data engineers looking to gain understanding of database in the context for data science.

  • Business professionals such as project managers, executives, and decision-makers who need to understand concepts of RDBMS and how they can use data to make informed decisions.

Prerequisites

  • Participants should preferably have passed mathematics at GCE 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
  • Understand the types of data and databases

  • Appreciate the use of data dictionary and harness the potential metadata for data science

  • Acquire organisational dataset from data lakes and other democratised data sources for d. data enrichment purposes

  • Create a RDBMS to support Data Science pipeline

  • Familiar with common RDBMS tools for ETL process

  • Deconstruct complex relational tables

  • Leverage RDBMS to support big structural data preparation works for Data Science

Day 1
  • Types and Components of IT Infrastructure
  • File-based System vs Database Management System
  • Applications of Database Management System
  • Types of Data Models
  • Phases of Database Designing
  • First Phase: Requirement Collection and Analysis
  • Second Phase: Conceptual Design
  • Third Phase: Logical Design
  • Fourth Phase: Physical Design
Day 2
  • Introduction of Structured Query Language (SQL): DDL, DML, TCL, DQL, DCL
  • Creating Database with Data Definition Language (DDL)
  • Type of SQL Constraints
  • Modifying Database with Data Manipulation Language (DML)
  • Retrieving data from single table with Data Query Language (DQL)
  • Types of SQL operators: Logical, Comparison and Arithmetic
  • Constructing queries with comparison, logical and arithmetic operators
Day 3
  • Using functions related text searches: String and Wildcard functions
  • Using functions related date searches: Data and Time functions
  • Using SQL aggregate functions: Count, Sum, Avg, Min, Max
  • Using other clauses: Distinct, Fetch First, Top and Limit clauses
  • Retrieving data from multiple tables with Data Query Language (DQL)
  • Types of join operators: Inner, Full Outer, Left Outer, Right Outer joins 
  • Using set operators: Union, Intersect, Except 
Day 4
  • Constructing nested queries
  • Advanced SQL features: Views, Triggers, Functions
  • Writing efficient conditional expression
  • Understanding distributed database management systems
  • Business Intelligence and Data Warehouses
  • Big Data and NoSQL
  • Database Administration and Security
Day 5
  • Project Consultation (half-day)
Day 6
  • Project Presentation (half-day)
Assessment
  • In-class quizzes
  • Individual assessments
  • Group project

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 prevailing 9% GST.

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.


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:

  1. Reporting of national statistics and conducting of holistic continuing education training research and analysis;

  2. Facilitate the conduct of the relevant surveys and audits in relation to the Course;

  3. General administration of the Course including but not limited to processing of the subsidy provided by SSG;

  4. Publicity and marketing of the Course or other Courses to be provided by SSG or SUTD Academy; and

  5. 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:

  1. Attend and complete all lectures, class exercises, workshops and assessments;

  2. Complete the Course feedback at the end of the Course;

  3. Complete the post Course survey sent about 3 to 6 months after class attendance; and

  4. 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

  1. 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. 

  2. 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

  1. 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.

  2. Course enrolment is based on a first-come, first-served basis.

  3. 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")

  1. 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.

  2. 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 https://www.skillsfuture.gov.sg/enhancedsubsidy

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

  1. ETSS is an enhanced funding to enable SMEs to send their employees for training.

  2. SMEs will enjoy subsidies of up to 90% of the course fees when they sponsor their employees for SSG-funded certifiable courses.

  3. 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.

  4. To qualify, SMEs must meet all of the following criteria:
    - Organisation must be registered or incorporated in Singapore
    - Employment size of not more than 200 or with annual sales turnover 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 https://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/.
 


Funding under Post-Secondary Education Account ("PSEA")

The Post-Secondary Education Account (PSEA) is part of the Post-Secondary Education Scheme to help pay for the post-secondary education of Singaporeans.

This is part of the Government’s efforts to encourage every Singaporean to complete their post-secondary education. It also underscores the Government’s commitment to support families in investing in the future education of their children and to prepare them for the economy of the future. PSEA is not a bank account.

It is administered by the Ministry of Education (MOE) and is opened automatically for all eligible Singaporeans.

Account holders can use their PSEA funds to pay for their own or their siblings’ approved fees and charges for approved programs conducted by approved institutions.

However, you will have to check your eligibility and balance by contacting MOE first.

Contact MOE at (65) 6260 0777

E-mail to MOE at contact@moe.edu.sg

Click here for MOE website.