MariaDB Galera Cluster Administration Training Course

Audience: IT professionals aiming to become DBAs or database support specialists for MySQL databases on Linux and Windows platforms.

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

• Designed for Linux/Unix administrators and developers eager to engage with Linux/Unix server environments
• Even beginners with foundational Linux skills and knowledge can successfully follow this course by diligently participating in the instructor’s labs and explanations
• The course aims to provide sufficient hands-on experience in managing Linux servers, demonstrating that understanding Linux/Unix servers is straightforward
• Delivered in a format comprising 40% lectures, 50% lab exercises, and 10% Q&A, this five-day course places strong emphasis on practical, lab-based activities
• You will learn to deploy and manage four critical Linux servers that deliver essential network services to mission-critical enterprise environments
• Compatible with any Linux distribution, with Fedora and CentOS being the most commonly used

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

The curriculum explains the inner workings of the MariaDB Database, the available tools, and how to effectively utilize them. Participants will learn how to secure and configure the MariaDB Database Server. Throughout the training, you will gain skills in managing user accounts and understanding the MariaDB Access Privilege System. Additionally, you will learn how to maintain your database, perform backups and recoveries, and execute crash recovery procedures.

In this instructor-led, live training in Slovakia, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.

This MySQL Administration training course is designed for individuals seeking to manage the MySQL database server effectively. It serves as a comprehensive program covering all essential administrative responsibilities.

The curriculum details how the MySQL Database functions, the tools available for its management, and how to utilize them efficiently. Participants will learn how to secure and configure the MySQL Database Server, manage user accounts, and understand the mechanics of the MySQL Access Privilege System. Additionally, the training covers database maintenance, backup and recovery procedures, and crash recovery techniques.

This instructor-led, live training in Slovakia (online or on-site) is designed for advanced developers who wish to learn and utilize MySQL and database technologies for building web applications.

Upon completion of this training, participants will be able to:

• Compose SQL queries to retrieve, filter, sort, and aggregate data.
• Execute data manipulation operations including inserting, updating, and deleting records.
• Apply advanced SQL concepts such as subqueries, derived tables, and conditional logic.
• Integrate MySQL with popular programming languages and execute queries directly from application code.

This training course is designed to equip participants with the skills needed for Web Application Development using Python, focusing on Data Analytics. Data visualization serves as a powerful instrument for Top Management to support informed decision-making.

This SQL training program is designed for individuals seeking to acquire the essential competencies needed to extract and analyze data from any database system, as well as to generate comprehensive reports. Participants will master:

• Techniques for writing SQL queries
• The concept of relational databases and their practical applications
• The definition of relations and methods for establishing them
• Data structure fundamentals
• Key distinctions between various SQL dialects (Oracle, T-SQL, ANSI)
• Practical expertise in crafting effective queries

Focusing on generic ANSI SQL, this course ensures applicability across a wide range of database environments, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational database systems.

• Learn how to construct queries.
• Understand the concept of a relational database.
• Explore the structure of databases and essential SQL commands.

Designed for individuals who already possess a working knowledge of SQL, this course delves into the universal principles shared across all SQL databases, alongside MySQL-specific syntax, functions, and capabilities.