Home
WSQ - SQL Fundamental for Beginners

WSQ - SQL Fundamental for Beginners

Unlock the secrets of database management with our SQL Fundamental for Beginners course. This comprehensive training is designed to equip you with the essential SQL skills needed for effective data management. You'll learn how to create, read, update, and delete data records in a database. The course also covers key SQL syntax, joins, and data retrieval techniques, providing you with a strong foundation for future learning and practical application.

But this course is about more than just the basics. You'll also explore important aspects of database design, including normalization and indexing. Learn how to write complex SQL queries to solve real-world data problems and gain insights into data analysis. These additional skills ensure that you can take full advantage of SQL's capabilities, making you a valuable asset in any data-driven organization.

Learning Outcomes:

By. the end of the course, learners will be able to

LO1: Apply data modeling for business processes.
LO2: Apply data processing and analysis using SQL.
LO3: Apply data transformation from multiple data sources.
LO4: Apply data mapping to data warehouse.

Course Brochure

Download WSQ - SQL Fundamental for Beginners Brochure

Skills Framework

This course follows the guideline of Data Engineering ICT-DIT-3005-1.1 TSC under ICT Skills Framework

Certification

Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.
OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

WSQ Funding

WSQ funding is only applicable to Singaporeans and PR. Subject to eligibility, the funding support is subjected to funding caps.

Effective for courses starting from 1 Jan 2024
Full Fee	GST	Nett Fee after Funding (Incl. GST)
		Baseline	MCES / SME
$350	$31.50	$206.50	$136.50

Baseline: Singaporean/PR age 21 and above
MCES(Mid-Career Enhanced Subsidy): S'porean age 40 & above

Upon registration, we will advise further on how to tap on the WSQ Training Subsidy.

You can pay the nett fee (after the WSQ training subsidy) by the following :

SkillsFuture Enterprise Credit (SFEC)

Eligible Singapore-registered companies can tap on $10000 SFEC to cover out-of-pocket expenses.Click here to submit SkillsFuture Enterprise Credit

SkillsFuture Credit (SFC)

Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used. Click here for SkillsFuture Credit submission

UTAP

Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year. Click here to submit UTAP

Course Code: TGS-2020505790

Post-Course Support

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Course Cancellation/Reschedule Policy

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom

Course Details

Topic 1: Data Modeling

Data Sources
Data Modeling
SQL Data Types
Create and Manage Databases

Topic 2: Data Processing and Analysis

SQL Queries
SQL Operators

Topic 3: Data Transformation

Aggregate Data
Join Data
Group Data

Topic 4: Introduction to Data Warehouse

Overview of Data Warehouse
Relational Databases
Stored Procedure

Final Assessment

Practical Performance (PP)
Oral Questioning (OQ)

Course Info

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

Positive Learning Attitude
Enthusiastic Learner

Experience

Minimum of 1 year of working experience.
Minimum 18 years old

Minimum Software/Hardware Requirement

Software:

You can download and install the following software:

Hardware: Windows and Mac Laptops

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity.

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Individual Sponsored Trainee

Employer Sponsored Trainee

Singapore Citizens or Singapore Permanent Residents of age 21 and above
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria.

Singapore Citizens or Singapore Permanent Residents who are DIRECT EMPLOYEE of the sponsoring company.
From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
Trainee must pass all prescribed tests / assessments and attain 100% competency.
We reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria.

SkillsFuture Credit:

Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

PSEA:

To check for Post-Secondary Education Account (PSEA) eligibility, goto mySkillsFuture portal and search for this course code.
Scroll down to "Keyword Tags" to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.
And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA.
Not all courses are eligible for PSEA funding.

Absentee Payroll (AP) Funding:

$4.50 per hour, capped at $100,000 per enterprise per calendar year.
AP funding will be computed based on the actual number of training hours attended by the trainee.

SFEC:

If the Training Provider has submitted an enrolment for course fee grant claim in Training Partners Gateway (TPGateway), SSG would be able to derive SFEC funding based on this record. There is no need for enterprise to submit any claim request and the SFEC claim will be automatically generated and disbursed.
Where there is no such record, eligible employers are required to submit an SFEC claim after course completion via the SFEC microsite.
SkillsFuture Enterprise Credit (SFEC) Microsite

Steps to Apply Skills Future Claim

The staff will send you an invoice with the fee breakdown.
Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

Note

SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
UTAP support amount will be paid to training provider first and claimed after end of class by learner.

Appeal Process

The candidate has the right to disagree with the assessment decision made by the assessor.
When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
The candidate must lodge the appeal within 7 days, giving reasons for appeal
The assessor can help the candidate with writing and lodging the appeal.
he assessment manager will collect information from the candidate & assessor and give a final decision.
A record of the appeal and any subsequent actions and findings will be made.
An Assessment Appeal Panel will be formed to review and give a decision.
The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
Please click the link below to fill up the Candidates Appeal Form.

Job Roles

Database Administrator
Data Analyst
Business Analyst
Systems Analyst
IT Support Specialist
Back-End Developer
Report Developer
Data Scientist (beginner level)
Financial Analyst (working with databases)
CRM Administrator
ERP Specialist
Marketing Analyst
HRIS Specialist
Product Manager (data-driven products)
Technical Project Manager

Trainers

Dr Alvin Ang – Dr Alvin Ang is an ACLP-certified trainer with a Ph.D. in Operations Research from Nanyang Technological University and more than a decade of teaching and research experience. He has taught data science, statistics, and database systems at NTU, SUSS, Curtin University, and as an IBM Data Science Instructor. With certifications in Python, R, TensorFlow, and database technologies, Dr Ang has guided learners across academic and industry settings in acquiring practical analytics and programming skills.

In his SQL training, Dr Ang emphasizes building a solid foundation in relational database concepts and query formulation. His sessions cover database design, SELECT statements, filtering, joins, and aggregation, ensuring learners gain both conceptual understanding and hands-on experience. By combining academic rigor with applied projects, he equips learners to use SQL effectively for data management and analysis in real-world contexts.

Terence Ee – Terence Ee is an independent consultant and ACLP-certified trainer with over 25 years of experience in IT management, enterprise systems, and digital transformation. He has served as Chief Information Officer at the Supreme Court of Singapore and Vice President of Information Systems at Senoko Energy, where he oversaw enterprise data systems and IT modernization initiatives. With a B.Sc. in Computer and Information Sciences from NUS and an M.Sc. in Technology Management from Staffordshire University, he brings both executive-level and technical insights to his teaching.

In his SQL courses, Terence focuses on introducing learners to database fundamentals and practical query building. He guides participants through writing SQL statements, managing data structures, and applying queries to support business intelligence and reporting. By blending real-world case studies with technical training, he ensures participants can apply SQL skills effectively in workplace settings.

Fritz Lim – Fritz Lim is an ACTA-certified trainer and software developer with more than 15 years of teaching experience in IT, programming, and database management. He has taught extensively in polytechnics and private academies, specializing in web development, Python, and SQL. His real-world projects include database-backed applications and web solutions that integrate SQL with front-end and back-end systems, giving learners insights into applied database management.

In his SQL training, Fritz emphasizes project-based learning, guiding learners through database creation, querying, and optimization. His courses cover key SQL commands, relational schema design, and the integration of SQL with programming environments. With his combined teaching experience and technical expertise, Fritz ensures participants gain confidence in managing and querying databases.

Mohamed Afiq – Mohamed Afiq is a Forbes 30 Under 30 Asia 2021 honoree in enterprise technology and an experienced software engineer specializing in web and database systems. As co-founder and senior engineering manager at Janio Asia, he built logistics platforms that processed more than 20,000 deliveries daily, leveraging SQL and cloud technologies for scalability. He has also conducted training in web development, JavaScript, and databases for academy and industry learners.

In his SQL-focused training, Afiq emphasizes real-world database design and query writing for applications. His sessions introduce learners to normalization, relational models, and SQL commands, with applied projects that demonstrate how SQL powers modern web and enterprise systems. By integrating his entrepreneurial experience with teaching, he helps participants understand how SQL underpins scalable and efficient applications.

Ken Hiong – Ken Hiong is an ACLP-certified trainer with over 15 years of experience in business analytics, financial planning, and database systems. He has held key roles at Pfizer and SciGen, where he supported financial planning and business analysis with SQL-driven dashboards, variance analysis, and performance modeling. Currently an associate trainer with Tertiary Courses, he delivers programs in Excel, Power BI, Access, and SQL for business and analytics professionals.

In his SQL training, Ken focuses on helping beginners build confidence in managing data using SQL. His courses cover core topics such as SELECT statements, joins, grouping, and query optimization, with practical exercises rooted in business analytics scenarios. By blending corporate finance experience with technical training, Ken ensures learners can apply SQL effectively in analyzing and managing organizational data.