MySQL for Beginners

Duration: 3 Days

Training Fee: RM 3200.00

HRDF Claimable

About this course

Course Overview

This course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL. You will learn to Install the MySQL server, Describe the features and benefits of MySQL, Describe the basics of relational databases.

Upon completion this training you should be able to troubleshoot syntax and understand typical warnings and errors, delete or modify a database and table row data, grouping query data with aggregation and many more.

This MySQL course is available on our public class training in Kuala Lumpur or also available if you want to conduct In-House training at your venue, throughout Malaysia.

Who should attend?

New MySQL users who have little or no previous experience understand relational database management systems.

You need to have basic computer literacy, previous experience with any command-line program and knowledge of database concepts.

Course Outline


  • Features and Benefits of MySQL
  • MySQL Products and Service
  • Community vs. Enterprise
  • MySQL Certification Program
  • MySQL Certification Program
  • MySQL Website
  • MySQL Architecture
  • Install and Start MySQL


Database Basics

  • SQL Language and MySQL
  • Database Design
  • Database Modeling
  • Keys
  • Normalization
  • Data Types
  • What is NULL?
  • Viewing Database Structure


Database Creation

  • Create a New Database Structure
  • Creating a Database
  • Creating a Table


Basic Queries

  • The SELECT Command
  • MySQL Query Browser
  • Troubleshooting


Database Maintenance

  • Delete an Entire Database
  • Maintaining Tables
  • Maintaining Columns
  • Indexes and Constraints
  • Data Manipulation


Delete/Modify Table row Data

  • The INSERT Command
  • The REPLACE Command
  • The UPDATE Statement
  • The DELETE Command



  • Simple Functions
  • Grouping With Functions


Joining Tables

  • Combining Multiple Tables
  • Inner Joins
  • Outer Joins


Exporting/Importing Data

  • Exporting Data
  • Importing Data


Sub queries

  • What is a Sub query?
  • Categories of Sub queries
  • Sub query Types
  • Placing Sub queries
  • Other Sub query Uses
  • Other Sub query Uses


Supplementary Information

  • Creating VIEWs
  • Transactions
  • Storage Engines
  • Retrieving Metadata



  • Course Review
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • QA Session

Training Methods

Public Class Training

Private Class Training

In-House Class Training

Public Class Schedule
15 - 17 Jan 2020
11 - 13 Mar 2020
13 - 15 May 2020
15 - 17 Jul 2020
9 - 11 Sep 2020
11 - 13 Nov 2020

Please contact us if you need more information about Private or In-House Class Training – click here

Register Here

  • Public Class Training

  • Date Format: DD slash MM slash YYYY
  • Date Format: DD slash MM slash YYYY
  • Your Information

  • Participant List

  • NameContact NumberDesignation 

Any Questions?

  • Contact Us

Call Us : 03-21165778

× WhatsApp Us