Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Beginner
  • Assessment NA

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.

Download Course Brochure

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.

Additional Information

Duration

2 months (Full Time)

Assessment

3 hours online assessment after each module

Class (No of teacher : student): 1:20

Intake

  • 3 Nov 2025 to 29 Sep 2026
  • 4 May 2026 to 26 June 2026
  • 2 Jan 2026 to 2 Mar 2026
  • 2 Mar 2026 to 27 Apr 2026

Enrolment Requirement

  • Age: 21 years old and above
  • Language Proficiency: At least C6 for GCE "O" Level English
  • Academic: At least C6 for GCE "O" Level in any 3 subjects

Graduation Requirement

  • Attendance: 75%
  • Assessment: Passed

MySQL Essential Training

Course Code: C024

What's This Course About

Dive into the profound depths of MySQL, a globally renowned open-source relational database, with our essential training program. This course meticulously covers the art of writing pinpointed queries, the essence of creating and updating databases and tables, and effectively using MySQL's array of built-in functions. Additionally, sharpen your skills in sorting and filtering data, updating tables with strategic triggers, and seamlessly working with subselects and views.

In the digital age, database management and operations are pivotal. MySQL, with its robust features and scalability, stands out as a preferred choice for many developers. Our course is crafted to provide a wholesome understanding, introducing learners to the diverse aspects of MySQL, from basic operations to creating and harnessing stored functions. Step up your database management game and drive innovation with the expert guidance of Tertiary Courses.

WSQ Funding

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
Funding and Grant Applications

For WSQ funding, please checkout the details at WSQ - SQL Fundamental for Beginners

Course Fee

$350.00 (GST-exclusive)
$381.50 (GST-inclusive)

Course Date

* Required Fields

Additional Note

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

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.

Cancellation & Reschedule Policy

  • 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

Course Details

What You'll Learn

Topic 1 Data Modeling

Data Sources

Data Modeling

SQL Data Types

Install MySQL and Workbench

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

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • 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.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

Please down and install MySQL Community Server from the link below

https://dev.mysql.com/downloads/mysql/

Hardware: Window or Mac Laptops

Job Roles

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

Trainers

Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally. Fritz Lim: Fritz is ACTA-certified, as well as a registered MOE instructor, and a graduate of the 2018 ConsenSys Blockchain Developer Program, with a Bachelor in Electrical and Electronic Engineering (Computer Specialisation) from Nanyang Technological University. With more than 10 years of experience teaching at a local polytechnic, Fritz is passionate about imparting knowledge to teens, adults, and children. He believes that an education in technology and in how things work is essential for everyone, so that they can harness and invent the technologies of the future. He is excited about exploring anything related to computers and IT, with a keen interest in electronics and native cross-platform mobile app development so that our ubiquitous mobile phones can be conveniently used to control and interact with devices wirelessly and over the Internet.   Mohamed Afiq: Mohamed Afiq is a ACTA certifed trainer. Mohamed Afiq startup CTO for 3 years building proprietary delivery system from scratch and then managing a team of 20 developers. He builted multiple web apps using MEAN or similar stacks. He is also a founder and sole developer for PlayTours: https://playtours.app/ . He leads instructor at CodeNinja, teaching coding to kids 9-16 years old and teach adults front-end and back-end for web development. Terence Ee: Terence Ee is a ACTA certified trainr that has delivered IT training in Singapore and Myanmar. He has also facilitated faith formation courses for Christians in Singapore and Myanmar. As a trainer, his mission is to co-create insightful and actionable learning experiences with his learners.His current areas of focus include project management, information security management, quality management and office productivity applications. Terence has more than 25 years of corporate IT experience. He has held senior management roles in the public and private sectors. He holds a Master of Science in Technology Management, a Bachelor of Science in Computer and Information Sciences, a Diploma in Family Education, and the Advanced Certificate in Training and Assessment (ACTA). Part of his spare time goes towards tutoring his children in their studies (while learning a thing or two along the way). He is also imparting to them the essential skills for thriving in a digital world. Ken Hiong: 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.

Review

Write Your Own Review

You're reviewing: MySQL Essential Training