Course Overview

Domain
Business, Communication and Design
Infocomm Technology
Format
Short Course
Duration
2 days
Fee Subsidy
Up to 90% SF Funding

Database plays an essential role in almost all areas where computers are used in modern society.

When people deposit or withdraw funds, make airline reservations, and enroll in university courses, they will interact with databases to retrieve, record, or update their data.

Data fuels information systems to work properly and generate relevant output for data analytics. Designing and managing database is, therefore, critical in data analytics. Improper database design will likely impact on inaccurate and irrelevant analysis. Furthermore, personal data stored in the database requires careful attention and compliance with relevant jurisdictional regulations.

This 2-day workshop will equip you with system thinking to understand how the real-world activities are represented in database. You will then be guided to design a data model and develop a physical database using popular database management systems. You will also be facilitated to be aware of and comply with data protection-related requirements when working with personal data. Multiple case studies are used to help you fully comprehend database management and data protection issues.

Who Should Attend

  • Accountants
  • Auditors
avatar male
This course enables learners to learn how to build a schema and understand the intricacy of a database.
Lee Kok Hui
Analyst, MINDEF
avatar male
The content was very comprehensive and people with a wide range of knowledge of the topic can benefit from this course.
Cheong Shi Wei
Trainer, MINDEF
avatar male
Attending this course has allowed me to understand more about Database Management Systems (DBMS) and Structured Query Language (SQL) to associate with the data collected and stored for Photovoltaic (PV) Systems.
Daryl Haw
Engineer (Electrical), YTL Powerseraya Private Limited
avatar male
Data management and data protection has exposed me to how we can have good data governance and allowed me to appreciate how data can be classified in a clear and concise manner.
Tan Yi Guang
Systems Supervisor, MINDEF

What You Will Learn


System and Representational Model Concept

  • Understand the system thinking to generate database design that are faithful representations of the focal real-world phenomena

Conceptual Foundation of Relational Model

  • Learn the conceptual foundation of the relational model, the meaning and importance of primary keys, foreign keys, and related terminology

Data Modelling

  • Learn the basic stages of database development. Understand the purpose and role of a data model and practice on how to create an E-R diagram from source documents

Transforming Data Models into Database Design

  • Apply how to transform E-R data models into relational designs and a process for normalizing relations

Structured Query Language (SQL)

  • Learn and apply SQL statements for database administration

Data Protection and Privacy

  • Understand the general rules of data protection and privacy when working with personal data processing

Teaching Team

Arif Perdana
Arif Perdana

Associate Professor, Monash University

View profile

Schedule

Time Day Topics
9:00 am - 6:00 pm Day 1

Systems and Representational Model Concepts:

  • Getting started
  • System Thinking
  • Representational Model

Conceptual Foundation of Relational Model

Data Modelling:

  • E-R Diagram
  • Case Study on Data Modelling

Transforming Data Models into Database Design
Day 2

Database Design:

  • Case Study 1

Structured Query Language:

  • Data Definition Language
  • Data Manipulation Language
  • Data Query Language

Data Protection and Privacy

Assessment, Q&A, Summary

Certificate and Assessment

A Certificate of Attainment will be issued to participants who

  • Attend at least 75% of the course;
  • Undertake and pass non-credit bearing assessment during the course

Participants who meet the attendance requirement but do not pass the assessment will receive a Certificate of Participation.

Fee Structure

The full fee for this course is S$1,962.00.

Category After SF Funding
Singapore Citizen (Below 40) S$588.60
Singapore Citizen (40 & Above) S$228.60
Singapore PR / LTVP+ Holder S$588.60
Non-Singapore Citizen S$1,962.00 (No Funding)


Note: All fees above include GST. GST applies to individuals and Singapore-registered companies.

arrow--right
Funding
Learn more about funding schemes available
arrow--right
Learn for Life
The Learn for Life token may be used for this course

Course Runs

There are no upcoming course runs at the moment.

Subscribe to our mailing list to learn about the latest dates as soon as they become available.

SUBSCRIBE NOW

You May Also Like

Executive Education
Machine Learning and AI Data Analytics for the Semiconductor Industry
Data Analytics for Engineers

Learn to address semiconductor manufacturing complexities with AI and ML and gain hands-on experience using Python programming.

calendar-day
14 Jul 2025
clock-five
6.5 days over 3 months
delivery-mode
In-person
dollar-sign
SGD $7,793.50
Up to 90% SF Funding
tag
Data Science and Analytics, AI and Machine Learning, Executive Education
Business, Communication and Design
Data Forensics in Accounting
dataforensicsinaccounting

Supported by CPA Australia, this course teaches you how to plan, design, and apply data analytics tests to identify red flags of fraud.

calendar-day
14 Aug 2025
clock-five
2 days
delivery-mode
In-person
dollar-sign
SGD $1,962.00
Up to 90% SF Funding
tag
Accounting and Finance, Business Management, Data Science and Analytics, Audit
Infocomm Technology
Advanced Generative Text Artificial Intelligence
course-advancedgentextai-banner

Specialised micro-credential for strong technical and theoretical foundation in Natural Language Processing and Large Language Models (LLMs), focusing on AI-driven text automation, business intelligence, and conversational AI. Earn a Specialist Certificate and stack it towards a degree in Applied Computing.

calendar-day
01 Sep 2025
clock-five
3+ months
delivery-mode
Blended
dollar-sign
SGD $9,868.86
Up to 90% SF Funding
Stackable towards:

Bachelor of Science (Honours) in Applied Computing (via the CSM Pathway)

tag
AI and Machine Learning, Data Science and Analytics, Programming and Software Development, Competency-based Education
Engineering
Data Analytics for Engineering
Electrical and Electronic Engineering

Specialised micro-credential for strong technical and theoretical expertise in data analytics. Earn a Specialist Certificate and stack it towards a degree in Electrical and Electronic Engineering.

calendar-day
01 Sep 2025
clock-five
3+ months
delivery-mode
Blended
dollar-sign
SGD $10,006.20
Up to 90% SF Funding
Stackable towards:

BEng (Hons) Electrical & Electronic Engineering or Infrastructure & Systems Engineering

tag
Data Science and Analytics, AI and Machine Learning, Competency-based Education
Infocomm Technology
Information Security Risk Management and Audit
csm-appliedcomputing-banner

Specialised micro-credential for strong technical and theoretical expertise in information systems audit, security management, and risk management based on Agile. Earn a Specialist Certificate and stack it towards a degree in Applied Computing.

calendar-day
01 Sep 2025
clock-five
3+ months
delivery-mode
Blended
dollar-sign
SGD $9,868.86
Up to 90% SF Funding
Stackable towards:

Bachelor of Science (Honours) in Applied Computing (via the CSM Pathway)

tag
Information Security, Cybersecurity, Risk Management, Audit, Competency-based Education
Infocomm Technology
Machine Learning II: ML Fundamentals and Supervised Learning
machinelearningoneandtwo

This course establishes math and programming foundations for Machine Learning. It covers supervised learning techniques, Python programming and problem-solving. It is mapped to Smart Industry Readiness Index.

calendar-day
To be advised
clock-five
3 days
delivery-mode
To be advised
dollar-sign
To be advised
Up to 90% SF Funding
tag
AI and Machine Learning, Data Science and Analytics
CM-OP-201902000059