Welcome to ONLC Training Centers

MySQL Training Classes


Get MySQL live, instructor-led training near you with ONLC's convenient centers or your own location (easy setup)!

MySQL is an open-source relational database management system (RDBMS). Many Fortune 500 companies have adopted MySQL to reap the benefits of an platform-independent open source RDMS. With MySQL you can simplify conversions from other platforms and lower database Total Cost of Ownership. MySQL is used heavily by highly-trafficked websites and is one of the most used open source database platforms.

Learning MySQL will let you not only meet but master database challenges found in the web, cloud, and communications services.

MySQL enables innovative DBAs and developers to create and deploy the next generation of web, embedded, mobile and Cloud/SaaS/PaaS/DBaaS applications on the latest frameworks and platforms. And with the expert instruction you'll receive from ONLC's trainers and the hands-on labs you'll tacking during class, you'll be ready to use MySQL efficiently and effectively!

Instructor-led Training (ILT)

Click for FAQs about remote instructor-led training

ILT classes are live and hands-on training. Training is fully interactive via remote instructor . Attend ILT classes at any of ONLC's hundreds of centers coast to coast click link or from your own location (easy setup!).

Savings Options

Ask about money-saving options for training

Get maximum buying power and flexibility on training with ONLC Learning Credits. A set discount for up to 12 months on technical and end-user classes in instructor-led and self-study formats. The more you buy, the more you save. See ONLC Learning Credits click link.

ONLC Value Adds


Check out our money-back satisfaction guarantee click link and optional free refresher course click link when you attend instructor-led training (ILT) with ONLC!

MySQL Class Schedule

MySQL Querying Fundamentals

Overview
Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau, or Crystal Reports. Analysts and Data Scientists can use SQL to select the data they need for additional analysis and reporting. This class, MySQL Querying: Fundamentals, provides an overview of the SQL statements that can be used to access that data. This course covers MySQL 8.0.

You will:
• Connect to the MySQL Server database and execute a simple query.
• Include a search condition in a simple query.
• Use various functions to perform calculations on data.
• Organize the data obtained from a query before it is displayed on-screen.
• Retrieve data from multiple tables.

Target Student
This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Prerequisites
Some familiarity with database terminology and structure is helpful.

Course Outline

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

Dates Times Location Price
11/8/24 Live Online from our site or yours. $695

12/6/24 Live Online from our site or yours. $695

1/10/25 Live Online from our site or yours. $695

2/7/25 Live Online from our site or yours. $695

More Dates    Quote

Querying MySQL

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
11/4/24 - 11/6/24 Live Online from our site or yours. $2,100

12/2/24 - 12/4/24 Live Online from our site or yours. $2,100

1/6/25 - 1/8/25 Live Online from our site or yours. $2,100

2/3/25 - 2/5/25 Live Online from our site or yours. $2,100

More Dates    Quote

Administering & Developing MySQL Databases

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
11/7/24 Live Online from our site or yours. $695

12/5/24 Live Online from our site or yours. $695

1/9/25 Live Online from our site or yours. $695

2/6/25 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.

News & Offers

ONLC Training Centers has locations coast to coast

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 click link.

 

Train at Home

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 available from ONLC

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

 

Call our Education Advisors for certification and course selection assistance

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

 

spacer

Questions?

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

1.800.288.8221
(weekdays)

ONLC TRAINING CENTERS
800-288-8221
www.onlc.com