MySQL Database Administration Training Course

Become an adept MySQL administrator with our targeted training course designed to hone your expertise in database setup, configuration, security, maintenance, monitoring, backup strategies, and more. Enroll now to transform data management into a strategic asset.

Face-to-Face May 18-19, 2026 9:00 AM - 5:00 PM Tarun Sukhani
intermediate
MySQL Administration
We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 6200 ++

Features

2 days
16 modules
8 intakes
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
case studies
group discussion

Subsidies

HRDC Claimable logo

What you'll learn

  • Design databases effectively and perform advanced querying techniques
  • Optimize database performance through proper index utilization
  • Implement robust security measures to prevent unauthorized access
  • Learn about MySQL configuration files and practice variable modifications
  • Master backup procedures and prepare for efficient database migrations
  • Configure initial database settings and troubleshoot common issues
  • Understand MySQL basics and installation processes for different systems
  • Persist database configurations accurately for consistent performance

Why should you attend?

Dive into the world of database management with our extensive MySQL Administration Training Course, meticulously crafted to equip you with a robust understanding of MySQL, the world's most popular open-source relational database management system. Begin your journey by exploring the fundamentals of MySQL and basic SQL commands that form the backbone of data manipulation and retrieval. As you progress, you will delve into the various installation methods for both rpm and deb-based systems, ensuring a smooth setup process. The course further guides you through initial database configurations, essential troubleshooting techniques, and effective error log analysis. Gain hands-on experience in configuring MySQL variables, understanding the my.cnf file structure, and modifying dynamic variables within a lab setting. Sharpen your skills in querying data by designing databases, inserting, and modifying data efficiently. Master the art of working with indexes to optimize query performance while avoiding common pitfalls. Enhance your knowledge on configuring security to safeguard against potential threats like SQL injection attacks. Learn to persist configuration parameters across sessions and understand the intricacies of different storage engines. Discover crucial InnoDB parameters settings and manage filesystem-related MySQL files. Create users and databases tailored for specific applications and familiarize yourself with user management best practices. The course also covers essential MySQL usage basics such as roles, binary logs, GTIDs replication, and migrating replication domains to GTID replication. Finally, develop proficiency in command line monitoring using various tools, execute reliable backups with logical and physical backup methods including Percona Xtrabackup, and prepare for migration considerations while verifying query behavior during replication-based migrations.

Course Syllabus

Day 1 - MySQL Setup and Fundamentals
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Configuration and Operations
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2

Instructor

Loading...
Tarun Sukhani IT Executive & Data Science Leader
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation

Tarun Sukhani is a distinguished IT and Finance Executive with over 25 years of comprehensive experience in leading enterprise software solutions, business intelligence, and digital transformation initiatives. As a seasoned professional with a multi-cultural background and international work experience spanning the United States, Malaysia, and beyond, he brings exceptional expertise in designing and delivering highly scalable, concurrent, and performant enterprise systems with budgets reaching $100 million.

With an impressive academic foundation that includes a Doctor of Business Administration (in progress), dual Master's degrees in Information Systems Management and Business Administration from Loyola University Chicago, and multiple Bachelor's degrees from prestigious institutions including the University of Chicago and University of Illinois, Tarun combines theoretical knowledge with practical application. His specialization in Business Intelligence, Data Warehousing, Data Mining, and emerging technologies such as Deep Learning, IoT, and Blockchain positions him at the forefront of technological innovation.

As a polyglot developer with programming experience in over 20 languages and technologies, Tarun demonstrates remarkable versatility across the full software development lifecycle. His technical competencies span from traditional enterprise technologies (.NET, Java, C++) to modern frameworks (Python, Ruby, JavaScript/TypeScript) and cutting-edge platforms including Big Data ecosystems (Hadoop, Spark), Machine Learning frameworks (TensorFlow, DeepLearning4J), and Blockchain technologies (Ethereum, Hyperledger). His expertise extends to cloud architectures, DevOps practices, mobile development, and enterprise application integration.

Currently serving as Project Manager and Scrum Master at TopTal, one of the world's most selective consultancies accepting only 3% of applicants, Tarun provides project oversight and hands-on development for Fortune 500 and FAANG companies. His entrepreneurial spirit is evident through his role as Founder and CTO of Abundent, where he leads digital transformation initiatives and develops innovative solutions in facial recognition, fraud detection, and fintech.

Tarun's extensive training and consulting portfolio includes partnerships with premier training providers across Malaysia, Singapore, Europe, and the United States. He holds numerous industry certifications including Certified Scrum Master, Certified Scrum Professional, ITIL, TOGAF, and specialized certifications in Deep Learning and Information Security. His pedagogical expertise, combined with his technical depth, makes him an exceptional educator capable of translating complex technical concepts into actionable knowledge for diverse audiences across government, academic, and corporate sectors.

21 Students
59 Courses
English, Malay, Spanish
27 Years

Instructor Reviews

TS

Tarun Sukhani

IT Executive & Data Science Leader

"I attended one of Tarun's Data Science course in Jakarta (CDSS). He was a professional trainer & very knowledgeable in Data Science. In his course, Tarun gave many practical examples & valuable information regarding how to conduct Data Science & it's related components (e.g. Software & Deployment Architecture). In addition to those lessons, he also gave very useful insights on building a career as a Data Scientist."

"He shared his professional insights on data science with a sense of humor that cleared up so many of my questions about the content and real-world applications. Information, tools, and resources given are very useful"

"Tarun is very passionate on the domains and gave numerous insights to support critical business decisions and develop data products to transform daily encounters and processes. He was a professional trainer & very knowledgeable in Data Science. His material is presented through a sequence of brief lectures, interactive demonstrations, great hands-on exercises, and discussions."

"Tarun is the best Data Science lecturer you can find. He is experienced, knowledgeable and humorous, someone who is willing to share generously his working experience and knowledge in the field with the students. "

"Training with Tarun has been awesome. He’s super knowledgable, funny, empathetic and a great educator in general. As someone who didn’t come from a computer science background, his teachings didn’t make me feel stupid or impossible to eventually arrive at being a competent developer. I could understand him as he communicates well & has helped me see the big picture of the computer science field beyond the scope of syntaxes. If you similarly did not come from a CS background and hope to transition into the world of programming but struggle to learn on your own, understand all the foreign & abstract concepts and connect the dots, I think the right person to guide you on your journey would make a big difference. Having someone who’s deep in the field with many years of experience narrow and communicate the relevant areas to focus would also close a big gap from having to struggle and figure out a lot of things on your own. Being able to maintain your interest during your learning journey is important too, thus finding that someone is important. All in all, I would wholeheartedly recommend Tarun and the backend course I took."

"Tarun is a results-driven & inspirational technology leader with a clear vision, direction, and broad-based technology expertise. He is passionate, intuitive, engaged, pragmatic, systematic, agile. His experiences span from small start-ups to complex, global companies, from being technical lead to technical strategist to being the leader of larger group of architecture and engineering teams. Much of his experiences are in the area of Java, Scala, Machine Learning, Neural Networks, Cloud Computing, Data Science and what not. I am truly amazed to experience his breadth & depth of technological expertise and pleasure to be part of his team."

"He was indeed very skilled, knowledgeable and passionate in the data science realm. I was impressed with his business know-how (how the world economy works and how all things can be explain with data, with/without bias) and technical skills in converting data into insights. I will not hesitate to recommend Tarun for any data science related training as I would like to attend more classes myself to learn from the best of the best."

"We’ve been collaborated many times in doing courses for the accountants. He spoke to quiet number of event in our company with various topic regards to accountants need. The collaboration was very smooth and his session definitely made a huge impact on our success. Mr Tarun is a great Professional!"

"Mr. Tarun is a driven, hardworking, and knowledgeable entrepreneur in his field." A broad-minded trainer who embraces change and inspires people to do better every day. Mr. Tarun sets a good example by being enthusiastic and dedicated, and he inspires and motivates others. I am delighted to be working for such personnel"

"Attended "Blockchain Training: An Overview for Business Professionals" conducted by Dr. Tarun. The reference materials are very comprehensive and an excellent means of conveying information. I was very impressed with how this technology works and adapted into business"

FAQ

Frequently Asked Questions About This Course

Why should you attend?

Dive into the world of database management with our extensive MySQL Administration Training Course, meticulously crafted to equip you with a robust understanding of MySQL, the world's most popular open-source relational database management system. Begin your journey by exploring the fundamentals of MySQL and basic SQL commands that form the backbone of data manipulation and retrieval. As you progress, you will delve into the various installation methods for both rpm and deb-based systems, ensuring a smooth setup process. The course further guides you through initial database configurations, essential troubleshooting techniques, and effective error log analysis. Gain hands-on experience in configuring MySQL variables, understanding the my.cnf file structure, and modifying dynamic variables within a lab setting. Sharpen your skills in querying data by designing databases, inserting, and modifying data efficiently. Master the art of working with indexes to optimize query performance while avoiding common pitfalls. Enhance your knowledge on configuring security to safeguard against potential threats like SQL injection attacks. Learn to persist configuration parameters across sessions and understand the intricacies of different storage engines. Discover crucial InnoDB parameters settings and manage filesystem-related MySQL files. Create users and databases tailored for specific applications and familiarize yourself with user management best practices. The course also covers essential MySQL usage basics such as roles, binary logs, GTIDs replication, and migrating replication domains to GTID replication. Finally, develop proficiency in command line monitoring using various tools, execute reliable backups with logical and physical backup methods including Percona Xtrabackup, and prepare for migration considerations while verifying query behavior during replication-based migrations.


What you'll learn

  • Design databases effectively and perform advanced querying techniques
  • Optimize database performance through proper index utilization
  • Implement robust security measures to prevent unauthorized access
  • Learn about MySQL configuration files and practice variable modifications
  • Master backup procedures and prepare for efficient database migrations
  • Configure initial database settings and troubleshoot common issues
  • Understand MySQL basics and installation processes for different systems
  • Persist database configurations accurately for consistent performance

Course Syllabus

Day 1 - MySQL Setup and Fundamentals
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Configuration and Operations
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2

Instructor Reviews

TS

Tarun Sukhani

IT Executive & Data Science Leader

"I attended one of Tarun's Data Science course in Jakarta (CDSS). He was a professional trainer & very knowledgeable in Data Science. In his course, Tarun gave many practical examples & valuable information regarding how to conduct Data Science & it's related components (e.g. Software & Deployment Architecture). In addition to those lessons, he also gave very useful insights on building a career as a Data Scientist."

"He shared his professional insights on data science with a sense of humor that cleared up so many of my questions about the content and real-world applications. Information, tools, and resources given are very useful"

"Tarun is very passionate on the domains and gave numerous insights to support critical business decisions and develop data products to transform daily encounters and processes. He was a professional trainer & very knowledgeable in Data Science. His material is presented through a sequence of brief lectures, interactive demonstrations, great hands-on exercises, and discussions."

"Tarun is the best Data Science lecturer you can find. He is experienced, knowledgeable and humorous, someone who is willing to share generously his working experience and knowledge in the field with the students. "

"Training with Tarun has been awesome. He’s super knowledgable, funny, empathetic and a great educator in general. As someone who didn’t come from a computer science background, his teachings didn’t make me feel stupid or impossible to eventually arrive at being a competent developer. I could understand him as he communicates well & has helped me see the big picture of the computer science field beyond the scope of syntaxes. If you similarly did not come from a CS background and hope to transition into the world of programming but struggle to learn on your own, understand all the foreign & abstract concepts and connect the dots, I think the right person to guide you on your journey would make a big difference. Having someone who’s deep in the field with many years of experience narrow and communicate the relevant areas to focus would also close a big gap from having to struggle and figure out a lot of things on your own. Being able to maintain your interest during your learning journey is important too, thus finding that someone is important. All in all, I would wholeheartedly recommend Tarun and the backend course I took."

"Tarun is a results-driven & inspirational technology leader with a clear vision, direction, and broad-based technology expertise. He is passionate, intuitive, engaged, pragmatic, systematic, agile. His experiences span from small start-ups to complex, global companies, from being technical lead to technical strategist to being the leader of larger group of architecture and engineering teams. Much of his experiences are in the area of Java, Scala, Machine Learning, Neural Networks, Cloud Computing, Data Science and what not. I am truly amazed to experience his breadth & depth of technological expertise and pleasure to be part of his team."

"He was indeed very skilled, knowledgeable and passionate in the data science realm. I was impressed with his business know-how (how the world economy works and how all things can be explain with data, with/without bias) and technical skills in converting data into insights. I will not hesitate to recommend Tarun for any data science related training as I would like to attend more classes myself to learn from the best of the best."

"We’ve been collaborated many times in doing courses for the accountants. He spoke to quiet number of event in our company with various topic regards to accountants need. The collaboration was very smooth and his session definitely made a huge impact on our success. Mr Tarun is a great Professional!"

"Mr. Tarun is a driven, hardworking, and knowledgeable entrepreneur in his field." A broad-minded trainer who embraces change and inspires people to do better every day. Mr. Tarun sets a good example by being enthusiastic and dedicated, and he inspires and motivates others. I am delighted to be working for such personnel"

"Attended "Blockchain Training: An Overview for Business Professionals" conducted by Dr. Tarun. The reference materials are very comprehensive and an excellent means of conveying information. I was very impressed with how this technology works and adapted into business"

We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 6200 ++

Features

2 days
16 modules
8 intakes
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
case studies
group discussion

Subsidies

HRDC Claimable logo

Instructor

Loading...
Tarun Sukhani IT Executive & Data Science Leader
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation

Tarun Sukhani is a distinguished IT and Finance Executive with over 25 years of comprehensive experience in leading enterprise software solutions, business intelligence, and digital transformation initiatives. As a seasoned professional with a multi-cultural background and international work experience spanning the United States, Malaysia, and beyond, he brings exceptional expertise in designing and delivering highly scalable, concurrent, and performant enterprise systems with budgets reaching $100 million.

With an impressive academic foundation that includes a Doctor of Business Administration (in progress), dual Master's degrees in Information Systems Management and Business Administration from Loyola University Chicago, and multiple Bachelor's degrees from prestigious institutions including the University of Chicago and University of Illinois, Tarun combines theoretical knowledge with practical application. His specialization in Business Intelligence, Data Warehousing, Data Mining, and emerging technologies such as Deep Learning, IoT, and Blockchain positions him at the forefront of technological innovation.

As a polyglot developer with programming experience in over 20 languages and technologies, Tarun demonstrates remarkable versatility across the full software development lifecycle. His technical competencies span from traditional enterprise technologies (.NET, Java, C++) to modern frameworks (Python, Ruby, JavaScript/TypeScript) and cutting-edge platforms including Big Data ecosystems (Hadoop, Spark), Machine Learning frameworks (TensorFlow, DeepLearning4J), and Blockchain technologies (Ethereum, Hyperledger). His expertise extends to cloud architectures, DevOps practices, mobile development, and enterprise application integration.

Currently serving as Project Manager and Scrum Master at TopTal, one of the world's most selective consultancies accepting only 3% of applicants, Tarun provides project oversight and hands-on development for Fortune 500 and FAANG companies. His entrepreneurial spirit is evident through his role as Founder and CTO of Abundent, where he leads digital transformation initiatives and develops innovative solutions in facial recognition, fraud detection, and fintech.

Tarun's extensive training and consulting portfolio includes partnerships with premier training providers across Malaysia, Singapore, Europe, and the United States. He holds numerous industry certifications including Certified Scrum Master, Certified Scrum Professional, ITIL, TOGAF, and specialized certifications in Deep Learning and Information Security. His pedagogical expertise, combined with his technical depth, makes him an exceptional educator capable of translating complex technical concepts into actionable knowledge for diverse audiences across government, academic, and corporate sectors.

21 Students
59 Courses
English, Malay, Spanish
27 Years

FAQ

Frequently Asked Questions About This Course

Close menu