MySQL Training in Penang Island

This instructor-led live training, available Penang Island (online or onsite), is designed for advanced developers who want to learn and utilise MySQL and database technologies for web application development.

By the end of this training, participants will be able to:

• Compose SQL queries to retrieve, filter, sort, and aggregate data.
• Execute data manipulation operations, including inserting, updating, and deleting records.
• Apply advanced SQL concepts such as subqueries, derived tables, and conditional logic.
• Integrate MySQL with popular programming languages and execute queries directly from application code.

This training programme equips participants with the skills needed for Web Application Development using Python, with a strong emphasis on Data Analytics. By leveraging data visualization techniques, this course provides valuable insights that support strategic decision-making for top management.

• Methods for constructing queries
• Understanding relational databases
• Structural components and SQL commands

This course is designed for individuals who already have a solid foundation in SQL. It delves into the underlying principles shared across all SQL databases, as well as MySQL-specific syntax, functions, and features.

This SQL training course is designed for individuals seeking to acquire the essential skills needed to extract and analyse data from any database and generate reports. Participants will learn:

• how to craft SQL queries
• the concept of relational databases and how to utilise them effectively
• the nature of relations and how to establish them
• data structure fundamentals
• distinctions between various SQL dialects (Oracle, T-SQL, ANSI)
• practical techniques for writing queries

This SQL course focuses on generic ANSI SQL, making it applicable to any database system, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.

Audience: IT professionals aiming to become DBAs or database support specialists for MySQL on Linux and Windows platforms.

Format: 40% theoretical lectures, 60% practical hands-on labs

The MariaDB Administration training course is designed for individuals looking to manage the MariaDB database server effectively. This comprehensive programme covers all essential administrative responsibilities.

The course explains how the MariaDB database operates, the tools available, how to utilise them, and how to secure and configure the MariaDB database server. Throughout the training, you will learn how to manage user accounts and understand the workings of the MariaDB Access Privilege System. Additionally, you will acquire skills to maintain your database, perform backups and recoveries, and conduct crash recovery.

In this instructor-led, live training in Penang Island, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.

This course is designed specifically for database administrators.

It explores various High-Availability solutions leveraging the Galera Cluster.

Participants will gain foundational knowledge of Galera technology, alongside advanced insights and practical expertise on how to configure, optimise, and manage a Galera Cluster.

The MySQL Administration training course is designed for individuals aspiring to manage the MySQL database server. It is a comprehensive programme that covers all administrative responsibilities.

The course provides an explanation of how the MySQL Database operates, the available tools, their application, and methods to secure and configure the MySQL Database Server. Throughout the training, you will acquire skills to manage user accounts and understand the MySQL Access Privilege System. Additionally, you will learn how to maintain your database, perform backups and recoveries, and handle crash recovery.