Advanced MariaDB for High Availability and Performance Training Course

Managing MySQL databases requires robust expertise in architecture, data integrity, and performance tuning. This course explores key administration areas, including system configuration, storage engines, transaction handling, partitioning, and multi-user access security across Linux and Windows platforms. Participants will engage in practical sessions covering backup strategies, disaster recovery, replication topology design, and performance monitoring. The program builds confidence in maintaining high-availability MySQL environments that support mission-critical applications.

This course is designed for Linux/Unix administrators and developers looking to deepen their engagement with Linux/Unix server technologies. Even beginners with foundational Linux skills and knowledge can succeed, provided they diligently follow the instructor's lab exercises and explanations.

The program offers hands-on experience in managing Linux servers, illustrating that Linux/Unix server management is both accessible and logical. Delivered over five intensive days, the course follows a methodology of 40% lectures, 50% lab work, and 10% Q&A, placing a strong emphasis on practical, lab-based activities. Participants will learn how to deploy and manage the top four Linux servers that deliver critical network services in enterprise-grade environments. The training is distribution-agnostic and can be implemented on any major Linux/Unix distribution (such as Fedora, CentOS, Ubuntu, or Debian).

This MariaDB Administration training program is designed for individuals aiming to manage MariaDB database servers. It serves as a comprehensive guide covering all essential administrative responsibilities.

The curriculum details the operational mechanics of the MariaDB Database, the tools at your disposal, and their effective application. Participants will acquire skills in securing and configuring the MariaDB Database Server. Throughout the training, you will master the management of user accounts and gain a deep understanding of the MariaDB Access Privilege System. Additionally, the course covers database maintenance, backup and recovery procedures, and crash recovery techniques.

This course is designed for database administrators.

It explores High-Availability solutions utilizing Galera Cluster.

You will gain foundational knowledge of Galera technology, along with advanced topics and practical expertise in configuring, optimizing, and managing a Galera Cluster.

This MySQL Administration training course is designed for individuals seeking to manage the MySQL database server effectively. It offers a thorough exploration of all essential administrator responsibilities.

The curriculum details the inner workings of the MySQL Database, introduces available tools, and demonstrates their practical application. Participants will also learn how to secure and configure the MySQL Database Server. Key learning outcomes include managing user accounts, understanding the MySQL Access Privilege System, maintaining the database, performing backups and recoveries, and executing crash recovery procedures.

This instructor-led, live training in Argentina (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 course is designed for individuals seeking to develop the essential skills needed to extract, analyze data from any database, and generate reports. Participants will learn:

• how to craft SQL queries
• the concept of relational databases and their practical applications
• the nature of relations and how to establish them
• data structure fundamentals
• differences among SQL dialects (Oracle, T-SQL, ANSI)
• hands-on skills for writing effective queries

This SQL course focuses on generic ANSI SQL. It is applicable to a wide range of databases, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.