Announcement: Mindasys is now Skillet! Check out our new website.

Key points about this course

Duration : 3 Days
Course Fee : RM 3,599.00

HRD Corp Claimable Course

Enroll Now
MySQL for Beginners
  • Practical experience in writing SQL statements using the MySQL
  • For new professionals who are required to work with a MySQL Database
  • Get tips and tricks from a MySQL expert

Virtual Class

Public Class

In House Training

Private Class

Course Overview

This MySQL 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 MySQL. You will learn to Install the MySQL server, Describe the features and benefits of MySQL, Describe the basics of relational databases.

Upon completing 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 in our face to face classroom or through a live virtual class training. This training is available for a public and private group. It is open for Malaysia and international students.

Who Should Attend?

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

  • Application Developers
  • Datacase Administrators
  • Database Designers
  • Developers
Course Prerequisites

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

Course Objectives

Upon Completion, You Will Be Able To:

  • Understand and explain the relational database model.
  • Identify and describe the features and advantages of MySQL.
  • Successfully install and configure both the MySQL server and client applications.
  • Design and create efficient databases.
  • Utilize Structured Query Language (SQL) to build databases and perform data queries.
  • Effectively use various MySQL tools.
  • Gain a comprehensive understanding of the MySQL Cloud Service.
Course Content

Introduction

  • 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

 

Functions

  • 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

 

Conclusion

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

  • MySQL for Beginners

  • Ask For

About the Certification

This course is not associated with any Exam & Certification.

Contact Us

  • 03-2116 5778
  • info@mindasys.com
  • Suite 33.01, 33rd Floor, Menara Keck Seng, Jalan Bukit Bintang, 57000 Kuala Lumpur
  • Click the Whatsapp button

Affiliates

About Us

Courses