Keith's Blog Keith's Presentations Querry Processing See MySQL Magazine Info on Upcoming Classes Paragon Home Page
 

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).

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 on providing training in-house.

Our next class in Atlanta, Georgia 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.


Here's What You'll Learn...

  • 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
      • Binary package install
    • 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




Home Page   |   Site Map



(850) 637-3877