To wersja testowa nowego serwisu infoShare Academy — wyświetlane treści i oferta nie są wiążące ani kompletne

Data

MySQL database administration

The MySQL Database Administration training is focused on learning how to manage and maintain database systems based on MySQL.

Duration
24h · 3 days
Ask about the program → See all
Who it's for

Ideal for teams that…

1 Anyone who wants to learn the basics of MySQL (or similar systems such as Percona, MariaDB) administration
2 Those whose roles include administrator, DevOps, or Site Reliability Engineer
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

Participants will learn both basic and some intermediate topics related to MySQL and MariaDB administration. They will practice managing users, performing backups, and optimizing databases via choosing appropriate storage engines and memory configurations. High-availability topics will also be covered, including setting up clusters and configuring master-worker replication.

Requirements

What you should know before we start

  • Basic knowledge of Linux, SSH configuration, and scripting fundamentals
  • Choice of one of the database engines
Program · 10 modules

What we actually do

M01
Introduction
  • · Components of MySQL
  • · MySQL installation
  • · Configuration files
M02
File Structures and Engines
  • · Overview of file structure
  • · Table storage engines
  • · Creating tables with a chosen engine
M03
Server Configuration
  • · Global server configuration
  • · User session settings
  • · Database-level verification
  • · Using SHOW GLOBAL and SET commands
M04
Memory Management
  • · Memory configuration
  • · Session buffer
  • · Global buffer
  • · Engine buffer
  • · Query cache
M05
Permissions
  • · Creating and removing users
  • · Managing permissions
M06
Transactions
  • · Isolation levels
  • · Data locks
  • · Managing and verifying active transactions
  • · Overview of performance_schema
M07
Tables and Partitions
  • · Creating and dropping partitions
  • · Temporary tables
M08
Backups
  • · Exporting databases
  • · Server-level exports
  • · Exporting individual objects
  • · Types of backups
  • · Using XtraBackup tool
  • · Restoring databases
M09
Logs
  • · Verifying logs
  • · Types of logs
  • · Tuning log settings
M10
High-Availability (HA) Solutions
  • · Configuring master–worker replication
  • · Configuring master–master replication
  • · Cluster setup
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

How we handle your data

We process your business data (name, work e-mail, phone number, company, job title) in order to handle your corporate training inquiry and prepare an offer. The data controller is infoShare Academy Sp. z o.o., Al. Grunwaldzka 472B, 80-309 Gdańsk. Providing the data is voluntary but necessary to receive a response. You have the right to access, rectify, erase or restrict the processing of your data and to object to it. Full information is available in our data processing notice.

Optional marketing consents

The controller of your personal data is infoShare Academy sp. z o.o. The rules for processing personal data are set out in the Privacy Policy and the Data Processing Notice.

Other programs for teams

See all →
Data

Active Directory

Hands-on AI and data analytics workshops — built around your team's real cases.

16h · 2 days →
Data

AI SQL Developer

Hands-on AI and data analytics workshops — built around your team's real cases.

24h · 3 days →
Data

Amazon Redshift - Introductory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

16h · 2 days →