Advanced MariaDB for High Availability and Performance Training Course

Audience: This course is designed for 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 lab

Designed for Linux/Unix Administrators and developers eager to work with Linux/Unix Servers. This course is also suitable for beginners who possess fundamental Linux skills and knowledge, allowing them to keep pace provided they diligently follow the instructor's labs and explanations.

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

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

The curriculum details the internal workings of MariaDB, available tools, and their practical application. You will learn how to secure and configure the MariaDB Database Server, manage user accounts, and understand 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 presents options for implementing High-Availability solutions utilizing Galera Cluster.

You will gain foundational knowledge of Galera technology, along with more advanced topics and practical insights into configuring, optimizing, and administering a Galera Cluster.

This MySQL Administration training course is designed for anyone looking to manage the MySQL database server. It offers a comprehensive overview of all administrator responsibilities.

The curriculum explains how the MySQL Database operates, the available tools, their application, and methods for securing and configuring the MySQL Database Server. During the training, you will acquire the 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 in Czech Republic (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 program is designed for individuals seeking to develop the essential skills required to extract, analyze, and report on data from any database system. Participants will learn:

• how to construct SQL queries
• the concept of relational databases and their practical applications
• the definition of relations and methods for establishing them
• the fundamental structure of data
• key distinctions between SQL dialects (Oracle, T-SQL, ANSI)
• practical techniques for effective query writing

This course focuses on generic ANSI SQL, which is compatible with a wide range of database systems, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.