Non-Certification Course

MySQL for Beginners

Unlock the power of SQL with our comprehensive MySQL course! Get hands-on experience in writing SQL statements and learn how to troubleshoot syntax errors and warnings, modify databases and tables, and group query data with aggregation. Our expert instructors will guide you through the basics of relational databases and show you how to install and use the MySQL server to your advantage. Available in face-to-face and virtual classroom settings for both public and private groups.

RM 3,899.00

per person

Level

Foundation

Duration

3 Days

Training Delivery Format

Face-to-face / Virtual Class

RM 3,899.00

per person

Level

Foundation

Duration

3 Days

Training Delivery Format

Face-to-face (F2F) / Virtual Class

Class types

Public Class

Private Class

In-House Training

Bespoke

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 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.

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 is recommended.

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
HRD Corp Claimable Course

At this time, this course is available for private class and in-house training only. Please contact us for any inquiries. 

Contact form

Get the Project Charter Guide now!

Just enter your email address to access the FREE Project Charter guide and template.