Next course starts on
To be advised
Fee
SGD2,616* (as low as SGD304.80 after maximum funding) Learn More
Duration

4 days
Weeknights (7pm - 10:30pm)
Saturday (9am - 12.30pm)

Level
Basic

Who Should Attend

  • Front-End Web Developers
  • Entry-Level Full-Stack Web Developers
  • Web Developers

SYSTEM REQUIREMENTS

  • Functional Laptop: (1) CPU must be of at least intel core I3, (2) GPU must have an integrated graphics card and (3) RAM must be of at least 4GB

Overview

Designing a database for a web application is essential for delivering a reliable, scalable, and secure user experience. A well-designed web application database not only enhances application performance but also enables organisations to deliver seamless user experiences and achieve their business objectives effectively.

This practical course teaches participants to design, implement, and manage relational databases for dynamic web applications. Through hands-on projects building real-world applications (like movie review platforms and sports databases), participants will learn about core SQL operations and integrate databases with back-end systems (e.g., Express) and front-end frameworks (e.g., React) and build scalable, robust data layers essential for modern web application infrastructure, including implementing full CRUD functionality. 

This module is part of a sequential programme and is not available on a standalone basis.

Programme Partner


 

Learning Objectives

At the end of the 2-day course, participants will be able to:

  • Create relational databases using Structured Query Language (SQL), including tables with primary/ foreign keys
  • Write SQL queries to insert, retrieve, update, and delete data (CRUD operations)
  • Link multiple tables using JOIN operations for data relationships
  • Build basic database-driven web apps with JavaScript/ Node.js integration
  • Apply input sanitisation to prevent SQL injection vulnerabilities

Assessment

  • Individual assessment
     

CERTIFICATION

Upon meeting the attendance and assessment criteria, participants will be awarded a digital certificate for participating in each module. Please refer to our course policies to view the attendance and assessment criteria. 

Upon completion of all modules required for this programme within a maximum duration of 3 years, participants will be awarded a digital certificate.

Calculate Programme Fee

Click here for more information about SkillsFuture Credits (Not applicable for Company-sponsored participants)
For PSEA - Available only for Singapore Citizen below 31 (Not applicable for Company-sponsored participants)

Total Program Fee: SGD0.00

Fee Table

EMPLOYER-SPONSORED

PARTICIPANT PROFILE

SELF-SPONSORED

SME

NON-SME

Singapore Citizen < 40 years old

Permanent Resident

LTVP+

$784.80

(After SSG Funding 70%)

$304.80

(After SSG Funding 70%
+ ETSS Funding 20%)

$784.80

(After SSG Funding 70%)

Singapore Citizen ≥ 40 years old

$304.80

(After SSG Funding 70%
+ MCES Funding 20%)

$304.80

(After SSG Funding 70%
+ ETSS Funding 20%)

$304.80

(After SSG Funding 70%
+ MCES Funding 20%)

International Participant

$2,616

(No Funding)

$2,616

(No Funding)

$2,616

(No Funding)

All prices include 9% GST

Please note that the programme fees are subject to change without prior notice.

Post Secondary Education Account (PSEA)
PSEA can be utilised for subsidised programmes eligible for SkillsFuture Credit support. Click here to find out more.

Self Sponsored

SkillsFuture Credit

Singapore Citizens aged 25 and above may use their SkillsFuture Credits to pay for the course fees. The credits may be used on top of existing course fee funding.

This is only applicable to self-sponsored participants. Application to utilise SkillsFuture Credits can be submitted when making payment for the course via the SMU Academy TMS Portal, and can only be made within 60 days of course start date.

Please click here for more information on the SkillsFuture Credit. For help in submitting an SFC claim, you may wish to refer to our step-by-step guide on claiming SkillsFuture Credits (Individual).

Workfare Skills Support Scheme

From 1 July 2023, the Workfare Skills Support (WSS) scheme has been enhanced. Please click here for more details.

Employer Sponsored

Enhanced Training Support for SMEs (ETSS)

  • 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
  • Trainees must not be a full-time national serviceman
  • Trainees are eligible for ETSS funding only if their company's SME status is approved prior to the course commencement date. To verify your SME's status, please click here

Please click here for more information on ETSS.

Absentee Payroll

Employers who sponsor their employees for the course may apply for Absentee Payroll here. For more information, please refer to:

AP Guide (Non-SME Companies)
Declaration Guide (SME Companies)

Loading...

Loading schedule information...

Trainers