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.
¹ Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services. ² Include course and course materials only. ³ 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. 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

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