Advanced MariaDB for High Availability and Performance Training Course

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

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

• Designed for Linux/Unix administrators and developers eager to engage with Linux/Unix server infrastructure.
• Even beginners with foundational Linux skills can successfully follow along, provided they carefully adhere to the instructor's detailed lab demonstrations and explanations.
• The course aims to provide ample practice in managing Linux servers, demonstrating that understanding Linux/Unix systems is accessible and straightforward.
• Delivered in a five-day format, the course consists of 40% lectures, 50% hands-on labs, and 10% Q&A, with a strong emphasis on lab-based activities.
• You will learn to deploy and manage the Top 4 Linux servers that deliver essential network services within mission-critical enterprise environments.
• The content can be delivered on any distribution, with Fedora and CentOS being the most commonly used platforms.

This MariaDB Administration training course is designed for individuals aiming to manage the MariaDB database server. It offers a comprehensive overview of all administrative responsibilities.

The course details the inner workings of MariaDB, the available tools, and how to utilize them effectively. Participants will learn how to secure and configure the MariaDB Database Server. Throughout the training, you will gain skills 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.

This course is designed for database administrators.

It explores high-availability solutions leveraging the Galera Cluster.

Participants will gain foundational knowledge of Galera technology, along with advanced concepts and practical skills for configuring, optimizing, and managing a Galera Cluster.

This MySQL Administration training course is designed for professionals seeking to master the administration of MySQL database servers. It offers a comprehensive curriculum that addresses all essential administrative responsibilities.

The course explores the inner workings of the MySQL Database, identifies available tools, and demonstrates how to effectively utilize them to secure and configure the MySQL Database Server. Throughout the training, participants will acquire the skills necessary to manage user accounts and comprehend the MySQL Access Privilege System. Additionally, you will learn techniques for maintaining your database, executing backups and recoveries, and performing crash recovery.

This instructor-led, live training in Norway (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 needed for Web Application Development in Python, integrating Data Analytics. Effective data visualization serves as a powerful decision-making tool for top management.

This SQL training course is designed for individuals seeking to acquire the essential skills to extract, analyze, and report on data from any database. Participants will learn:

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

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

• Learn how to construct queries
• Understand what a relational database is
• Explore database structure and SQL commands

This course is designed for individuals who already have a solid understanding of SQL. It delves into concepts shared across all SQL databases, alongside MySQL-specific syntax, functions, and features.