beeon.academy
backendIntermediate

MySQL + MariaDB

An intermediate MySQL/MariaDB path: install and mysql client, utf8mb4, tables with InnoDB, SQL queries (JOIN, LIMIT, CTE), users/GRANT, mysqldump, MariaDB/Percona peek, and a schema lab capstone. Practice in the player; run real statements in the client.

MySQLMariaDBSQLInnoDB
Duration
7 weeks
Starts
Students
0+
Rating
0 / 5
Starting from
49 000 ֏
Enrolling now
  • 7 weeks (29h 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 MySQL/MariaDB path: install and mysql client, utf8mb4, tables with InnoDB, SQL queries (JOIN, LIMIT, CTE), users/GRANT, mysqldump, MariaDB/Percona peek, and a schema lab capstone. Practice in the player; run real statements in the client.

Across 7 weeks (29 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 MySQL or MariaDB and work in the client
Write DDL/DML and JOINs with InnoDB habits
Manage users/GRANT and mysqldump
Finish a mini schema capstone
Interactive course

Lessons

50 lessons · all open, start with any
  1. 1What is MySQL?30 min
  2. 2MySQL and MariaDB family30 min
  3. 3MySQL vs Postgres / SQL Server30 min
  4. 4Install MySQL or MariaDB40 min
  5. 5mysql client35 min
  6. 6Workbench / GUI peek25 min
  7. 7Check VERSION()25 min
  8. 8Practice habit25 min
  9. 9CREATE DATABASE30 min
  10. 10Charset and collation30 min
  11. 11CREATE TABLE40 min
  12. 12Core types40 min
  13. 13AUTO_INCREMENT35 min
  14. 14Constraints40 min
  15. 15Foreign keys40 min
  16. 16ALTER TABLE35 min
  17. 17DROP and TRUNCATE30 min
  18. 18INSERT35 min
  19. 19SELECT basics35 min
  20. 20WHERE40 min
  21. 21ORDER BY and LIMIT30 min
  22. 22UPDATE and DELETE40 min
  23. 23INNER JOIN45 min
  24. 24LEFT JOIN40 min
  25. 25Aggregates40 min
  26. 26GROUP BY and HAVING45 min
  27. 27Subqueries40 min
  28. 28CTE (WITH) peek35 min
  29. 29InnoDB habit35 min
  30. 30Storage engines peek25 min
  31. 31Transactions40 min
  32. 32Indexes40 min
  33. 33EXPLAIN lite35 min
  34. 34JSON type peek35 min
  35. 35SQL injection habit40 min
  36. 36Views30 min
  37. 37Users and hosts40 min
  38. 38GRANT and REVOKE40 min
  39. 39mysqldump35 min
  40. 40Restore from dump35 min
  41. 41MySQL vs MariaDB quirks30 min
  42. 42Percona peek30 min
  43. 43MySQL in Docker peek30 min
  44. 44Connection strings30 min
  45. 45Link to PHP PDO25 min
  46. 46Mini schema design40 min
  47. 47Mini SQL lab45 min
  48. 48When to pick MySQL/MariaDB30 min
  49. 49Next steps25 min
  50. 50Capstone checklist40 min
Course modules

Syllabus

  1. 1
    • What is MySQL?
    • MySQL and MariaDB family
    • Install
    • mysql client
  2. 2
  3. 3
  4. 4
What you need to start

Requirements

  • A laptop and willingness to install MySQL or MariaDB
  • Basic SQL ideas help
  • No prior DBA experience required
Learn from a working engineer

Your instructor

TH

Tigran Hakobyan

Backend Mentor · beeon.academy

Instructor at beeon.academy. MySQL + MariaDB path: 50 lessons through the capstone.

What graduates say

Student reviews

Common questions

FAQ

No. It checks SQL text. You run the same statements in the mysql client locally.
Starting from
49 000 ֏
Register