Overview

Keep your mission-critical applications and essential services up and running with comprehensive MySQL training. To grow your skillset and be more productive in your job, access a rich library of digital courses at your own convenience, then test your new skills through interactive, hands-on labs. Deepen your understanding of MySQL administration, development, security, and high availability in a risk-free environment through role- and topic-based courses. Learn what you need to know to deliver high-performance and scalable applications, then create new opportunities by getting MySQL certified.

The MySQL Fundamentals training is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.In this course, you will be introduced to the MySQL Cloud Service.

Learn To:

  • Explain the relational database model.
  • Describe the features and benefits of MySQL.
  • Install and configure the MySQL server and clients.
  • Design efficient databases.
  • Use Structured Query Language (SQL) to build your database and query data.
  • Employ appropriate MySQL tools.
  • Gain an understanding on the MySQL Cloud Service.

Skills Covered

Upon completing this course, the learner will be able to meet these overall objectives:
  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Design an effective database
  • Issue MySQL statements from the mysql command-line client
  • Perform database operations by using MySQL Workbench
  • Select appropriate data types for your database
  • Build a database and tables by using SQL
  • Modify the structure of your database
  • Create indexes and keys
  • Add or update database data
  • Query data with SELECT statements
  • Join data from multiple tables
  • Use built-in MySQL functions
  • Export and import database data
  • Explain database transactions
  • Gain an understanding on the MySQL Cloud Service

Who Should Attend

  • Application Developers
  • Database Administrators
  • Database Designers
  • Developer

Course Curriculum

Prerequisites

  • Basic computer literacy

Suggested Prerequisites:

  • Previous experience with any command-line program
  • Knowledge of database concepts

Download Syllabus

Course Modules

Request More Information

Training Options

Intake: 3-7 Oct 2022
Duration: 4 Days
Guaranteed: TBC
Modality: VILT
Price:

RM5,200.00Enroll Now

Exam:
Intake: 3-7 Oct 2022
Duration: 4 Days
Guaranteed: TBC
Modality: ILT
Price:

RM5,200.00Enroll Now

Exam:

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions