Querying Data with SQL

Offered by School of InfoComm Technology

Short Course / 2 days / TGS-2022014740

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

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

Note:

(Course fee is payable upon acceptance. It is inclusive of 8% GST and subject to review.)

Please note that the GST rate will be revised to 8% with effect from 1 Jan 2023, as such any payable course fees will be subjected to the new GST rate adjustments in 2023.

Please refer to our FAQs for more information.

Applicants / Eligibility Fees
Full course fee $702.00
Singaporeans aged below 40 qualified for SkillsFuture Funding $208.65
Singaporeans aged 40 & above qualified for SkillsFuture Mid-Career Enhanced Subsidy $78.65
Singaporeans qualified for Enhanced Training Support for SMEs $78.65
Singapore Permanent Residents & **LTVP+ qualified for SkillsFuture Funding $210.60
Singapore Permanent Residents & ##LTVP+ qualified for Enhanced Training Support for SMEs $80.60
Others (and Repeat Students)$702.00