Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

MySQL For Developers (5 days)


Designed for developers looking to develop applications and services under MySQL, this course focuses on the differences between MySQL and other database engines. OTG's MySQL for Developers course allows developers to quickly come up to speed - and acquire the skills they need to develop applications to utilize MySQL.

MySQL For Developers Course Calendar (5 days)

Call for upcoming dates or on-site delivery.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
spacer
2 Include course and course materials only.
spacer
3 Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
spacer
For government and education pricing, please contact us.

Recommended Pre-requisites

Attendees to this course should have a grasp of the SQL language (PL/PgSQL, SQL*Plus, Transact/SQL, ANSI standard SQL, etc) and relational database concepts.

Course Outline/Agenda

  • Installing and configuring a MySQL server
    • OS and Hardware optimization for MySQL
  • Understanding MySQL client software
    • The mysql client
    • Managing MySQL with mysqladmin
    • Understanding client option files
  • Understanding MySQL utilization of the file system
  • Understanding MySQL storage
    • Choosing a storage engine
    • Transactional versus non-transactional storage engines
    • Understanding the MyISAM storage engine
    • Understanding the InnoDB storage engine
    • Understanding other storage engines (BDB, MEMORY, MERGE, etc.)
  • Understanding the MySQL server security model
  • Implementing effective MySQL security
  • Developing & implementing MySQL stored procedures
  • Developing & implementing MySQL triggers
  • Benchmarking & optimizing MySQL queries using the query optimizer
  • Understanding the FULLTEXT indexing engine
  • Backup, recovery, and bulk load techniques
    • Using mysqlimport to import data
    • Using mysqldump to extract and back up data
    • Performing disk level system backups
    • Understanding online backup methods and strategies
  • Understanding MySQL data types, their uses, and limitations

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Instructional Materials
The following materials are used to deliver this course:
  • MySQL Language Reference
  • OTG Course Guide

Enroll in this course

View upcoming course calendar

info@otg-nc.com
877-258-8987