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 | $708.50 |
| Enhanced Training Support for SMEs for Singapore Citizen | $82.55 |
| Enhanced Training Support for SMEs - SPR & LTVP+ | $82.55 |
| SkillsFuture Mid-Career Enhanced Subsidy for Singapore Citizen aged 40 and above | $82.55 |
| SkillsFuture Baseline Funding for Singapore Citizen Aged Below 40 | $212.55 |
| SkillsFuture Baseline Funding for SPR/LTVP+ | $212.55 |