MariaDB Galera Cluster Administration Training Course

Effectively managing MySQL databases requires a strong command of architecture, data integrity, and performance optimisation. This course explores essential administration areas, including system configuration, storage engines, transaction handling, partitioning, and multi-user access security across Linux and Windows environments. Participants will engage in practical sessions covering backup strategies, disaster recovery, replication topology design, and performance monitoring, equipping them with the confidence to maintain high-availability MySQL environments for mission-critical applications.

Designed for Linux/Unix Administrators and developers keen on working with Linux/Unix Servers. Beginners possessing fundamental Linux skills and knowledge can also succeed in this course, provided they diligently follow the instructor's explanations and complete the labs.

This course aims to provide practical, hands-on experience in managing Linux Servers, illustrating that Linux/Unix server management is both accessible and logical. Delivered over five intensive days using a methodology of 40% lecture, 50% lab, and 10% Q&A, the course places strong emphasis on lab-based activities. Participants will learn to deploy and manage the Top 4 Linux Servers that deliver essential network services in mission-critical enterprise environments. The training is fully distro-agnostic and can be delivered on any major Linux/Unix distribution (Fedora, CentOS, Ubuntu, Debian, etc.).

This MariaDB Administration training course is designed for individuals looking to manage the MariaDB database server. It provides a comprehensive overview of all essential administrator responsibilities.

The curriculum details how the MariaDB Database operates, explores available tools and their usage, and covers the steps for securing and configuring the MariaDB Database Server. During the training, participants will learn to manage user accounts and understand the MariaDB Access Privilege System. Additionally, the course teaches database maintenance, backup and recovery procedures, and how to perform crash recovery.

In this instructor-led, live training in Australia, 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 MySQL Administration training course is designed for individuals seeking to manage MySQL database servers effectively. It serves as a comprehensive guide covering the full spectrum of administrative responsibilities.

The curriculum explains the inner workings of the MySQL Database, detailing the available tools, their practical applications, and methods for securing and configuring the MySQL Database Server. Throughout the training, participants will learn how to manage user accounts and understand the mechanics of the MySQL Access Privilege System. You will also gain skills in maintaining your database, performing backups and recoveries, and executing crash recovery procedures.

This instructor-led, live training in Australia (online or onsite) is designed for advanced-level developers who want to learn and utilise MySQL and database technologies to build web applications.

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

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

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

• how to construct SQL queries
• the nature of relational databases and how to utilise them
• what relations are and how to establish them
• data structures
• the distinctions between various SQL dialects (Oracle, T-SQL, ANSI)
• practical techniques for writing queries

This course focuses on generic ANSI SQL, which is compatible with any relational database system, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and others.