MySQL Database Administration Training

Catalogue index: IFS/40

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • Podstawowy
  • Type of training:
    • stacjonarnie; online
PLN1,526.67 net / particip. PLN22,900.05  net for 1 workshop PLN1,877.80 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 24
Producer:
Training language:
  • polski
Training level:
  • Podstawowy
Type of training:
  • stacjonarnie; online

Description

Company Description

Infoshare is the largest tech community in CEE and the organizer of the leading tech conference in Gdańsk. It connects startups, investors, corporations, and innovation enthusiasts. It promotes entrepreneurship, knowledge sharing, and networking. Through events, competitions, and programs, it supports the development of the tech ecosystem in Poland and the region.

Training Description
  • The MySQL database administration training is a course focused on learning how to manage and maintain databases based on the MySQL system. Participants gain knowledge about installing, configuring, and monitoring the MySQL server, managing users and permissions, performing backups and data recovery, optimizing performance, and troubleshooting database-related issues. The training includes practical exercises so that participants can acquire the skills necessary for effectively managing MySQL databases in various application environments. Work environment:
  • Containerization
  • 2-3 virtual machines based on Linux (recommended)
  • Requirements:
  • Knowledge of Linux, SSH configuration, basics of scripting
  • Choice of one of the engines
Who the training is for
  • The target audience is anyone who wants to learn the basics of MySQL database administration and similar systems (Percona, MariaDB)
  • Knowledge will be most useful for positions: administrator, devops, site reliability engineer
Goals
Benefits

The participant will learn basic and some intermediate topics related to MySQL and MariaDB database administration. They will practically learn topics such as user management, creating backups, and ways to optimize the database by selecting appropriate engines and memory amounts. The topic of HA based on created clusters and master-worker configuration will also be included.

Training Program

  1. INTRODUCTION
     • MySQL components
     • MySQL installation
     • configuration files

  2. FILE STRUCTURES AND ENGINES
     • discussion of file structure
     • table engines
     • creating a table with a selected engine

  3. SERVER CONFIGURATION
     • global configuration
     • user session configuration
     • verification on the database side
     • SHOW GLOBAL and SET

  4. MEMORY MANAGEMENT
     • memory configuration
     • session buffer
     • global buffer
     • engine buffer
     • query cache

  5. PERMISSIONS
     • creating and deleting users
     • managing permissions

  6. TRANSACTIONS
     • isolation levels
     • data locks
     • managing/verifying active transactions
     • discussion of performance_schema

  7. TABLES AND PARTITIONS
     • creating and deleting partitions
     • creating temporary tables

  8. BACKUPS
     • database export
     • server export
     • export of individual objects
     • types of backups
     • XtraBackup tools
     • database recovery

  9. LOGS
     • log verification
     • types of logs
     • tuning logs

  10. HA SOLUTIONS
     • master-worker and master-master configuration
     • creating a cluster

Duration

24 h/3 days

Price includes

Zamów szkolenie