MariaDB Galera Cluster Administration Training Course

Administering MySQL databases requires robust expertise in architecture, data integrity, and performance optimization. This course explores essential administration domains, including system configuration, storage engines, transaction management, partitioning, and multi-user access security on both Linux and Windows platforms. Participants engage in practical exercises covering backup strategies, disaster recovery, replication topology design, and performance monitoring, empowering them to maintain high-availability MySQL environments for mission-critical applications.

Designed for Linux/Unix Administrators and developers keen on engaging with Linux/Unix servers. Beginners who possess foundational Linux skills and knowledge can also succeed, provided they diligently follow the instructor's detailed explanations and lab sessions.

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

The MariaDB Administration training course is designed for individuals seeking to master the administration of the MariaDB database server. This comprehensive programme covers all essential administrative responsibilities.

The course explains the workings of the MariaDB database, the available tools, how to utilise them effectively, and how to secure and configure the MariaDB database server. During the training, you will learn how to manage user accounts and understand the MariaDB Access Privilege System. You will also acquire skills in maintaining your database, performing backups and recoveries, and executing crash recovery procedures.

In this instructor-led, live training in Botswana, 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 seeking to manage the MySQL database server effectively. This comprehensive programme covers all essential administrative responsibilities.

Participants will explore how the MySQL Database functions, discover available tools, and learn how to utilise them to secure and configure the MySQL Database Server. Throughout the training, you will gain skills in managing user accounts and understanding the MySQL Access Privilege System. Additionally, you will learn how to maintain your database, perform backups and recoveries, and execute crash recovery procedures.

This instructor-led, live training in Botswana (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building 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 programme is designed for individuals seeking to acquire the essential skills required to extract and analyse data from any database and generate reports. Participants will learn:

• how to formulate SQL queries
• what relational databases are and how to utilise them
• the concept of relations and how to establish them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course focuses on generic ANSI SQL. It can be applied to any database system, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.