Querying Data with SQL (Synchronous e-learning)

Offered by School of InfoComm Technology

Short Course / 2 days / TGS-2022014739

Note: 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: Synchronous e-Learning
Venue: Online

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.

Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% unfunded course fee support for up to $250 each year (or up to $500 for NTUC members aged 40 years old and above) when you sign up for courses supported under UTAP (Union Training Assistance Programme). Please visit e2i’s website to find out more.

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.

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 $708.50
Singaporeans aged below 40 qualified for SkillsFuture Funding $212.55
Singaporeans aged 40 & above qualified for SkillsFuture Mid-Career Enhanced Subsidy $82.55
Singaporeans qualified for Enhanced Training Support for SMEs $82.55
Singapore Permanent Residents & **LTVP+ qualified for SkillsFuture Funding $212.55
Singapore Permanent Residents & ##LTVP+ qualified for Enhanced Training Support for SMEs $82.55
Others (and Repeat Students)$708.50