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.
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) |
$1,926.00 |
$577.80 |
| Singapore Citizen (40 & above) |
$1,926.00 |
$217.80 |
| Singapore PR / LTVP+ Holder |
$1,944.00 |
$583.20 |
| Non-Singaporeans |
$1,944.00 |
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 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 or LTVP+ Holder
- 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 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.
