Querying Data with SQL

Offered by School of InfoComm Technology

Short Course / 2 days / TGS-2022014740

Note: The Jun 2023 run for this course is now open, please click on the APPLY button to submit your application. To receive an alert about the future runs for this course, please click on the INDICATE INTEREST button. Thank you.
Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Certification
Entry Requirements
Course Fees

Course Information

This is a basic 2-day training for learners who need to perform data query from databases.

Learning Outcomes

To equip learners with basic Structured Query Language (SQL) skills for data extraction. Through the course, learners will acquire knowledge about the nature and purpose of databases, and how to work with databases for the storage, retrieval and manipulation of vast amounts of data.

Course 
Schedule

Course Date: TBC
Application Period: TBC
Duration: 2 days lesson (including 1h online test)

Time: 9am to 6pm
Delivery Mode: Classroom
Venue: Ngee Ann Polytechnic

Ngee Ann Polytechnic reserves the right to reschedule / cancel any programme, modify the fees and amend information without prior notice.

Lesson Plan

  • Introduction to Relational Databases & SQL
  • Installation of Database Server & Preparation for Practical Exercises
  • Data Extraction from tables using SQL

Certification

A Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass all required assessment(s).


A Certificate of Participation will be awarded to participants who meet the 75% attendance requirement but did not pass all required assessment(s).


Entry Requirements

Basic IT Literacy

Course Fees

Funding period for this course is from 25 Jul 2020 to 30 Sep 2024.

SkillsFuture Credit
All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website to choose from the courses available on the Training Exchange course directory.

Enhanced training support for SMEs
For enhanced training support for SMEs, enter SME in the promo code during course application.

Long Term Visit Pass Plus (LTVP+) holders, please furnish the following documents to the course administrator to qualify for SSG funding:
Self-sponsored learner (**LTVP+): Copy of your green visit pass card, with the word ‘PLUS’ on the back of the card.
Co-sponsored learner (##LTVP+): Copy of valid and current Letter of Consent (LOC) from MOM

GST Increment in 2024
Please note that the GST rate will be revised to 9% with effect from 1 Jan 2024. As such any payable course fees will be subjected to the new GST rate adjustments in 2024. Please refer to our STEP portal for the updated fees. (Click on STEP)

Note:

  • The fees below are determined based on prevailing funding policies and subject to review and revision.
  • Please refer to our FAQs for more information.

Ngee Ann Polytechnic reserves the right to reschedule/cancel any programme, modify the fees and amend information without prior notice.

Applicants / Eligibility Fees
Full course fee $695.50
Enhanced Training Support for SMEs for Singapore Citizen$78.65
Enhanced Training Support for SMEs - SPR & LTVP+$78.65
SkillsFuture Mid-Career Enhanced Subsidy for Singapore Citizen aged 40 and above$78.65
SkillsFuture Baseline Funding for Singapore Citizen Aged Below 40$208.65
SkillsFuture Baseline Funding for SPR/LTVP+$208.65