MySQL Server continues to be one of the world’s most popular, FREE and top databases. Database is a heart of IT which is needed to stored all critical data and information.
MySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone. MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machine.

Course Objectives

At the end of this MYSQL DBA Training module, you will be able to:
  • Understand MySQL products, professional services and support for your operating system.
  • Define a relational database management system (RDBMS)
  • Explain the use of SQL and MySQL with relational databases
  • Define data definition language (DDL) and data manipulation language (DML)
  • Understand MySQL client/server model and work with MySQL connectors.
  • Install the MySQL server on Linux, start and stop MySQL server
  • Interact with the server using the MySQL command-line client.
  • Log your MySQL command-line client session to a text file.
  • Use MySQL Workbench to interact with the server.
  • Mysql Backup and replication
  • Mysql restore etc

Target Audience

  • Database Administrators
  • Software Developers
  • Web Developers
  • Data Analysts and Data Scientists
  • IT Professionals

Course Pre-Requisites

  • Programming Fundamentals
  • Basic Understanding of Databases
  • Command Line Basics
  • Operating System Knowledge

Course Summary

Course Fee

৳ 12,000

Training Method


Total Modules


Course Duration

24 Hours

Total Session


Class Duration

2 Hours

Details Course Outlines


Introduction to Databases and MySQL


MySQL Installation and Configuration


MySQL Database Design


SQL Fundamentals


Data Manipulation and Transactions


Database Backup and Recovery


Performance Tuning and Optimization


High Availability and Replication


Security and Access Control


MySQL Utilities and Tools


Case Studies and Real-world Scenarios


Best Practices and Advanced Topics