MySQL Training Courses

MySQL Training

MySQL Database courses

Client Testimonials

SQL Programming

Having a 1-1 training course was very effective, it meant I was less intimidated as I could stop the trainer to ask questions where I may otherwise have been reluctant to ask.

 

Robert Craft - Zurich Employment Services Limited

SQL Programming

Having a 1-1 training course was very effective, it meant I was less intimidated as I could stop the trainer to ask questions where I may otherwise have been reluctant to ask.

 

Robert Craft - Zurich Employment Services Limited

SQL Programming

Having a 1-1 training course was very effective, it meant I was less intimidated as I could stop the trainer to ask questions where I may otherwise have been reluctant to ask.

 

Robert Craft - Zurich Employment Services Limited

SQL Programming

I really can't praise this course and the trainers highly enough! They were both extreemly well qualified and made the subject interesting. The pace of the course was excellent and I've come away feeling very satisfied with the skills I've learned.

 

Susan Elder - Merrill Lynch

SQL Programming

I really can't praise this course and the trainers highly enough! They were both extreemly well qualified and made the subject interesting. The pace of the course was excellent and I've come away feeling very satisfied with the skills I've learned.

 

Susan Elder - Merrill Lynch

SQL Programming

I really can't praise this course and the trainers highly enough! They were both extreemly well qualified and made the subject interesting. The pace of the course was excellent and I've come away feeling very satisfied with the skills I've learned.

 

Susan Elder - Merrill Lynch

SQL Programming

Great teacher with in depth knowledge and real life, relevant examples. Engaging and always ensures a section is understood before moving on to next.

 

Sade Okiji

SQL Programming

Great teacher with in depth knowledge and real life, relevant examples. Engaging and always ensures a section is understood before moving on to next.

 

Sade Okiji

SQL Programming

Great teacher with in depth knowledge and real life, relevant examples. Engaging and always ensures a section is understood before moving on to next.

 

Sade Okiji

SQL Programming

Good

Zan Sue - Net Media Planet

SQL Programming

Good

Zan Sue - Net Media Planet

SQL Programming

Good

Zan Sue - Net Media Planet

SQL Programming

The course content was adapted well to suit my current knowledge and capabilities. Specific topics I requested were covered well.

 

Steven Sirman - Corus Group

SQL Programming

The course content was adapted well to suit my current knowledge and capabilities. Specific topics I requested were covered well.

 

Steven Sirman - Corus Group

SQL Programming

The course content was adapted well to suit my current knowledge and capabilities. Specific topics I requested were covered well.

 

Steven Sirman - Corus Group

SQL Programming

The trainer is a great trainer and has very professional tone. I would definitely like to attend a SQL Advanced course in the near future which is hosted by the same trainer.

 

Mitul. P. Parmar - Cancer Research UK

SQL Programming

The trainer is a great trainer and has very professional tone. I would definitely like to attend a SQL Advanced course in the near future which is hosted by the same trainer.

 

Mitul. P. Parmar - Cancer Research UK

SQL Programming

The trainer is a great trainer and has very professional tone. I would definitely like to attend a SQL Advanced course in the near future which is hosted by the same trainer.

 

Mitul. P. Parmar - Cancer Research UK

MariaDB Database Administration

Enjoyed the pace, delivery and technical knowhow of the trainer

Junaid Kalang- HM Revenue & Customs

MariaDB Database Administration

Enjoyed the pace, delivery and technical knowhow of the trainer

Junaid Kalang- HM Revenue & Customs

MariaDB Database Administration

Enjoyed the pace, delivery and technical knowhow of the trainer

Junaid Kalang- HM Revenue & Customs

MariaDB Database Administration

Enjoyed the pace, delivery and technical knowhow of the trainer

Junaid Kalang- HM Revenue & Customs

MariaDB Database Administration

The facilitator had a great grasp of the subject matter and was able to explain points in a different way, when the learning necessitated it.

James Christie- HM Revenue & Customs

MariaDB Database Administration

The facilitator had a great grasp of the subject matter and was able to explain points in a different way, when the learning necessitated it.

James Christie- HM Revenue & Customs

MariaDB Database Administration

The facilitator had a great grasp of the subject matter and was able to explain points in a different way, when the learning necessitated it.

James Christie- HM Revenue & Customs

MariaDB Database Administration

The facilitator had a great grasp of the subject matter and was able to explain points in a different way, when the learning necessitated it.

James Christie- HM Revenue & Customs

SQL Fundamentals

The trainer was enthusiastic & would answer whatever we needed.

Erica May - Big Fish Games, Inc

SQL Fundamentals

The trainer was enthusiastic & would answer whatever we needed.

Erica May - Big Fish Games, Inc

SQL Fundamentals

The trainer was enthusiastic & would answer whatever we needed.

Erica May - Big Fish Games, Inc

SQL Fundamentals

The course I loved that it was just Andrew (the trainer) & my team.

It was very personalized.

Thanks for flying cross-country for us!

Bronwyn Bailey - PEGCC

SQL Fundamentals

The course I loved that it was just Andrew (the trainer) & my team.

It was very personalized.

Thanks for flying cross-country for us!

Bronwyn Bailey - PEGCC

SQL Fundamentals

The course I loved that it was just Andrew (the trainer) & my team.

It was very personalized.

Thanks for flying cross-country for us!

Bronwyn Bailey - PEGCC

SQL Fundamentals

Trainer was great--nothing to improve.

The way that Andrew (the trainer) customized to first day of training to the level of our group.

Josh Cox - PEGCC

SQL Fundamentals

Trainer was great--nothing to improve.

The way that Andrew (the trainer) customized to first day of training to the level of our group.

Josh Cox - PEGCC

SQL Fundamentals

Trainer was great--nothing to improve.

The way that Andrew (the trainer) customized to first day of training to the level of our group.

Josh Cox - PEGCC

SQL in MySQL

What would you suggest the trainer could do to improve this?

Training was excelent. Nothing to improve, just keep the good work

What did you like the most about the training?

Clear when explaining the topics on the training and the amount and quality of the practical exercices.

Manuel Ruiz Santiago - RRDonnelley GDS

SQL in MySQL

What would you suggest the trainer could do to improve this?

Training was excelent. Nothing to improve, just keep the good work

What did you like the most about the training?

Clear when explaining the topics on the training and the amount and quality of the practical exercices.

Manuel Ruiz Santiago - RRDonnelley GDS

SQL in MySQL

What would you suggest the trainer could do to improve this?

Training was excelent. Nothing to improve, just keep the good work

What did you like the most about the training?

Clear when explaining the topics on the training and the amount and quality of the practical exercices.

Manuel Ruiz Santiago - RRDonnelley GDS

MySQL Database Administration

What did you like the most about the training?

Trainer knowledge

Piotr Milczarek - Red Stack Tech

SQL Advanced in MySQL

What would you suggest the trainer could do to improve this?

It was alright. Nothing to add

Manuel Ruiz Santiago - RRDonnelley GDS

SQL Advanced in MySQL

What would you suggest the trainer could do to improve this?

It was alright. Nothing to add

Manuel Ruiz Santiago - RRDonnelley GDS

SQL Fundamentals

What did you like the most about the training?:

The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning.

Shawn McAndrew - Halifax Regional Municipality

SQL Fundamentals

What did you like the most about the training?:

The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning.

Shawn McAndrew - Halifax Regional Municipality

SQL Fundamentals

What did you like the most about the training?:

The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning.

Shawn McAndrew - Halifax Regional Municipality

SQL Fundamentals

What did you like the most about the training?:

That it was well organized. Topic was divided into parts and for every part there were exercises, I wasn't lost at all.

Monika Klimczak - LUXOFT POLAND SP z. o. o.

SQL Fundamentals

What did you like the most about the training?:

That it was well organized. Topic was divided into parts and for every part there were exercises, I wasn't lost at all.

Monika Klimczak - LUXOFT POLAND SP z. o. o.

SQL Fundamentals

What did you like the most about the training?:

That it was well organized. Topic was divided into parts and for every part there were exercises, I wasn't lost at all.

Monika Klimczak - LUXOFT POLAND SP z. o. o.

MySQL Course Outlines

ID Name Duration Overview
6408 MariaDB Database Administration 14 hours MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery. Installing MariaDB server Installing in Ubuntu/Debian Installing in other Linux Distributions Installation on Windows MariaDB Server Files and Scripts MariaDB Programs MariaDB Server MariaDB Client GUI Tools MariaDB Server Configuration Server Options The Server SQL Mode Server System Variables Dynamic System Variables Server Status Variables Shutdown Process MariaDB Security Issues Securing MariaDB Against Attacks Security-Related Options Security Issues with LOAD DATA LOCAL MariaDB Access Privilege System MariaDB Privilege System Overview Privileges Provided by MariaDB Connecting to the MariaDB Server - Stages Access Control, Stage 1: Connection Verification Access Control, Stage 2: Request Verification Access Denied Errors MariaDB User Account Management Users and Passwords Creating New Users Deleting User Accounts Limiting User Resources Changing Passwords MariaDB Database Maintenance Backup and Recovery Point-in-Time Recovery Maintenance and Crash Recovery myisamchk Syntax and Options Getting Table Information MariaDB Local Setting National Characters and Sorting MariaDB Server Time Zone MariaDB Log Files Error Log General Query Log Update Log Binary Log Slow Query Log Log File Maintenance and Rotation Running Multiple MariaDB Servers on the Same Machine Running Multiple Servers in Windows Running Multiple Servers in Windows as Services Running Multiple Servers in Unix and Linux Using Client Tools in a Multi-Server Environment MariaDB Query Cache The Concept of Query Cache Testing Query Cache with SELECT Configuring Query Cache Checking Query Cache Status and Maintenance The CONNECT Storage Engine Installing the CONNECT storage engine Creating and dropping CONNECT tables Reading and writing CSV data using CONNECT Reading and writing XML data using CONNECT Accessing MariaDB tables using CONNECT Using the XCOL table type Using the PIVOT table type Using the OCCUR table type Exploring Dynamic and Virtual Columns in MariaDB Creating tables with dynamic columns Inserting, updating, and deleting dynamic column data Reading data from a dynamic column Using virtual columns Performance and Usage Statistics Installing the Audit Plugin Using the Audit Plugin Using engine-independent table statistics Using extended statistics Enabling the performance schema Using the performance schema Optimizing and Tuning MariaDB Using SHOW STATUS Controlling MariaDB optimizer strategies Using extended Keys with InnoDB and XtraDB Configuring the MyISAM segmented key cache Configuring threadpool Configuring the Aria pagecache Optimizing queries with the subquery cache Optimizing semijoin subqueries Using microseconds in DATETIME columns Updating the DATETIME and TIMESTAMP columns automatically  
202009 MariaDB 10 Developer Course 28 hours Created DBAs, Administrators and developers who are interested with getting involved in MariaDB 10 based on Linux system. Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Database Concept and SQL and to show it is very easy to understand how to use SQL and manage MariaDB on Linux system. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities After this course, you can apply the knowledge, which you obtained through this course, to the other database systems such as MySQL, Oracle Database, MSSQL Server and PostgreSQL as well. It can be deliver on any distribution (Ubuntu, CentOS are commonly used) This course covers these kinds of topics: Chapter 00 MariaDB 10 Developer Course Introduction Chapter 01 MariaDB 10 Introduction Chapter 02 Startup MariaDB 10 Chapter 03 MariaDB Tools - Command & GUI Chapter 04 Retrieving Data using SQL Chapter 05 Filtering Data using SQL Chapter 06 Summarizing, Grouping & Combining Chapter 07 Database, Table & Indexes Chapter 08 Inserting, Updating & Deleting Data Chapter 09 Table Joins Chapter 10 Subqueries Chapter 11 Views Chapter 12 Stored Procedures Chapter 13 Triggers Chapter 14 MariaDB Datatypes Chapter 15 Transaction Processing Chapter 16 MariaDB User Management Chapter 17 MariaDB Client Tools
161255 MariaDB Galera Cluster Administration 21 hours This course is intended for database administrators. The course presents options for High-Availability solutions using Galera Cluster. You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster. Topic overview Why I need them and what are High-Availability solutions? Cluster concepts ​What is MariaDB Galera Cluster and what it offers to my organization? Galera Cluster Management How to start with Galera - what should I now before installation? Architecture and functionality First steps - Installation Going deeper - Configuration and Set-up Almost like a pro - Administration Performance Operations and operation modes Upgrade Galera Backups and restoring ​Controlling state transfer between nodes Load balancing Monitoring How to deal with Galera multi- master configuration Advanced features Security Scalability Replication ​Advanced configuration
202008 Top 4 Linux/Unix Servers - DNS,Web,Mail and Database 35 hours Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Managing Linux Servers and to show it is very easy to understand Linux/Unix servers. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities. You'll learn how to deploy and manage Top 4 Linux Servers that provide highly useful network services to a mission-critical enterprise environment. It can be deliver on any distribution (Fedora, CentOS are commonly used) This course covers these kinds of topics: Bind as a ;DNS server Apache as a Web Server Postfix as a Mail Server MariaDB as a Database Server Through this course, you will learn from the installation to High level features of each server.
6364 SQL Fundamentals 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases. RDBMS (Relational DataBase Management System) Relational Operators SQL as Declarative Language SQL Syntax SQL Sublanguages DQL, DML, DDL, DCL DQL (Data Query Language) in Detail SELECT clause Column aliases Table aliases Date types and Date functions Group function Table joins JOIN clause UNION operator Nested queries Correlated subqueries DML (Data Manipulation Language) Overview Inserting rows (INSERT) Inserting rows using subquery Updating rows (UPDATE) Deleting rows (DELETE) DDL (Data Definition Language) Overview Creating, altering and dropping objects (CREATE, ALTER, DROP) Creating tables using subquery (CREATE TABLE .... AS SELECT...) CONSTRAINTS Overview NULL i NOT NULL CONSTRAINT clause ENUM type SET type PRIMARY KEY UNIQUE FOREIGN KEY DEFAULT clause Transactions Overview COMMIT ROLLBACK SAVEPOINT Implicit and explicit rollbacks and commits SQL Dialects Overview MySQL Microsoft Access and SQL Server Oracle and PostgreSQL
6365 SQL Advanced in MySQL 7 hours This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features. DQL (Data Query Language) Correlation in FROM, WHERE, SELECT and HAVING clauses Correlation and performance Using CASE, IF, COALESCE functions Using variables Casting and converting Dealing with NULL, NULL-safe operators Using regular expression with REGEXP operator Useful MySQL specific group by functions (GROUP_CONCAT, etc.) GROUP BY WITH ROLLUP EXISTS, ALL, ANY Multitable OUTER JOIN Rewriting subqueries as joins DML (Data Modification Language) Multi-row inserts INSERT by SELECT Using subqueries in DML statements Using variables in DML queries Locking tables and rows Updating data in many tables IGNORE clause REPLACE clause DELETE versus TRUNCATE DDL (Data Definition Language) Creating tables with select Temporary tables Stored Procedures Short introduction to MySQL stored procedures
189 MySQL Database Administration 14 hours MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties. The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery. MySQL Server Files and Scripts MySQL Programs MySQL Server MySQL Client GUI Tools MySQL Server Configuration mysqld Options The Server SQL Mode Server System Variables Dynamic System Variables Server Status Variables Shutdown Process MySQL Security Issues Securing MySQL Against Attacks Security-Related mysqld Options Security Issues with LOAD DATA LOCAL MySQL Access Privilege System MySQL Privilege System Overview Privileges Provided by MySQL Connecting to the MySQL Server - Stages Access Control, Stage 1: Connection Verification Access Control, Stage 2: Request Verification Access Denied Errors MySQL User Account Management Users and Passwords Creating New Users Deleting User Accounts Limiting User Resources Changing Passwords MySQL Database Maintenance Backup and Recovery Point-in-Time Recovery Maintenance and Crash Recovery myisamchk Syntax and Options Getting Table Information MySQL Local Setting National Characters and Sorting MySQL Server Time Zone MySQL Log Files Error Log General Query Log Update Log Binary Log Slow Query Log Log File Maintenance and Rotation Running Multiple MySQL Servers on the Same Machine Running Multiple Servers in Windows Running Multiple Servers in Windows as Services Running Multiple Servers in Unix and Linux Using Client Tools in a Multi-Server Environment MySQL Query Cache The Concept of Query Cache Testing Query Cache with SELECT Configuring Query Cache Checking Query Cache Status and Maintenance
162278 SQL in MySQL 14 hours How to build a query? What opportunities has the SQL in a MySQL database? What is a relational database? What is the structure and SQL commands? Relational database models Relational operators Characteristics of declarative SQL language SQL syntax Division language DQL, DML, DDL, DCL Data Query Language SELECT queries. Aliases columns of tables Service date (DATE types, display functions, formatting) Group Features Combining internal and external tables (JOIN clause) UNION operator Nested Subqueries (the WHERE clause, the table name, column name) Correlated subqueries Data Modification Language Inserting rows (INSERT clause) Inserting rows by request Variation of the rows (UPDATE) Delete rows (DELETE) Data Definition Language Creating, altering and dropping objects (CREATE, ALTER, DROP) Creating tables using subquery (CREATE TABLE .... AS SELECT...) CONSTRAINTS Options NULL and NOT NULL CONSTRAINT clause ENUM type type SET PRIMARY KEY condition UNIQUE condition FOREIGN KEY condition DEFAULT clause Transactions The command COMMIT, ROLLBACK, SAVEPOINT

Upcoming Courses

Weekend MySQL courses, Evening MySQL training, MySQL boot camp, MySQL instructor-led , Evening MySQL courses,Weekend MySQL training, MySQL coaching, MySQL private courses, MySQL classes, MySQL training courses, MySQL trainer , MySQL on-site, MySQL one on one training

Some of our clients