Home
CASL - SQL Fundamental for Beginners

Sessions 1 day
Duration 8 hrs
Level Beginner
Assessment 1 hr

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Funding for this course is valid from 14 Oct 2026 to 13 Oct 2027. Register and complete the course within this period to qualify for funding support.

Download Course Brochure

Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.

CASL - SQL Fundamental for Beginners

Course Code: TGS-2026066737

CASL
SFC
UTAP
SFEC
Absentee Payroll
MCES

259 Review(s) | Add Your Review

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.

Full Fee $350.00 Before GST

GST $31.50 9% of fee

Baseline Nett $206.50 SG/PR age 21+ · 50% funded

MCES / SME Nett $136.50 SG age 40+ · 70% funded

SkillsFuture Enterprise Credit (SFEC)

Eligible companies can use their $10,000 SFEC to cover up to 90% of out-of-pocket course fees for classes ending on or before 30 Nov 2026. A redesigned SFEC starts on 1 Dec 2026.

View on SkillsFuture for Business

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.

Direct Application on SkillsFuture Portal

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.

Submit UTAP Claim

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

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.

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
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

Practical Exam
Oral Questioning

Course Info

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 will need the following for this course:

MySQL Community Server – free
MySQL Workbench – free

Hardware: Windows PC or Mac laptop

Funding Eligibility Criteria

Self-sponsored learners (individuals)

Singapore Citizens and Singapore Permanent Residents aged 21 and above.
Up to 50% course fee funding. Singapore Citizens aged 40 and above receive up to 70% under the Mid-career Enhanced Subsidy (MCES).
Singapore Citizens aged 25 and above can pay the remaining fee with SkillsFuture Credit.

Company-sponsored learners

Singapore Citizens and Singapore Permanent Residents who are direct employees of the sponsoring company.
Up to 50% course fee funding, or up to 70% for employees of SMEs (Enhanced Training Support for SMEs) and for Singapore Citizens aged 40 and above. An SME has no more than 200 employees or an annual turnover of no more than $100 million.
Employers can also claim Absentee Payroll funding for employees who attend during working hours.
Eligible companies can offset their out-of-pocket fees with SkillsFuture Enterprise Credit (SFEC).

Conditions for all funded learners

Attendance is taken digitally with Singpass for every session, including the assessment.
You must complete the course and pass all assessments (assessed as Competent).
If these conditions are not met, the funding is clawed back and the learner or employer pays the full course fee.
9% GST is charged on the full course fee before funding.
Promo and discount codes cannot be used on funded courses.
Any balance after funding can be paid in cash, with SkillsFuture Credit, or partly reimbursed by UTAP for NTUC members.

How to Apply SkillsFuture Credit Claim for Individuals

Singapore Citizens aged 25 and above can use their SkillsFuture Credit (base tier) to pay the course fee after funding. The $4,000 mid-career top-up cannot be used for this course.

Register for this course as self-sponsored and tell us you will use SkillsFuture Credit. Do not pay the amount you plan to claim.
We email you an invoice showing the course fee after funding.
From 60 days before the course starts, and no later than the course start date, log in to MySkillsFuture with Singpass and click Claim credits.
Click Submit a Claim and search for this course by its course code, TGS-2026066737.
Select your class start date, enter the course fee payable after funding and the amount of credit to claim, then upload the invoice (PDF, JPG or PNG, under 4MB).
Review, accept the terms and click Agree and Submit. The credit is paid directly to us; processing can take up to 14 working days.

Changing or withdrawing: cancel the claim on MySkillsFuture at least one day before the course starts. If your class date changes, cancel the claim and submit a new one with the new date.

How to Apply SkillsFuture Enterprise Credit (SFEC)

SFEC helps companies pay for employee training. The current SFEC ends on 30 November 2026, and a redesigned SFEC starts on 1 December 2026.

Current SFEC: classes ending on or before 30 November 2026

Eligible companies received a one-off $10,000 credit, notified by letter to their Corppass administrator. Eligibility generally required at least 3 Singapore Citizen or PR employees and Skills Development Levy contributions.
SFEC covers up to 90% of the company's out-of-pocket course fee after other subsidies.

Check your company's SFEC eligibility and balance on EnterpriseSG.
Register your Singapore Citizen or PR employee for a class that ends by 30 November 2026, as company-sponsored, and pay the course fee after funding.
Your employee attends and completes the course. We submit the attendance and assessment results to SWDA.
No separate claim is needed. SFEC is calculated automatically once the course fee grant is approved and is paid quarterly to your company's IRAS GIRO or PayNow Corporate account.

Any unused balance of the current SFEC expires on 30 November 2026.

Redesigned SFEC from 1 December 2026

Companies with at least 3 resident employees receive a fresh $10,000 in an online SFEC wallet that offsets out-of-pocket fees upfront at enrolment, instead of reimbursing them afterwards. SWDA has not yet published the support rates and claim steps; see OurWorkforce or our SFEC guide.

How to Apply UTAP (NTUC Members)

NTUC members can claim 50% of the unfunded course fee under the Union Training Assistance Programme (UTAP), capped at $250 a year (aged below 40) or $500 a year (aged 40 and above). The cap is shared with UTAP claims for AI tool subscriptions.

Eligibility: you must be an NTUC member paying full membership fees, with your membership paid up before and during the course and when you claim. The course must not be fully paid for by your employer or another source.

Make sure your NTUC membership is paid up before the course starts.
Register for this course with us and pay the course fee after funding and SkillsFuture Credit.
Attend at least 75% of the course and sit all assessments.
Within 6 months after the course ends, go to the NTUC U Portal, open UTAP under E-services, log in with Singpass and choose Course Fee Claim.
Enter the nett course fee you paid (after all subsidies and SkillsFuture Credit, including GST), and upload your invoice or receipt and your certificate or result slip (PDF, JPG or PNG, up to 5MB each).
NTUC usually pays the claim within 4 weeks of submission.

Appeal Process

If you disagree with an assessment decision, you have the right to appeal.

When the assessor gives you feedback, say whether you agree with the outcome. If you agree, you and the assessor sign the Assessment Summary Record; if you disagree, do not sign it.
Discuss the decision with the assessor or the assessment manager first.
If you are still not satisfied, tell the assessor you intend to appeal. The assessor records this in the feedback section of the Assessment Summary Record and informs the assessment manager.
Lodge your appeal within 7 days, giving your reasons, using the Candidate Appeal Form. The assessor can help you write and lodge it.
An Assessment Appeal Panel reviews the information from you and the assessor and makes a decision. A record of the appeal and its outcome is kept.
You will be told the outcome within 2 weeks of lodging the appeal. The panel's decision is final.

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 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 is an experienced IT leader and consultant with more than 25 years of expertise in technology management, information 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 led major IT modernization projects. Since 2017, he has worked as an independent consultant and ACLP-certified trainer, specializing in guiding SMEs and enterprises in adopting future-ready digital platforms. As a WSQ-accredited trainer, Terence delivers programs in digital collaboration, IT governance, and productivity tools. His facilitation emphasizes case studies, simulations, and hands-on practice, enabling learners to apply modern IT systems such as Microsoft 365 and Google Workspace to improve collaboration and business efficiency. With his leadership background and deep IT expertise, Terence prepares learners to thrive in digitally transforming environments.

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 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 is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations. Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.