beeon.academy
backendIntermediate

Percona

An intermediate Percona path (ArT list: Persona): what Percona is vs MySQL/MariaDB, install, MySQL-compatible SQL and InnoDB, users/GRANT, mysqldump, XtraBackup and Toolkit/PMM peek, replication idea, and a lab capstone. Practice in the player; run real statements in the mysql client.

PerconaMySQLXtraBackupInnoDB
Duration
6 weeks
Starts
Students
0+
Rating
0 / 5
Starting from
39 000 ֏
Enrolling now
  • 6 weeks (22h total)
  • Starts
  • online format
  • HY · EN · RU
  • Certificate on completion
Register nowStart learning

No payment required to register · We’ll contact you within 24h

What this course is about

Overview

An intermediate Percona path (ArT list: Persona): what Percona is vs MySQL/MariaDB, install, MySQL-compatible SQL and InnoDB, users/GRANT, mysqldump, XtraBackup and Toolkit/PMM peek, replication idea, and a lab capstone. Practice in the player; run real statements in the mysql client.

Across 6 weeks (22 hours of live + project work) you’ll move from fundamentals to shipping a real, production-grade project — guided by Tigran Hakobyan and the beeon.academy mentor team.

Learning outcomes

What you will learn

Install/connect to Percona Server
Write MySQL-compatible SQL with InnoDB habits
Know XtraBackup and Toolkit by name
Finish a mini lab + dump habit
Interactive course

Lessons

39 lessons · all open, start with any
  1. 1What is Percona?30 min
  2. 2Percona vs MySQL / MariaDB35 min
  3. 3Percona products map30 min
  4. 4When teams pick Percona30 min
  5. 5Install Percona Server40 min
  6. 6mysql client habit30 min
  7. 7Practice habit25 min
  8. 8CREATE DATABASE30 min
  9. 9CREATE TABLE + InnoDB35 min
  10. 10Core types35 min
  11. 11PRIMARY KEY and FOREIGN KEY40 min
  12. 12INSERT / UPDATE / DELETE40 min
  13. 13SELECT / WHERE / LIMIT35 min
  14. 14JOIN40 min
  15. 15Aggregates + GROUP BY35 min
  16. 16Indexes40 min
  17. 17Transactions40 min
  18. 18CREATE USER35 min
  19. 19GRANT / REVOKE35 min
  20. 20SHOW VARIABLES peek35 min
  21. 21my.cnf / config peek35 min
  22. 22SHOW STATUS peek30 min
  23. 23EXPLAIN35 min
  24. 24mysqldump still works35 min
  25. 25What is XtraBackup?40 min
  26. 26XtraBackup flow (lab idea)40 min
  27. 27Restore into a lab35 min
  28. 28Percona Toolkit peek35 min
  29. 29pt-table-checksum idea30 min
  30. 30Slow query habit35 min
  31. 31Monitoring peek30 min
  32. 32Replication idea35 min
  33. 33Percona in Docker peek30 min
  34. 34App compatibility30 min
  35. 35Security habit30 min
  36. 36Mini lab40 min
  37. 37Percona vs plain MySQL wrap30 min
  38. 38Next steps25 min
  39. 39Capstone checklist40 min
Course modules

Syllabus

  1. 1
    • What is Percona?
    • Percona vs MySQL
    • Install
    • mysql client
  2. 2
  3. 3
  4. 4
What you need to start

Requirements

  • A laptop and willingness to run Percona or a MySQL-compatible server
  • MySQL/MariaDB basics help
  • No prior DBA experience required
Learn from a working engineer

Your instructor

TH

Tigran Hakobyan

Backend Mentor · beeon.academy

Instructor at beeon.academy. Percona path (ArT list Persona): 39 lessons through the capstone.

What graduates say

Student reviews

Common questions

FAQ

In the ArT list, Persona sat in the Databases block after MySQL. Professionally that maps to Percona Server. If you meant something else, say so and we will rename.
Starting from
39 000 ֏
Register