Course Information

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

Venue

Kuala Lumpur: G-3A-02, Suite Pejabat Korporat, KL Gateway, No 2, Jalan kerinchi, Gerbang kernichi Lestari, 59200 Kuala Lumpur, Malaysia
Penang: Jalan Sungai Dua, 11700 Penang, Malaysia.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

MySQL Essential Training

Course Code: M300
  • HRDF

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.

Funding and Grant

Course Fee

MYR1,000.00

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.

Disclaimer: The course dates displayed on our website are tentative and subject to trainer availability. We will confirm the final date after checking with the trainer. You are also welcome to email us your preferred date at sales@tertiarycourses.com.my, and we will do our best to coordinate with the trainer's schedule.

Post-Course Support

  • We may provide consultation related to the subject matter after the course.
  • Please email your queries to sales@tertiarycourses.com.my and we will forward your queries to the subject matter experts and get back to you as soon as possible.

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. The minimum class size to start a class is 3 Pax.

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

Course Info

HRDF Funding

Please refer to this video https://youtu.be/Kzpd-V1F9Xs

1-     HRD Corp Grant Helper

How to submit grant applications for HRD Corp Claimable Courses

2-     Employers are required to apply for the grant at least one week before training commences.

Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.

3-     First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my

Second, Click Application

4-     Click Grant on the left side under Applications

5-     Click Apply Grant on the left side under Applications

6-     Click Apply

7-     Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply

8-     Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:

9-     Select your Immediate Officer and click Next

10-  Select a Training Provider, then click Next

11-  Please select a training programme from the list, then key in all the required details and click Next

Select your desired training programme.

Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.

Explain the background and objective of this training.

Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.

12-  If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next

Insert MiCAS Application number

13-  Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:

14-  Please select a Course Title and Type of Training

15-  Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:

16-  Please key in the Training Location and click Next

17-  Please select the Level of Certification and click Next

18-  Please follow the instructions and key in trainee details

19-  Click Add Batch, then click Save

20-  Click Add Trainee Details

21-  Please key in all the required details, then click Add

22-  Click Add if there are more participants. Once done, click Save

23-  Click Next

24-  Please key in the course fees and allowance details, then click Save

25-  Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.

26-  Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next

27-  Complete the declaration form and select a desired officer

28-  Add all the required documents, then click Add Attachment. Then, click Save and Submit Application

29-  Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.

The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.

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

Saeid Alizadeh: Saeid Alizadeh has 9 years experience in field of IOT (Internet of things) and Information Technology. He is a certified IBM IoT Practitioner and instructor and Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventors of 3 inventions during the last 5 years. He has worked across wide domains such as, data analytics, IoT, social media analytics, smart cities energy management, smart plantations. Yam Chuan Wee: Yam Chuan Wee is an ICT Consultant at Sustainable Energy Development Authority (SEDA) Malaysia. He has been involved in software development, web development, and internet marketing for the last 15 years. He has sold more than 1 million ringgit worth of products as an Amazon Affiliate in 10 months as a part-time hobby. His interest in Software Design, Behavioral Psychology, Social Dynamics, Novel Business Strategies Muhammed Siraj: Muhammed Siraj is an IT executive, lecturer, trainer, security expert, developer, hardware technician, and entrepreneur with over 15 years of experience in the IT profession. He is an experienced IT instructor who has delivered several lectures in the area of Cybersecurity, Computer Forensics, and Fraud detection to the military, police, CID, Financial Institutions, among others. In addition to training, he provides consultancy services to Educational and Governmental Institutions in the area of computer security and adoption of Open Source solutions. His experience and knowledge acquired from Ghana, Mali, Denmark, South Africa, and Malaysia, enables him to interact with people of different cultural backgrounds very well. Skillset: Mohammad Reza Aminian: Mohammad Reza Aminian is a software engineer and PhD candidate in field of Artificial Intelligence with more than 4 years experience of teaching web technologies and scripting languages. skilled in PHP, JavaScript, system design, Laravel, and Vue.js frameworks. He has been involved in the development and implementation of web-based management systems, web applications and APIs in different organizations and companies. Mohd Hafiz Ramly: Mohd Hafiz Ramly is a seasoned Information Technology (IT) System Administrator who is very passionate about technology and new ideas, especially when it comes to cloud computing. A lot of his research and time is spent focused on cloud computing automation, DevOps and as well to data and information security. His interests are very specific in terms of making the old-fashioned IT way more easy to manage, smart and effective by focusing more towards automation, infrastructure as code and documentation, simply following the DevOps style.

Review

Customer Reviews (31)

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
Good and thank you. (Posted on 11/06/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 27/05/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 20/02/2024)
Love it to much 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

Nothing to improve because it’s perfect already (Posted on 20/02/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
Have more longer course time
Trainer was excellent but prefer more hands-on time to master SQLw (Posted on 17/03/2023)

Items 16 to 20 of 31 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7

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