Advanced MariaDB for High Availability and Performance Training Course

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

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

• Designed for Linux/Unix system administrators and developers eager to engage with Linux/Unix server technologies.
• Even beginners with foundational Linux skills and knowledge can keep pace with this course by diligently following the instructor's detailed lab exercises and explanations.
• The course aims to provide ample hands-on experience in managing Linux servers, demonstrating that understanding Linux/Unix servers is highly accessible.
• Delivered with a mix of 40% lectures, 50% lab exercises, and 10% Q&A, this five-day course places strong emphasis on practical, lab-based learning.
• You will gain the skills to deploy and manage the Top 4 Linux Servers, which deliver essential network services critical to enterprise environments.
• The course can be conducted on any Linux distribution, with Fedora and CentOS being commonly used.

The MariaDB Administration training course is designed for individuals aiming to manage the MariaDB database server. This comprehensive program covers all essential administrator responsibilities.

The curriculum explains how the MariaDB Database operates, the tools available, and how to effectively utilize them. You will learn how to secure and configure the MariaDB Database Server. Throughout the training, you will master user account management and understand the MariaDB Access Privilege System. Additionally, the course teaches you how to maintain your database, perform backups and recoveries, and execute crash recovery.

This course is designed for database administrators.

It explores High-Availability solutions utilizing Galera Cluster.

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

The MySQL Administration training course is designed for individuals seeking to master the administration of MySQL database servers. This comprehensive program covers all essential administrative duties.

The curriculum details the inner workings of the MySQL database, the available tools, and their effective utilization. Participants will learn how to secure and configure the MySQL Database Server. Throughout the training, you will gain skills in managing user accounts and understanding the MySQL Access Privilege System. Additionally, the course teaches database maintenance, backup and recovery procedures, and crash recovery techniques.

This instructor-led, live training in Taiwan (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 equips participants with the skills to develop web applications using Python and leverage data analytics. Such data visualization serves as a powerful tool for top management in making informed decisions.

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

• how to compose SQL queries
• what relational databases are and how to utilize them
• what relations are and how to establish them
• the structure of data
• the differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course focuses on generic ANSI SQL. It can be applied to any database system, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.

• How to construct a query?
• What constitutes a relational database?
• What is the structure and the associated SQL commands?

This course is designed for individuals who already have a working knowledge of SQL. It delves into the underlying principles shared across all SQL database systems, alongside MySQL-specific syntax, functions, and features.