Course curriculum

  1. 1

    • 1- ( Presentation) Introduction of MySQL
  2. 2

    • 2- (Recording and Demo steps )How to Install MySQL on Linux ?

    • Assignment on installation of MySQL on Linux
  3. 3

    • Recording and Demo steps (How to Reset lost root MySQL password ?)

    • Assignment

  4. 4

    • Recording and demo steps How to run Mysql as Mysql OS user

    • Assignment

  5. 5

    • Assignment on How To Allow Remote Access to MySQL ?

    • (Recording and demo steps ) How to enable remote connection to MySQL database ?
  6. 6

    • How to load sample database like sakilla /db_master in MySQL ?

    • Assignment ( How to load sample database in MySQL ? )

    • Recording and demo steps
  7. 7

    • How to Find the location of my.cnf in Mysql Linux server ?
  8. 8

    • Tuning Primer script for tuning
  9. 9

    • mysqltuner.pl- High Performance MySQL Tuning Script
  10. 10

    • How to find my.cnf file in linux for MySQL Server ?
  11. 11

    • Recording and Demo Steps (Backup and restore in Mysql database via mysqldump/mysql command)

    • Assignment Backup & Restore in MYSQL Database server ( mysqldump/mysql utility)

    • Assignment on ( backup all MySQL DB's on Linux , compress and schedule as script )

    • Backup script automated on linux

    • Backup and restore in Mysql via Workbench
  12. 12

    • Recording and demo steps Upgrade MySQL 5.7 to 8.0 on Ubuntu Linux
  13. 13

    • Upgrade Via backup and upgarde
  14. 14

    • Demo steps for Upgrade Checker Utility.
  15. 15

    • MyDumper/myloader
  16. 16

    • Password less authentication using mysql_config_editor

    • (Recording and demo steps )Password less authentication using mysql_config_editor
  17. 17

    • MySQL Backup Tools
  18. 18

    • Recording an demo steps Replication across version ( Replication between 5.7 to 8.0 )
  19. 19

    • mysql workbench recordings and demo steps
  20. 20

    • mysqlslap perf load testing tool
  21. 21

    • Recording and demo steps Bin Log

    • mysqlbinlogpurgetool to Purge/delete MySQL Binary Logs

  22. 22

    • Recording and demo on ( MySQL GTIDs Replication)

    • Assignment on GTID Replication

  23. 23

    • Recording (MySQL Master-Slave Replication )

    • Assignment : Replication master and slave setup

    • master and slave replication setup Configure the slave of 2 existing databases

    • How to check the replication status using shell script in MySQL master replica?

    • Demo and recording steps

    • Monitoring Replication Main Threads using show processlist

    • How to Pause Replication on the Replica?

    • Troubleshooting Replication in Mysql ?

    • Add one More replica database to existing master replica setup ?
  24. 24

    • Recording and demo on ( MASTER MASTER REPLICATION in MySQL )
  25. 25

    • Recording and demo (Sysbench , MySQL Benchmark Performance Tool ?)

    • Assignment Sysbench , MySQL Benchmark Performance Tool ?
  26. 26

    • What are different types of MySQL Server Logs and their Importance ?
  27. 27

    • mysqladmin is an administration program for tasks in MySQL.
  28. 28

    • MySQL user management

    • MySQL percona / percona-toolkit
  29. 29

    • MySQL Upgrade strategies
  30. 30

    • Recording and Demo steps (How to synchronize two databases by using MySQL Workbench)

    • How to Compare two Databases using MySQL Workbench

    • How to migrate database from one mysql server to another MYSQL server (Schema Migration WIZARD)

    • How to migrate database/replicate from one mysql server to another host(MIGRATION WIZARD)
  31. 31

    • Recording and Demo steps (Group replication in MySQL)