MariaDB Galera Cluster Administration Training Course

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

• Designed for Linux/Unix system administrators and developers keen on engaging with Linux/Unix server environments.
• Beginners with foundational Linux skills and knowledge can easily follow along, provided they attentively complete the instructor's lab exercises and explanations.
• This course aims to provide ample practice in managing Linux servers, demonstrating that understanding Linux/Unix servers is straightforward.
• The course structure comprises 40% lectures, 50% hands-on labs, and 10% Q&A sessions. This five-day program places strong emphasis on lab-based activities.
• You will learn how to deploy and manage the Top 4 Linux servers that deliver essential network services within mission-critical enterprise environments.
• The content can be delivered across any Linux distribution, with Fedora and CentOS being commonly used.

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 Malaysia, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.

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.

This instructor-led live training, available Malaysia (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.

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.

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