Training with Paragon Consulting Services
At Paragon, we love to teach! There is nothing more gratifying than seeing a student “get it”. The principal behind Paragon is the published author of MySQL Administrator’s Bible (Wiley Publishing). The primary goal of this book was to teach beginner and intermediate-level MySQL administrators the skills they need to succeed with MySQL.
Working as a MySQL database administrator he knows what it means to be in charge of production servers. Tuning, scaling, backups and user management are all done on a daily basis. Having learned in the trenches, he seeks to teach others so that they can bypass some of the obstacles that he had to overcome.
In addition to our group classes, Paragon can work with your company to provide in-house training.
The benefits of taking a training class with Paragon Consulting Services include:
Maximum class size of twelve students so everyone gets the individual attention they deserve.
|
Acknowledged expert MySQL administrator teaching the class.
|
Every student receives a laptop computer with at least 2 GB of RAM, a 15” screen and 160 GB hard drive to use during the class. When the class is over the student keeps the laptop!
|
A 100% money-back guarantee if you are not satisfied. |
Our next class is in Marietta, Georgia (Metro Atlanta) and begins March the 30th. This five day class will cover everything needed by someone who is getting involved with MySQL Server in order to be able to effectively administer MySQL 5.0 and 5.1 servers.
The class cost $2495 and if you sign up by the end of the day on March 2nd you will receive a $200 discount.
Signup is available through credit card or Paypal
Questions? Email us at training@paragon-cs.com or call (850) 637-3877
Curriculum
- MySQL Server background
- MySQL Server architecture
- Client/server
- Pluggable storage engine
- Accessing MySQL Server
- Using the mysql command line client
- GUI tools
- MySQL installation and configuration
- MySQL installation for Windows servers
- MySQL installation for Unix-based servers
- Binary package install
- Source code compilation/install
- Upgrading MySQL installations
- Managing the configuration file
- Locking levels
- Work with storage engines
- Choosing a storage engine
- Optimizing storage engine settings
- Optimizing the MySQL server
- Optimizing the operating system for MySQL Server
- Optimizing hardware for MySQL Server
- Database design considerations
- Query analysis
- Index tuning
- The information_schema database
- Working with the query cache
- Backups, the restoration process and disaster planning
- Logging and replication
- Benchmarking
- Database maintenance
- MySQL Server Security
- User privileges
- SQL injection
- SSL-based user access
- Server-level issues
- Monitoring MySQL servers
- Partitioning
- Triggers and Events
- Stored procedures
- Views
- Scaling and high-availability
|
|