Online MySQL Training in New Zealand

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

• how to compose SQL queries
• the concept of relational databases and how to utilise them effectively
• what relations are and how to establish them
• the fundamental structure of data
• differences between various SQL dialects (Oracle, T-SQL, ANSI)
• practical techniques for writing queries

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

Effectively managing MySQL databases requires a robust understanding of architecture, data integrity, and performance optimisation. This course explores essential administration areas, including system configuration, storage engines, transaction management, partitioning, and multi-user access security on both Linux and Windows platforms. Participants will engage in practical workshops covering backup strategies, disaster recovery, replication topology design, and performance monitoring, equipping them with the confidence to maintain high-availability MySQL environments for mission-critical applications.

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.

In this instructor-led, live training in New Zealand, 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 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.