MariaDB Galera Cluster Administration Training Course

Target Audience: IT professionals aiming to pursue careers as Database Administrators (DBAs) or database support specialists for MySQL databases on Linux and Windows platforms.

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

• Designed for Linux/Unix administrators and developers keen on engaging with Linux/Unix servers.
• Even beginners with fundamental Linux skills and knowledge can easily follow this course, provided they adhere closely to the instructor's detailed explanations and lab exercises.
• This course aims to provide sufficient hands-on practice in managing Linux servers, demonstrating that understanding Linux/Unix environments is straightforward.
• Delivered with a format of 40% lectures, 50% hands-on labs, and 10% Q&A, this five-day program places strong emphasis on practical, lab-based activities.
• You will learn how to deploy and manage the Top 4 Linux Servers, which deliver essential network services to mission-critical enterprise environments.
• The course can be delivered on any Linux distribution (Fedora, CentOS are commonly used).

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

The curriculum details the inner workings of the MariaDB Database, available tools, and their practical applications. Participants will learn how to secure and configure the MariaDB Database Server. Throughout the training, you will gain expertise in managing user accounts and understanding 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 in Sweden, 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 professionals aiming to manage MySQL database servers. It provides a thorough overview of all administrative responsibilities.

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

This instructor-led, live training in Sweden (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, integrating them with data analytics. Data visualization serves as a powerful asset for senior leadership in facilitating informed decision-making processes.

This SQL training program is designed for individuals seeking to acquire the essential skills to extract and analyze data from various databases and generate reports. Participants will learn:

• how to craft SQL queries
• the concept of relational databases and their application
• the nature of relations and how to establish them
• data structures
• differences among SQL dialects (Oracle, T-SQL, ANSI)
• practical techniques for query writing

This course focuses on standard ANSI SQL. It is applicable 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 is a relational database?
• What is the structure and SQL commands?

Designed for individuals with existing SQL expertise, this course reveals universal SQL concepts alongside MySQL-specific syntax, functions, and features.