Advanced MariaDB for High Availability and Performance Training Course

Target Audience: Any IT professionals aspiring to become Database Administrators (DBAs) or database support specialists working with MySQL on Linux or Windows platforms.

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

• Designed for Linux/Unix administrators and developers keen to get involved with Linux/Unix servers.
• Even beginners with basic Linux skills and knowledge can keep up with this course by following the instructor's lab exercises and detailed explanations.
• This course is intended to provide ample hands-on experience in managing Linux servers, demonstrating that understanding Linux/Unix servers is very straightforward.
• The course will be delivered with 40% lectures, 50% labs, and 10% Q&A. This five-day programme places strong emphasis on lab-based activities.
• You will learn how to deploy and manage the top four Linux servers that deliver highly valuable network services to mission-critical enterprise environments.
• It can be delivered on any Linux distribution (Fedora and CentOS are commonly used).

The MariaDB Administration training course is designed for anyone looking to administer the MariaDB database server. It offers a comprehensive overview of all administrative responsibilities.

The course explains how the MariaDB database functions, the tools available, how to utilise them, and how to secure and configure the MariaDB database server. Throughout the training, you will learn how to manage user accounts and understand how the MariaDB access privilege system operates. You will also gain skills in maintaining your database, performing backups and recoveries, and handling crash recovery scenarios.

This course is designed for database administrators.

It explores options for implementing High-Availability solutions using Galera Cluster.

You will gain a solid understanding of Galera technology fundamentals, along with more advanced concepts and practical skills for configuring, optimising, and administering a Galera Cluster.

The MySQL Administration training course is designed for anyone who wishes to manage a MySQL database server. This comprehensive course covers all essential administrator duties.

The course explains how the MySQL Database operates, what tools are available, how to use them effectively, and how to secure and configure the MySQL Database Server. During the training, you will learn how to manage user accounts and understand how the MySQL Access Privilege System functions. You will also gain skills in maintaining your database, performing backups and recoveries, and executing crash recovery procedures.

This instructor-led, live training in New Zealand (online or on-site) is designed for advanced-level developers who wish to learn and apply MySQL and related database technologies in 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 records.
• Implement advanced SQL concepts including subqueries, derived tables, and conditional logic.
• Integrate MySQL with popular programming languages and execute queries directly from application code.

This training course will equip participants to prepare for web application development using Python programming, with a focus on data analytics. Such data visualisation serves as a powerful tool for senior management in decision-making.

This SQL training course is designed for individuals seeking to develop the essential skills required to extract and analyse data from any database and generate reports. Participants will learn:

• how to write SQL queries
• what relational databases are and how to utilise them
• what relationships are and how to establish them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for crafting queries

This SQL course focuses on standard ANSI SQL, making it applicable across any database platform, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL and other relational database systems.

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

This course is designed for individuals already familiar with SQL. It explores the inner workings common to all SQL databases, as well as MySQL-specific syntax, functions, and features.