1. Courses
2. My SQL

MySQL Courses and Training Certification

• View MySQL Classes & Schedule
• News & Offers

Whether you're a beginner starting with a MySQL course or a seasoned developer looking for a MySQL crash course to refresh your skills, ONLC offers a range of MySQL courses tailored to your needs. You'll gain practical, hands-on experience with real-world applications with our comprehensive training program, which has been rated as the best MySQL course by our learners.

What is MySQL?

MySQL is an open-source relational database management system (RDBMS) widely adopted by Fortune 500 companies for its platform-independent advantages. By using MySQL, organizations can streamline conversions from other database platforms and reduce their overall Total Cost of Ownership. Moreover, it's popular among high-traffic websites and stands out as one of the most utilized open-source database solutions available.

Benefits of Taking MySQL Courses

• Master Database Challenges: Learning MySQL equips you with the ability to tackle and master complex database challenges across web, cloud, and communication services, enhancing your problem-solving skills and technical expertise.
• Deploy Advanced Applications: MySQL courses empower developers and DBAs to create and deploy cutting-edge web, embedded, mobile, and Cloud/SaaS/PaaS/DBaaS applications using the latest frameworks and platforms.
• Enhance Practical Skills: With the hands-on labs and real-world scenarios provided in the courses, you'll gain practical experience, allowing you to apply MySQL efficiently and effectively in your projects.
• Expert Instruction: Benefit from top-notch instruction by ONLC's experienced trainers, ensuring you receive the knowledge and insights needed to leverage MySQL to its fullest potential.
• Career Advancement: Whether you're seeking to upgrade your current skills or pivot into a new role, MySQL courses provide a solid foundation and advanced understanding that can enhance your career prospects.

Instructor-led Training (ILT)

ILT classes offer live, hands-on training that is fully interactive with the guidance of a remote instructor . You can attend ILT classes at any of ONLC's numerous centers nationwide or join from your location with an easy setup!.

Savings Options

Get maximum buying power and flexibility on training with ONLC Learning Credits. A set discount for up to 12 months, you can access technical and end-user classes in both instructor-led and self-study formats. The more you purchase, the greater your savings. Discover ONLC Learning Credits .

ONLC Value Adds

Explore our money-back satisfaction guarantee and optional free refresher course available when you participate in instructor-led training (ILT) with ONLC!

MySQL Class Schedule

Querying MySQL

Course Outline

Overview
MySQL® is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines. This course covers MySQL 8.0.

Audience
Application and web developers.

Prerequisites
Prior experience installing software and programming in any language, such as HTML, is recommended but not required.

COURSE OUTLINE

An introduction to relational databases and SQL
An introduction to client/server systems
An introduction to the relational database model
An introduction to SQL and SQL-based systems
The SQL statements
How to use SQL from an application program

How to use MySQL Workbench and other development tools
An introduction to MySQL Workbench
How to use MySQL Workbench to run SQL statements
How to use the MySQL Reference Manual
How to use the MySQL Command Line Client

How to retrieve data from a single table
An introduction to the SELECT statement
How to code the SELECT clause
How to code the WHERE clause
How to code the ORDER BY clause
How to code the LIMIT clause

How to retrieve data from two or more tables
How to work with inner joins
How to work with outer joins
Other skills for working with joins
How to work with unions

How to insert, update, and delete data
How to create test tables
How to insert new rows
How to update existing rows
How to delete existing rows

How to code summary queries
How to work with aggregate functions
How to group and summarize data
How to code aggregate window functions

How to code subqueries
An introduction to subqueries
How to code subqueries in the WHERE clause
How to use the ALL keyword
How to code subqueries in other clauses
How to work with complex queries
How to work with common table expressions

How to work with data types
The data types
How to convert data

How to use functions
How to work with string data
How to work with numeric data
How to work with date/time data
Other functions you should know about

How to create databases, tables, and indexes
How to work with databases
How to work with tables
How to work with indexes
How to use MySQL Workbench
How to work with character sets and collations
How to work with storage engines

How to create views
An introduction to views
How to work with views

Language skills for writing stored programs
An introduction to stored programs
How to write procedural code

How to use transactions and locking
How to work with transactions
How to work with concurrency and locking

How to create stored procedures and functions

How to code stored procedures
How to code stored functions
How to use Workbench with procedures and functions

	Dates	Times	Location	Price
	1/6/25 - 1/8/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$2,100
	2/3/25 - 2/5/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$2,100
	3/3/25 - 3/5/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$2,100
	3/31/25 - 4/2/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$2,100

More Dates    Quote

Administering & Developing MySQL Databases

Course Outline

Overview
The new version 8.0 of MySQL added a significant number of administrative features to the MySQL database including improved error logging, password policies, privileges, accounts, and backup and recovery. Students will perform these administration functions using the MySQL workbench and command line utilities during the course of training. The course may be taken by itself as a one day course of training or as a four day course which includes the topics from this course and the topics from the three day Querying MySQL course.

Audience
Database administrators.

Prerequisites
Prior experience with MySQL Querying.

COURSE OUTLINE

How to design a database
How to use MySQL Workbench for database design
How to open an existing EER model
How to create a new EER model
How to work with an EER model
How to work with an EER diagram

How to create triggers and events
How to work with triggers
How to create a BEFORE trigger
How to use a trigger to enforce data consistency
How to create an AFTER trigger
How to view or drop triggers
How to work with events
How to turn the event scheduler on or off
How to create an event
How to view, alter, or drop events

An introduction to database administration
Database administration concepts
Database administrator responsibilities
Types of database files
Types of log files
How to monitor the server
How to view the server status
How to view and kill processes
How to view the status variables
How to view the system variables
How to configure the server
How to set system variables using MySQL Workbench
How to set system variables using a text editor
How to set system variables using the SET statement

How to secure a database
An introduction to user accounts
An introduction to SQL statements for user accounts
A summary of privileges
The four privilege levels
The grant tables in the mysql database
How to work with users and privileges
How to create, rename, and drop users
How to specify user account names
How to grant privileges
How to view privileges
How to revoke privileges
How to change passwords
A script that creates users
How to work with roles
How to create, manage, and drop roles
A script that creates users and roles
How to use MySQL Workbench
How to work with users and privileges
How to connect as a user for testing

How to back up and restore a database
Strategies for backing up and restoring a database
A backup strategy
A restore strategy
How to back up a database
How use mysqldump to back up a database
A SQL script file for a database backup
How to set advanced options for a database backup
How to restore a database
How to use a SQL script file to restore a full backup
How to execute statements in the binary log
How to import and export data
How to export data to a file
How to import data from a file
How to check and repair tables
How to use the CHECK TABLE statement
How to repair a MyISAM table
How to repair an InnoDB table
How to use the mysqlcheck program
How to use the myisamchk program

	Dates	Times	Location	Price
	1/9/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$695
	2/6/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$695
	3/6/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$695
	4/3/25	10:00 - 4:45 EST 9:00 - 3:45 CST 8:00 - 2:45 MST 7:00 - 1:45 PST	Live Online from our site or yours.	$695

More Dates    Quote

Other Open Source Programming Classes

Click to view other open source programming classes at ONLC.

Why Learn MySQL with ONLC?

• Expert Instructors: At ONLC, you'll benefit from learning from certified professionals with extensive experience in MySQL. Our experts provide tailored guidance to help you understand complex database concepts, elevating your skills in MySQL development and management.
• Flexible Learning Options: ONLC offers the convenience of attending live, instructor-led MySQL courses online or at one of our many nationwide locations. With flexible scheduling, you can easily find the MySQL course that fits your availability, be it a comprehensive course or a focused MySQL crash course.
• Career Growth and Job Opportunities: Mastering MySQL is a highly valuable skill in the IT industry. Completing our MySQL courses can give you a competitive edge, leading to various opportunities in roles such as Database Administrator, Data Analyst, Software Developer, and more.
• Professional Certification Preparation: Prepare for MySQL professional certification with our MySQL crash course, designed to enhance your understanding and boost your chances of success in the certification exam on your first try. Engage with the best MySQL course options to support your professional advancement.

News & Offers

ONLC Centers Coast to Coast
ONLC provides live, hands-on classes with an online instructor at our hundreds of training centers coast to coast. Our centers are fully equipped and provide an interruption-free environment to focus on learning. Find ONLC centers near me .

Live Classes from Home
You can attend our live, instructor-led classes from the comfort and convenience of your own home. The setup is really easy and you don't have to have the class software on your device. Follow our easy setup video. If you're still not sure about the setup contact an ONLC Advisor toll free for assistance.

Group Training Option
ONLC offers complete learning solutions so training coordinators can quickly and successfully upskill their teams while maintaining their budget. Training can be via our public class schedule or private sessions delivered virtually or onsite. We can also customize content to meet the client's specific needs and technologies. To discuss our group training options and to receive a price quote complete our quick Group Training Request form or call 1.800.288.8221 (weekdays).

Education Advisors to Help You
Our advisors can assist you with questions about our classes, vendor certifications and discount options plus help you select training that is right for you. For assistance, contact our Education Advisors toll free in the USA at 1-800-288-8221 (weekdays).

Questions?

To learn more about ONLC's classes or in the event of questions contact our Education Advisors at:

1.800.288.8221
(weekdays)