MySQL Administration

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 Jul 7-8, 2025 9:00 AM - 5:00 PM Tarun Sukhani
updated
intermediate
MySQL Administration
We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500
Total Fees: MYR 6500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 5600
Material Fees: MYR 600
Total Fees: MYR 6200

Features

2 days
14 modules
12 intakes
English

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

What is MySQL
Basic SQL
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 1
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 2

Instructor

Loading...
Tarun Sukhani Founder & CTO Teaching

Tarun Sukhani is a distinguished professional trainer and consultant with nearly 30 years of experience in the IT and business sectors, having worked internationally across AMER, APAC, and EMEA. His expertise spans a wide array of domains such as Agile methodologies (Scrum, SAFe, Kanban), enterprise architecture frameworks like TOGAF and COBIT, IT service management standards including ITIL and ISO27001, as well as cybersecurity certifications like CISO and CISSP. Tarun's proficiency extends to project management frameworks such as PRINCE2 and PMP, along with cutting-edge technologies in Big Data analytics using Hadoop and Spark, data science with Python or R, and data visualization tools like Tableau. Tarun has held numerous senior development and executive roles including CIO/CTO positions where he managed large-scale IT operations for multinational corporations such as Dell, AMD, and Experian. His leadership skills have been instrumental in enhancing business operations across various functions including HR, Finance, Operations, Sales, Risk Management, Engineering/Manufacturing, and Accounting. He has also contributed significantly to regional conglomerates like Indra in the Asia Pacific region. A passionate educator at heart, Tarun has facilitated training workshops throughout Asia Pacific countries such as Malaysia, Indonesia, Philippines, Thailand, and Singapore. His training sessions cover a broad spectrum of topics from project management to strategic leadership and soft skills development. Additionally, he specializes in advanced technical subjects like software architecture design patterns for reactive microservices architectures on cloud platforms. Tarun's academic credentials are equally impressive; he graduated summa cum laude with an MSc in Information Systems and an MBA in Finance and Operations Management from Loyola University Chicago. He holds multiple Bachelor's degrees in Biology, Math & Computer Science alongside Business Administration. Further enriching his knowledge base are certifications as an Agile/Scrum trainer; Java/.NET programmer; Machine Learning specialist; InfoSec expert; Business Intelligence professional; complemented by advanced studies in AI & Blockchain from prestigious institutions like MIT & Stanford. His client portfolio includes renowned organizations such as Western Digital/Sandisk for machine learning product management projects; Singtel & CIMB for agile product development initiatives; Tenaga Nasional & JPJ for agile project management engagements among others. Tarun's dynamic approach combined with his deep-rooted passion for developing people makes him a sought-after speaker at international conferences where he shares insights on digital transformation strategies.

18 Students
229 Courses
English, Malay, Spanish

Minimum Qualification

undergraduate

Target Audience

students
entry level
engineers

Methodologies

lecture
slides
case studies
labs
group discussion

Instructor Reviews

Tarun Sukhani Founder & CTO
MK
Michael Wong Shen Kai
3 years ago
3 years ago

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.

AA
Anak Agung
3 years ago
3 years ago

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.

PC
Pei Cher Chai
3 years ago
3 years ago

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

LO
LJ Ong
3 years ago
3 years ago

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

AS
Aamer S
3 years ago
3 years ago

His knowledge of multiple subjects exceeds far greater than that of any IT or non-IT person I have met or interacted with in a long time. The breadth and depth of the subject matter he has acquired is exemplary.

JK
Jovyn Kim
3 years ago
3 years ago

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.

SK
Srikanth K
3 years ago
3 years ago

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.

ZY
Zulfikri Y
3 years ago
3 years ago

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.

review avatar
Marti Sigi
5 years ago
5 years ago

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!

PK
Pravena K
3 years ago
3 years ago

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

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

What is MySQL
Basic SQL
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 1
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 2

Instructor Reviews

Tarun Sukhani Founder & CTO
MK
Michael Wong Shen Kai
3 years ago
3 years ago

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.

AA
Anak Agung
3 years ago
3 years ago

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.

PC
Pei Cher Chai
3 years ago
3 years ago

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

LO
LJ Ong
3 years ago
3 years ago

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

AS
Aamer S
3 years ago
3 years ago

His knowledge of multiple subjects exceeds far greater than that of any IT or non-IT person I have met or interacted with in a long time. The breadth and depth of the subject matter he has acquired is exemplary.

JK
Jovyn Kim
3 years ago
3 years ago

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.

SK
Srikanth K
3 years ago
3 years ago

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.

ZY
Zulfikri Y
3 years ago
3 years ago

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.

review avatar
Marti Sigi
5 years ago
5 years ago

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!

PK
Pravena K
3 years ago
3 years ago

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

We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500
Total Fees: MYR 6500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 5600
Material Fees: MYR 600
Total Fees: MYR 6200

Features

2 days
14 modules
12 intakes
English

Subsidies

HRDC Claimable logo

Instructor

Loading...
Tarun Sukhani Founder & CTO Teaching

Tarun Sukhani is a distinguished professional trainer and consultant with nearly 30 years of experience in the IT and business sectors, having worked internationally across AMER, APAC, and EMEA. His expertise spans a wide array of domains such as Agile methodologies (Scrum, SAFe, Kanban), enterprise architecture frameworks like TOGAF and COBIT, IT service management standards including ITIL and ISO27001, as well as cybersecurity certifications like CISO and CISSP. Tarun's proficiency extends to project management frameworks such as PRINCE2 and PMP, along with cutting-edge technologies in Big Data analytics using Hadoop and Spark, data science with Python or R, and data visualization tools like Tableau. Tarun has held numerous senior development and executive roles including CIO/CTO positions where he managed large-scale IT operations for multinational corporations such as Dell, AMD, and Experian. His leadership skills have been instrumental in enhancing business operations across various functions including HR, Finance, Operations, Sales, Risk Management, Engineering/Manufacturing, and Accounting. He has also contributed significantly to regional conglomerates like Indra in the Asia Pacific region. A passionate educator at heart, Tarun has facilitated training workshops throughout Asia Pacific countries such as Malaysia, Indonesia, Philippines, Thailand, and Singapore. His training sessions cover a broad spectrum of topics from project management to strategic leadership and soft skills development. Additionally, he specializes in advanced technical subjects like software architecture design patterns for reactive microservices architectures on cloud platforms. Tarun's academic credentials are equally impressive; he graduated summa cum laude with an MSc in Information Systems and an MBA in Finance and Operations Management from Loyola University Chicago. He holds multiple Bachelor's degrees in Biology, Math & Computer Science alongside Business Administration. Further enriching his knowledge base are certifications as an Agile/Scrum trainer; Java/.NET programmer; Machine Learning specialist; InfoSec expert; Business Intelligence professional; complemented by advanced studies in AI & Blockchain from prestigious institutions like MIT & Stanford. His client portfolio includes renowned organizations such as Western Digital/Sandisk for machine learning product management projects; Singtel & CIMB for agile product development initiatives; Tenaga Nasional & JPJ for agile project management engagements among others. Tarun's dynamic approach combined with his deep-rooted passion for developing people makes him a sought-after speaker at international conferences where he shares insights on digital transformation strategies.

18 Students
229 Courses
English, Malay, Spanish

Minimum Qualification

undergraduate

Target Audience

students
entry level
engineers

Methodologies

lecture
slides
case studies
labs
group discussion
Close menu