MySQL Training in Auckland

This instructor-led, live training in Auckland (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.

• 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.

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.

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

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 Auckland, 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.