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.

Implementing Databases with MySQL (5 days)


This MySQL course covers diverse topics ranging from MySQL Engine types, to writing queries using Structured Query Language (SQL).

The Implementing Databases with MySQL classes are designed for developers and administrators, and covers many of the fundamental differences between MySQL (from a development perspective) and SQL databases provided by other vendors.

This MySQL class is ideal for those students who plan on taking the MySQL Core Certification examination, and covers all topics included in that examination.

Implementing Databases with MySQL 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

We recommend that you have some experience with computers, and installing software before taking these MySQL classes.

Course Outline/Agenda

Below is a brief course outline, for a more detailed view of this MySQL courses contents, please view the Table of Contents from our Course Guide (link below)
  • Introduction
  • Database Fundamentals
  • Database Normalization
  • MySQL Overview
  • MySQL Software
  • The MySQL Features
  • Installing & Configuring a MySQL Server
  • Using MySQL Clients
  • Using the mysql Client
  • Using mysqlimport & mysqldump
  • Checking Tables for Consistency
  • Other MySQL Clients
  • Using SHOW and DESCRIBE
  • Understanding MySQL Storage
  • Data Definition Language
  • MySQL Data Types
  • The SELECT Statement
  • SQL Expressions and Functions
  • Updating Tables Using SQL
  • Joins
  • Importing and Exporting Data
  • Questions?

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.

Course Details
This course is delivered using our MySQL Course Guide, and the MySQL Language Reference.

The class is delivered by one of our Subject Matter Experts, with experience in a wide range of database engines, including years of MySQL experience.

Instructional Materials
The following materials are used to deliver this course:
  • MySQL Language Reference (MySQL Press)
  • OTG Course Guide
Adobe PDF Logo View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

View upcoming course calendar

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