Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Enhance Your Employability with Certified Skills and Courses in Singapore - WSQ , IBF-STS, Skills Certification

MySQL Essential Training

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)

Course Date

* 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)

Items 1 to 20 of 35 total

per page
Page:
  1. 1
  2. 2

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
  • Reload captcha
    Attention: Captcha is case sensitive.

You May Be Interested In These Courses

WSQ - Microsoft Azure Data Fundamentals (DP-900)

WSQ - Microsoft Azure Data Fundamentals (DP-900)

7 Review(s)
$800.00 (GST-exclusive)
$872.00 (GST-inclusive)
NoSQL Essential Training

NoSQL Essential Training

$300.00 (GST-exclusive)
$327.00 (GST-inclusive)
WSQ - SQL Fundamental for Beginners

WSQ - SQL Fundamental for Beginners

82 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
SQL Essential Training

SQL Essential Training

$300.00 (GST-exclusive)
$327.00 (GST-inclusive)
Build a RAG Application with Milvus Vector Database

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

WSQ – Mastering NoSQL Fundamentals for Beginners

4 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)