Database Creation, Manipulation, and Querying with SQL

Dates: 25 Apr, 28 Apr 2023 | 9am-5.30pm | Classroom Learning

Duration: 2 Days

Course Overview

This course teaches how to create a database, manipulate it with data, and make queries on the data using SQL, a structured, relational query language commonly used to retrieve data from databases. Learners will be taught how to create a MySql Database, single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation.

This module is part of Professional Certificate in Database Management.

Course Objectives

This course will equip learners with the following competencies:

  • Learn what is SQL
  • Learn SQL commands and code to create databases and tables
  • Learn SQL commands and code to manipulate databases such as insert, delete and update records
  • Learn the JOIN operation to query databases with multiple tables

    Who Should Attend

    Data Analysts, Business Analysts

    Prerequisites

    At least a polytechnic diploma.

    Course Convener

    (Click their photos to view their short biographies)

    eeeee Samantha Sow

    Ms Samantha SowMs Samantha Sow

    Course Fees

    Singapore Citizens
    39 years old or younger
    40 years old or older
    Singapore PRs
    Enhanced Training Support for SMEs
    International Participants

    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-2022012358 (Classroom Learning)
    TGS-2022012350 (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

    Singapore Citizens

    39 years old or younger

    Singapore Citizen

    40 years old or older
    Singapore PRs
    Enhanced Training Support for SMEs
    International Participants