MariaDB Galera Cluster Administration 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 keen on engaging with Linux/Unix server technologies.
• Beginners possessing foundational Linux skills and knowledge can also succeed by diligently following the instructor's detailed explanations and lab exercises.
• The course aims to provide ample practice in managing Linux servers, demonstrating that understanding Linux/Unix environments is straightforward.
• Delivered over five days, the format includes 40% lectures, 50% hands-on labs, and 10% Q&A, with a strong emphasis on lab-based learning.
• You will gain expertise in deploying and managing the Top 4 Linux servers to deliver essential network services within mission-critical enterprise environments.
• The course can be conducted on any Linux distribution, with Fedora and CentOS being the most commonly used.

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.

In this instructor-led live training conducted at Czech Republic, participants will gain expertise in installing, configuring, and managing MariaDB to ensure high availability and peak performance. Additional curriculum areas include backup and recovery strategies, security protocols, and clustering.

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 training course is designed to equip participants with the skills necessary for web application development using Python, specifically focusing on data analytics. Data visualization serves as a powerful asset for top management, facilitating informed decision-making processes.

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.

• Understanding how to construct queries
• Comprehending the concept of a relational database
• Exploring the structure and essential SQL commands

Designed for individuals who already possess a working knowledge of SQL, this course delves into concepts shared across all SQL database systems, as well as the syntax, functions, and features unique to MySQL.