Online Training: MariaDB for Data Engineers

MariaDB for Data Engineers is a team training designed for novice to expert MySQL users. Intended audience includesDBAs and DBAs involved in building a pipeline. The attendees will learn how to use a MariaDB replica to transform data written into production MariaDB/MySQL, and how to move data from MariaDB to other technologies.

Objectives

  • Replicate data from production

    Setup, administrate and troubleshoot MariaDB replicas to make production data available to data analysts and various software.

  • Transform and enrich data

    Use MariaDB replicas to build filter data, build summary tables, keep track of changes, and more.

  • Implement Capture Data Changes

    Capture changes made to data into MariaDB and move them to other technologies.

  • Take advantage of MariaDB interoperability

    Learn how MariaDB can read and write data into several formats, including CSV, JSON, XML and log files.

Topics

  • Replicating data from and to MariaDB
    • Understanding the binary log
    • Flashback
    • Setting up replication
    • Replication filters
    • Replicating from multiple masters
    • Replication between MariaDB and MySQL
  • Importing and exporting data
    • Dumps
    • CSV
    • CONNECT engine
  • Enhancing data
    • Virtual columns
    • Transforming data with triggers
    • Temporal tables

Requirements

The course is designed for data engineers and DBAs. Some knowledge of SQ and relational databases are required.

All attendees should have a stable and reasonably fast internet connection. Having a backup connection to use in case of troubles is also desirable.

Attendees should have the following programs installed on their laptops:

  • The latest MariaDB stable version, or another
    version agreed with the customer before the beginning of the course. It
    is recommended that we use the MariaDB version they will use in their
    daily work.
  • mysql or mycli command-line interfaces. mysqli is bundled with MariaDB, whereas mycli is an open source project.
  • A terminal that allows to run system commands.

The operating system of choice is not relevant, as long as it is not too old or too new to run the MariaDB version of choice.

Cost and timing

The MariaDB for Data Engineers training has a cost of 2,500 GBP and its duration is 2 days.

A maximum of 15 attendees is allowed, and we encourage
customers to keep the number of attendees as low as 10. This allows a
good level of interactivity, and ensures that every attendee can obtain
the necessary support.

Get In Touch

Contact us to book this course for your team.

Contact Us