Overview

Database plays an essential role as computers are commonly used in today's modern society. The data collected from depositing or withdrawing funds, making online reservations or enrolment into a university course will need to be retrieved, recorded, or updated data constantly. Data fuels information systems to work and it generates relevant output for data analytics. Designing and managing databases are, therefore, critical in data analytics. Improper database design will likely have an impact on inaccurate and irrelevant analysis. Further, personal data stored in the database required careful attention and compliance with relevant jurisdictional regulations.

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

SIT Alumni: Before registering for courses, please activate your SITizens Learning Credits via the email sent by SIT Alumni Team, on behalf of SITLEARN Professional Development.

CLICK HERE TO APPLY (only for SIT Alumni)

Certificate and Assessment

A Certificate of Participation will be issued to participants who
  • Attend 75% of the workshop; and
  • Undertake non-credit bearing assessment (during 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
Database Design
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 Series Funding After SF Mid-Career
Enhanced Subsidy
Singapore Citizen (Below 40) / Singapore PR $1,926.00 $577.80 Not Eligible
Singapore Citizen (40 & above) $1,926.00 $577.80 $217.80
Non-Singaporeans $1,926.00 Not Eligible Not Eligible

Note:
  • 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 Series Course 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
  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 programme fees (i.e. the potential grant amount) directly from the applicants (and/or their sponsoring organisations where applicable) should the above requirements not be fulfilled.

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

Key Info

Venue SIT@Dover, 10 Dover Drive S138683
Time 09:00 AM to 06:00 PM
Date 16 Apr 2020 (Thu) to
17 Apr 2020 (Fri)
Registration is Closed.

You May Also Like