Dates: 18 Apr, 21 Apr 2023 | 9am-5.30pm | Classroom Learning
Duration: 2 Days
Course Overview
This course teaches relational database design. It covers how to abstract information into a data model, how to normalize the data model so that the database is free of anomalies, and how to transform the final, normalized data model into a relational database design, ready to be implemented.
This module is part of Professional Certificate in Database Management.
Course Objectives
This course will equip learners with the following competencies:
- Learn what is data and big data
- Learn how to design a relational database
- Learn to design a database from using data models
- Learn what normalisation is, and how to ensure database is free of anomalies
- Learn each of the three normal forms in Database Normalization
- Learn how to identify tables, and how to create relationships
Who Should Attend
Data Analysts, Business Analysts
Prerequisites
At least a polytechnic diploma.
Course Convener
(Click their photos to view their short biographies)
Ms Samantha Sow
Ms Samantha Sow
Ms. Samantha Sow is currently a Senior Lecturer in the department of Information Systems and Analytics at the National University of Singapore (NUS). She has over 8+ years of experience in Business Analytics and Data Science and she conducts training for both government agencies and corporate clients. Before joining NUS, she lectures at Temasek Polytechnic, teaching Business Analytics and Data Science to professionals, managers and executives (PMEs). Prior to being an academia, Samantha worked in the research and development at Infineon Technologies. Her research and project areas include Business Analytics, Data Mining, Predictive and Prescriptive Analytics.
She has a passion for engaging and inspiring participants to enhance their workplace analytics capabilities and increase business intelligence quotient within their organisations. Her interests lie in the applications of data analytics, predictive modelling and optimization techniques to derive actionable insights for commercial effectiveness. She is familiar with typical analytics tools such as Python, R, and SAS, SPSS and Tableau. She also has working knowledge in the area of Analytics, Data Science and Machine Learning.
Samantha completed her Master of Education from University of Sheffield and graduated from the National University of Singapore with a Bachelor’s in Engineering, First Class Honours. She has also completed THEC (Teaching in Higher Education) and ACTA (Advanced Certificate in Training and Assessment). She is a member of the adult associate educator (AEN) by Institute for Adult Learning (IAL), Singapore.
Her certifications include:
Microsoft Certified Azure Data Scientist Associate. Microsoft Certified Data Analyst Associate. SAS Certified Predictive Modeller in SAS Enterprise Miner. Tableau Certified Desktop Specialist.
Course Fees
Total Nett Programme Fee Payable, Including GST, after additional funding from the various funding schemes
Participants must fulfill at least 75% attendance and pass all assessment components to be eligible for SSG funding.
To enquire, email soc-ace@nus.edu.sg
To register, click Register
Course Code:
TGS-2022012372 (Classroom Learning)
TGS-2022012354 (Synchronous e-learning)
For members of public and NUS Alumnus (without R&G Voucher), please follow the steps below:
Select Short Course / Modular Course -> Apply for Myself -> Browse Academic Modules / Short Courses-> Module/Course Category -> Short Courses -> Browse Courses-> Advanced Computing for Exe (Faculty/Department / Unit)
Please download the user guide for NUS Online Application Portal after you click ‘Apply for Myself’ if you need assistance.
Course Fee Breakdown
Singapore Citizens
39 years old or youngerSingapore Citizen
40 years old or older