MariaDB Galera Cluster Administration Training Course

Audience: IT professionals aiming to pursue careers as DBAs or database support specialists for MySQL databases on Linux/Windows platforms.

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

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

This course aims to offer hands-on experience in managing Linux Servers, demonstrating 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 conducted on any major Linux/Unix distribution (Fedora, CentOS, Ubuntu, Debian, etc.).

This MariaDB Administration training course is designed for individuals seeking to manage the MariaDB database server. It is a comprehensive program that covers all essential administrative responsibilities.

The curriculum explains the inner workings of the MariaDB Database, available tools, their practical applications, and methods for securing and configuring the MariaDB Database Server. Participants will learn how to manage user accounts and understand the mechanics of the MariaDB Access Privilege System. Additionally, the course teaches database maintenance, backup and recovery procedures, and crash recovery techniques.

In this instructor-led, live training session in Portugal, participants will learn how to install, configure, and manage MariaDB to achieve high availability and performance. The curriculum also covers backup and recovery, security, and clustering.

The MySQL Administration training course is designed for individuals seeking to manage the MySQL database server effectively. It is a comprehensive programme that addresses all essential administrative responsibilities.

The course explains the workings of the MySQL Database, the tools available, their practical application, and methods to secure and configure the MySQL Database Server. During the training, you will learn to manage user accounts and understand the MySQL Access Privilege System. Additionally, you will acquire skills in maintaining your database, performing backups and recovery, and executing crash recovery.

This instructor-led, live training in Portugal (online or on-site) is designed for advanced-level developers who wish to learn and utilize 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 training course equips participants with the skills required for Web Application Development using Python, specifically focusing on Data Analytics. It highlights how effective data visualization serves as a powerful decision-making tool for senior management.

This SQL training programme 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 write 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, making it applicable to any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.

• How to build a query?
• What is a relational database?
• What is the structure and SQL commands?

Designed for individuals with prior SQL experience, this course delves into universal SQL database principles alongside MySQL-specific syntax, functions, and capabilities.