JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

Home
MySQL Essential Training

MySQL Essential Training

35 Review(s) | Add Your Review

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.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

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

Course Code: C024

Course Booking

The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

$300.00 (GST-exclusive)

$327.00 (GST-inclusive)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Course Time *

Sponsorship

Self-Sponsored
Employer-Sponsored

No. of Participants

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

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 and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.

Course Details

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

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

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.

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.

Peter Goh: Peter Goh is a ACTA certified trainer. Peter Goh is the Technology Evangelist at Disruptive Digital, a full-service digital agency based in Singapore, offering innovative & effective web and native mobile application development. He specializes in bleeding edge software development and have more than 10 years' experience in developing customized applications for desktop, web and mobile platforms. He has extensive domain knowledge in .Net and Java programming, iOS development and has helped many to create e-commerce web sites on Amazon AWS and Microsoft Azure.

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.

Customer Reviews (35)

Good for beginners Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Good for beginners (Posted on 9/24/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 6/12/2024)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 4/29/2022)

might recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 4/29/2022)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

More application to how these could be used (Posted on 4/29/2022)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

1. Need more breaks please
2. Send the materials 3-5 days in advance. I received the materials 1 day in advance (Posted on 3/26/2022)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 2/25/2022)

will recommdn Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 2/4/2022)

Pleasant and friendly instructor :) Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

More examples and demonstrations (Posted on 11/26/2021)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 10/29/2021)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 10/29/2021)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 5/19/2021)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 5/18/2021)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 12/1/2020)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 8/31/2020)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

The lecturer had very good attitude with high level reaching skills. (Posted on 8/30/2020)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 8/30/2020)

wil recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 3/28/2020)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 12/30/2019)

Will Recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

The instructor was great, I managed to learn the most practical things that I can actually apply to my work. (Posted on 8/19/2019)

Write Your Own Review

You're reviewing: MySQL Essential Training

How do you rate this product? *

	1 star	2 stars	3 stars	4 stars	5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

*Nickname
*Summary of Your Review
*Review
*Please type the letters below
Attention: Captcha is case sensitive.

You May Be Interested In These Courses

WSQ - Microsoft Azure Data Fundamentals (DP-900)

7 Review(s)

$800.00 (GST-exclusive)

$872.00 (GST-inclusive)

NoSQL Essential Training

$300.00 (GST-exclusive)

$327.00 (GST-inclusive)

WSQ - SQL Fundamental for Beginners

87 Review(s)

$350.00 (GST-exclusive)

$381.50 (GST-inclusive)

SQL Essential Training

$300.00 (GST-exclusive)

$327.00 (GST-inclusive)

Build a RAG Application with Milvus Vector Database

2 Review(s)

$300.00 (GST-exclusive)

$327.00 (GST-inclusive)

WSQ – Mastering NoSQL Fundamentals for Beginners

4 Review(s)

$350.00 (GST-exclusive)

$381.50 (GST-inclusive)

About Us

Tertiary Courses, founded in 2014, specializes in providing modular, skill-based courses tailored to Industry 4.0. We are WSQ Approved Training Organization (ATO), and IBF Approved ATO.. We are also Authorized Microsoft Learning Partner, Autodesk Authorized Training Center (ATC), Pearson Vue Authorized Test Center and Kryterion Authorized Testing Center. We offer a comprehensive range of training, certification prep and certification exam services. Additionally, we are a registered supplier with Singapore GeBiz, further solidifying our position as a trusted educational institution in the region.

Training Grants and Subsidies

We have various grants and subsidies for different courses. Please check the respective funding available on individual course page.

WSQ: Company and Singaporeans/PR can apply WSQ 70-90% funding depending on eligibility
SkillsFuture Enterprise Credit (SFEC) - Eligible Singapore-registered companies can tap on $10000 SFEC to cover up to 90% of out-of-pocket expense
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.
IBF-STS Companies and Singaporeans/PR can apply IBF-STS 70-90% funding depending on eligibility
UTAP: NTUC members enjoy 50% subsidy for unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP
SGTech STAR Fund: SGTECH members enjoy $500 grant per pax for SGTech STAR courses