AI & Data

MySQL Database Administration Training

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

Duration
6h
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.

✓

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

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
AI & Data

Active Directory Training

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

AI & Data →
AI & Data

Advanced Power BI Training

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

AI & Data →
AI & Data

Advanced RPA Developer Training

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

AI & Data →