SITizens Learning Credits

Overview

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 to 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, of critical in data analytics. Improper database design will likely impact on the inaccurate and irrelevant analysis. Further, personal data stored in the database required careful attention and comply with relevant jurisdictional regulations.

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

Teaching Team

What You’ll Learn

Topic Objectives
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.
 

Who Should Attend

Accountants and Auditors


SITizens Learning Credits (SLC) - Eligible Course

This course is SITizens Learning Credits (SLC) eligible. Please refer to the user guide how to register for courses utilising your SLC.

Find out more about SITizens Learning Credits (SLC).
 

Certificate and Assessment

A Certificate of Participation will be issued to participants who:
  • Attend 75% of the course, and
  • Undertake non-credit bearing assessment during the course

Schedule

Day 1
Welcome and Registration
Systems and Representational Model Concepts
a. Getting started
b. System Thinking
c. Representational Model
Tea Break
Conceptual Foundation of Relational Model
Lunch 
Data Modelling
a. E-R Diagram
b. Case Study on Data Modelling
Tea break
Transforming Data Models into Database Design
End of Day

Day 2
Registration and Recap
Database Design
a. Case Study 1
Tea Break
b. Case Study 2
Lunch 
Structured Query Language
a. Data Definition Language
b. Data Manipulation Language
c. Data Query Language
Tea break
Data Protection and Privacy
Assessment, Q&A, Summary 
End of Day

Fees

Category Full Fee After SF Funding
Singapore Citizen (Below 40) / Singapore PR / LTVP+ Holder $1,926.00 $577.80
Singapore Citizen (40 & above) $1,926.00 $217.80
Non-Singaporeans $1,926.00 Not Eligible

Note:
  • Please note that GST reflected in the fees table will be revised to 8% GST if payment is received by SIT on or after 1 January 2023. The company or trainee may be liable for an additional GST amount.
  • All figures include GST. GST applies to individuals and Singapore-registered companies.
  • You can opt for either SF Series Funding or Mid-Career Enhanced Subsidy. Both cannot be combined.

» Learn more about funding types available

Terms & Conditions:

SkillsFuture Funding


In order to be eligible for the 70% training grant awarded by SkillsFuture, applicants (and/or their sponsoring organisations where applicable) must:
  1.  Be a Singaporean Citizen or Singapore Permanent Resident or LTVP+ Holder
  2.  Not receive any other funding from government sources in respect of the actual grant disbursed for the programme

SkillsFuture Mid-Career Enhanced Subsidy

To be eligible for the 90% enhanced subsidy awarded, applicants (and/or their sponsoring organisations where applicable) must:
  1.  Be a Singaporean Citizen
  2.  Be at least 40 years old
  3.  Not receive any other funding from government sources in respect of the actual grant disbursed for the programme

SIT reserves the right to collect the balance of the course fees (i.e. the SSG course fee grant amount) directly from the trainees and/or their sponsoring organisations, where applicable, should the requirements not be fulfilled by the trainee.

SIT reserves the right to make changes to published course information, including dates, times, venues, fees and instructors without prior notice.
SITizens Learning Credits

Key Info

Venue Online
Time 09:00 AM to 06:00 PM
Date 16 Jan 2023 (Mon) to
17 Jan 2023 (Tue)
Registration Closing on: 26 Dec 2022
Apply Now

You May Also Like