This course enables learners to learn how to build a schema and understand the intricacy of a database.
Lee Kok Hui
Analyst, MINDEF
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
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
Associate Professor, Monash University
View profile
Schedule
| Time | Day | Topics |
|---|---|---|
| 9:00 am - 6:00 pm | Day 1 |
Systems and Representational Model Concepts:
Conceptual Foundation of Relational Model Data Modelling:
Transforming Data Models into Database Design |
| Day 2 |
Database Design:
Structured Query Language:
Data Protection and Privacy Assessment, Q&A, Summary |
Certificate and Assessment
A Certificate of Participation will be issued to participants who
- Attend at least 75% of the course
- Undertake and pass non-credit bearing assessment during the course
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.
