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.
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:
- Be a Singaporean Citizen or Singapore Permanent Resident
- 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:
- Be a Singaporean Citizen
- Be at least 40 years old
- 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.