Professional Certificate in Web Application Development Module: Back-End Web App Development with Databases (Synchronous e-Learning)
- Analytics & Tech
- Innovation & Business Improvement
This programme is conducted online.
4 days
Weeknights (7pm - 10:30pm)
Saturday (9am - 12.30pm)
Who Should Attend
- Aspiring web developers who want to build full- stack, database-driven web applications to solve real-world problems
- Anyone with an interest in learning the fundamentals of web app design and development
- Professionals with coding experience but new to web app development
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
Through this course, participants will learn about data integrity, normalisation, database structure, security; for hands-on, participants will create a simple web app to authenticate users and retrieve user data.
This module is part of a sequential programme and is not available on a standalone basis.
Learning Objectives
- Install, set up, and run a MySQL database on Windows, Mac, and the cloud
- Describe the characteristics of a relational database, and understand SQL terms such as databases, schemas, tables, and rows
- Build simple to intermediate SQL queries to extract data from a given dataset
- Work with multiple tables using multiple keys and different types of join operations
- Understand the need for, and perform simple data normalisation
- Understand how and why database security issues arise, and how to guard against them
- Create a functional CRUD (Create, Read, Update, Delete) web app with user authentication against a MySQL database
- Appreciate the availability of different SQL implementations
Topic/Structure
- Get started with installation for WAMP/ MAMP/ LAMP stacks, and an introduction to using online MySQL services like AWS
- Introduction to relational databases and SQL syntax
- Database schemas, tables, and rows
- Using keys and indexes
- Working with queries: INSERT, SELECT, UPDATE, DELETE, and constraints
- Working with multiple tables using joins and multiple keys
- Database normalisation: why and how
- Security issues
- Introduction to Postgres
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
Fee Table
| COMPANY-SPONSORED | |||
|
PARTICIPANT PROFILE |
SELF-SPONSORED |
SME |
NON-SME |
|
Singapore Citizen < 40 years old Permanent Resident LTVP+
|
$523.20 (After SSG Funding 70%) |
$203.20 (After SSG Funding 70% |
$523.20 (After SSG Funding 70%) |
|
Singapore Citizen ≥ 40 years old |
$203.20 (After SSG Funding 70% |
$203.20 (After SSG Funding 70% |
$203.20 (After SSG Funding 70% |
|
International Participant |
$1,744 (No Funding) |
$1,744 (No Funding) |
$1,744 (No Funding) |
All prices include 9% GST
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.
Company 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 will be able to enjoy ETSS funding only if the company's SME's status has been approved. To verify your SME's status, please click here.
Please click here for more information on ETSS.
Absentee Payroll
Companies 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)
Intake Information
Next Intake: To be advised
You might also be interested in
