Visit Broadbeans Inc., your one-stop education center


Broadbeans Inc.

We want to help make you succeed in the fast-paced world of technology. That is why, we, at Broadbeans Inc., are committed to providing customized courses uniquely tailored for each individual person or business. We want to be your one-stop education center. Because we understand that you would rather deal with one than many, we want to provide you courses that will help you and your business succeed. We provide both scheduled short courses for individuals and groups as well as custom courses for your company's training needs. We specialize in programming courses in software engineering essentials, object-oriented software engineering, Java, C++, UML, mobile application development, JavaScript, PHP/ MySQL, and Perl. We also can customize a course directly for your company. And we can be there every step of the way.

 Broadbeans Inc.
 Your one-stop
 education center.

Broadbeans Inc. is committed to serving the environment, and is the only training company to offer sustainable customized courses. We offer paperless options for courses at your request.

 For more info on how 
 Broadbeans Inc. can serve
 you, contact:


Advanced MySQL 

Learning Objectives

This course Advanced MySQL will cover advanced topics on MySQL database concepts and administration. Participants will learn the fundamentals required to install, configure, administer, and tune MySQL as a database. This course reviews basic SQL structure and database concepts, and it also examines advanced concepts like setting up and securing users, tuning operations, and performing replication and backups.  

Upon completion of this course, the participants will learn:

* Storage engine and indexing;
* Query and server performance tuning;
* Advanced server configuration and database designs;
* Replication and load balancing;
* Backups and security, user access and privileges.

Course Topics

DAY 1:
MySQL Introduction
* Who Owns MySQL? Is it open source?
* Why to use MySQL?
* Who are using MySQL?
* Past, Present & Future features of MySQL
MySQL Storage Engines
* MySQL Architecture
* Locking and Concurrency
* Transactions
* Selecting the Right Engine
* The Storage Engines
* Indexing Basics
* Index Structures
* Indexes and Table Types
* Index Maintenance
Hands-on sessions on MySQL Indexing

DAY 2:
Query Performance
* Query Processing Basics
* Optimizer Features and Oddities
* Identifying Slow Queries
* Influencing MySQL with Hints
* Stupid Query Tricks
Server Performance Tuning
* Performance-Limiting Factors
* Operating System
* Techniques
* Replication Overview
* Configuring Replication
* Under the Hood
* Replication Architectures
* Administration and Maintenance
* Common Problems
* The Future of Replication
Hands-on sessions on MySQL performance and replication

DAY 3:
Load Balancing
* Load Balancing Basics
* Configuration Issues
* Cluster Partitioning
* High Availability
Back-up & Recovery
* Why Backups?
* Considerations and Tradeoffs
* Tools and Techniques
* Rolling Your Own Backup Script
* Account Basics
* The Grant Tables
* Grant and Revoke
* Operating System Security
* Network Security
* Data Encryption
* MySQL in a chrooted Environment
Hands-on sessions on MySQL balancing, backup, and security



Ankur Patel holds a master degree in computer from Utah State University, USA. He has software development experience for over a decade using open source technologies like Linux, Perl, PHP, RoR, Java etc. He has worked with international clients based in USA, UK, Canada, Netherlands, Australia, Italy, Ireland, France etc. He has worked on many different projects - ranging from small software to complex web applications. Ankur has a passion for teaching and his current focus of work has been consulting, training and mentoring teams (at his own company - Infotrex Services Pvt. Ltd.) on Open Source Technologies.


This course is intended for system administrators, developers, and database administrators who have prior knowledge of MySQL and who want to learn advanced features and MySQL administration. Working experience of MySQL is required before beginning this course.



Nov. 13-15, 2017 


9:00am to 5:00pm 


Seattle, WA (USA)

Closing Date:

4 weeks before the course begins 

Course Fee:



Registration fees inclusive of:

  • Course materials

  • Light refreshments

  • Certificate of Completion


Note that all participants are requested to bring their own laptop to class. 

Online Registration

Register Online or email


Payment Options

1. Online Payment (Visa / Mastercard / Amex / Paypal)

2. Check

3. Invoice to Company (for Company Sponsored Participants)

Cancellation & Refund Policy

Withdrawal or deferment notice must be made in writing to at least 4 weeks before the course begins.
In the event that the course is cancelled due to unforeseen circumstances, full refund will be given. Broadbeans Inc. reserves the right to substitute the course instructor with another of similar experience in case of extenuating conditions.




For general questions or comments about the Broadbeans Inc. site, please send e-mail to

Thanks for taking the time to give us your comments.

Broadbeans Inc.