Facebook-f Linkedin Instagram Youtube Tiktok
Search
Short Course

Relational Database Design

Programme ScheduleDuration (days)Mode of DeliveryProgramme Code
18 Nov, 19 Nov 2024 | 9am-5.30pm2Classroom LearningTGS-2022012372

Course Overview

This course teaches relational database design. It covers how to abstract information into a data model, how to normalise 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.

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

Job Role Readiness

Data Analysts and Business Analysts.

Prerequisites

At least a polytechnic diploma.

Reserve Your Seat Now
Contact Us

Chat with us

This programme is part of

  • Professional Certificate in Database Management

    • Types of Available Fundings

  • Enhanced Training Support
  • SFEC
  • UTAP
  • PSEA

    • Testimonials


    I'm a fullstack developer and already have a working understanding of databases. I'm already familiar with most of the content, but the course goes more in-depth and enhanced my understanding of what I currently know. It's useful to plug in the gaps in small implementation details to become a better developer and also helps in communication with other developers as I'm introduced to the nomenclature for each concept I'm applying. I find the tools introduced useful as well since I can use them immediately in my work.

    Excellent teaching from experienced instructor! Definitely recommended!

    Excellent and professional trainer.

    Instructors


    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.

    A/Prof Danny Poo

    A/Prof Danny Poo

    A/Prof Danny Poo brings with him 35 years of Software Engineering and Information Technology and Management experience. A graduate from the University of Manchester Institute of Science and Technology (UMIST), England, Dr Poo is currently an Associate Professor at the Department of Information Systems and Analytics, National University of Singapore. Prior to joining the University, Dr Poo was with the System Operations at DBSBank, Singapore. A Steering Committee member of the Asia-Pacific Software Engineering Conference, Dr Poo is actively involved in Information Management and Healthcare Analytics research. A well-known speaker in seminars, Dr Poo has conducted numerous in-house training and consultancy for organizations, both locally and regionally. Dr Poo is the author of five books on Object-Oriented Software Engineering, Java Programming language and Enterprise JavaBeans.

    Dr Poo notable teaching credentials include:

    • Data Strategy
    • Data StoryTelling
    • Data Visualisation
    • Data Analytics
    • Machine Learning
    • Data Management
    • Data Governance
    • Data Architecture
    • Capstone Projects for Business Analytics
    • Software Engineering
    • Server-side Systems Design and Development
    • Information Technology Project Management
    • Health Informatics
    • Healthcare Analytics
    • Health Informatics Leadership.
    Industry Credentials
    • Deutsche Bank
    • Gemplus
    • Micron
    • NCR
    • PIL
    • PSA
    • Rhode-Schwarz
    • Standard Chartered Bank
    • ST Electronic
    • Monetary Authority of Singapore
    • Infocomm Development Authority
    • National Library Board
    • Ministry of Manpower
    • Nanyang Technological University
    • Nanyang Polytechnic
    • National University Hospital.

    Programme Fees


    Singapore Citizens Singapore PRs Enhanced Training Support for SMEs International Participants
    39 years old
    or younger    		 40 years old
    or older
    Full Programme Fee S$1,900.00 S$1,900.00 S$1,900.00 S$1,900.00 S$1,900.00
    Less: SSG Grant Amount S$1,330.00 S$1,330.00 S$1,330.00 S$1,330.00 -
    Nett Programme Fee S$570.00 S$570.00 S$570.00 S$570.00 S$1,900.00
    9% GST on Nett Programme Fee S$51.30 S$51.30 S$51.30 S$51.30 S$171.00
    Total Nett Programme Fee Payable, Including GST S$621.30 S$621.30 S$621.30 S$621.30 S$2,071.00
    Less Additional Funding - S$380.00 - S$380.00 -
    Total Nett Programme Fee Payable, Including GST, after additional funding from the various funding schemes S$621.30 S$241.30 S$621.30 S$241.30 S$2,071.00
    1. Total Nett Programme Fee Payable, including GST, after additional funding from various funding schemes.
    2. Participants must fulfill at least 75% attendance and pass all assessment components to be eligible for SSG funding.
    3. Please note that all external funding for courses is limited in duration and subject to eligibility and availability.

    Other Information

    This course is eligible for Union Training Assistance Programme (UTAP). NTUC members can enjoy up to 50% funding (capped at $250 per year) under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2025. Please click here for more information.

    Advanced Computing for Executives

    11 Research Link
    COM 3, #B1-07
    Singapore 119391
    Email: soc-ace@nus.edu.sg

    Facebook-f Linkedin Instagram Youtube Tiktok

    terms and conditions  

    course catalogue  

    Registration Guides  

    About us

    Programmes for individuals     

    Solutions for organisations  

    ONLINE LEARNING    Â